Release Notes
Read Me First
Installation and Configuration
General Installation, Migration and Configuration Information
4.1 Downloading Installation Packages for All Supported DB2 Clients
4.2 Additional Required Solaris Patch Level
|4.3 Installing DB2 Enterprise-Extended Edition on AIX
|4.4 Netscape LDAP directory support
|4.4.1 Extending the Netscape LDAP schema
|4.5 Support for Windows ME, Windows XP and Windows 2000 Datacenter Edition Platforms
|4.5.1 Windows XP
|4.5.1.1 Limitations
|4.5.2 Windows ME
|4.5.2.1 Limitations
|4.5.3 Windows 2000 Datacenter Server
|4.6 Installing DB2 in Windows 95
4.7 Installing DB2 on Windows 2000
|4.8 Running DB2 under Windows 2000 Terminal Server, Administration Mode
4.9 Microsoft SNA Server and SNA Multisite Update (Two Phase Commit) Support
4.10 Define User ID and Password in IBM Communications Server for Windows NT (CS/NT)
4.10.1 Node Definition
4.11 DB2 Install May Hang if a Removable Drive is Not Attached
4.12 Error SQL1035N when Using CLP on Windows 2000
4.13 Migration Issue Regarding Views Defined with Special Registers
4.14 IPX/SPX Protocol Support on Windows 2000
4.15 Stopping DB2 Processes Before Upgrading a Previous Version of DB2
4.16 Run db2iupdt After Installing DB2 If Another DB2 Product is Already Installed
4.17 Setting up the Linux Environment to Run the DB2 Control Center
4.18 DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition for Linux on S/390
|4.19 Possible Data Loss on Linux for S/390
|4.20 Gnome and KDE Desktop Integration for DB2 on Linux
|4.21 Solaris Kernel Configuration Parameters (Recommended Values)
|4.22 DB2 Universal Database Enterprise - Extended Edition for UNIX Quick Beginnings
4.23 shmseg Kernel Parameter for HP-UX
4.24 Migrating IBM Visual Warehouse Control Databases
|4.25 Migrating Unique Indexes Using the db2uiddl Command
|4.26 64-bit AIX Version Installation Error
|4.26.1 Using SMIT
4.27 Errors During Migration
|4.28 IBM(R) DB2(R) Connect License Activation
|4.28.1 Installing Your License Key and Setting the License Type Using the License Center
|4.28.2 Installing your License Key and Setting License Type Using the db2licm Command
|4.28.3 License Considerations for Distributed Installations
4.29 Accessing Warehouse Control Databases
4.30 Trial Products on Enterprise Edition UNIX CD-ROMs
4.31 Trial Products on DB2 Connect Enterprise Edition UNIX CD-ROMs
|4.32 Additional Configuration Needed Before Installing the Information Catalog Center for the Web
|4.33 Code Page and Language Support Information - Correction
Data Links Manager Quick Beginnings
|5.1 Support on AIX 5.1
5.2 Dlfm Start Fails with Message: "Error in getting the afsfid for prefix"
5.3 Setting Tivoli Storage Manager Class for Archive Files
5.4 Disk Space Requirements for DFS Client Enabler
5.5 Monitoring the Data Links File Manager Back-end Processes on AIX
5.6 Installing and Configuring DB2 Data Links Manager for AIX: Additional Installation Considerations in DCE-DFS Environments
5.7 Failed "dlfm add_prefix" Command
5.8 In the Rare Event that the Copy Daemon Does Not Stop on dlfm stop
5.9 Installing and Configuring DB2 Data Links Manager for AIX: Installing DB2 Data Links Manager on AIX Using the db2setup Utility
5.10 Installing and Configuring DB2 Data Links Manager for AIX: DCE-DFS Post-Installation Task
5.11 Installing and Configuring DB2 Data Links Manager for AIX: Manually Installing DB2 Data Links Manager Using Smit
5.12 Installing and Configuring DB2 Data Links DFS Client Enabler
5.13 Installing and Configuring DB2 Data Links Manager for Solaris
|5.14 Administrator Group Privileges in Data Links on Windows NT
5.15 Minimize Logging for Data Links File System Filter (DLFF) Installation
5.15.1 Logging Messages after Installation
|5.15.2 Minimizing Logging on Sun Solaris Systems
5.16 DATALINK Restore
5.17 Drop Data Links Manager
5.18 Uninstalling DLFM Components Using SMIT May Remove Additional Filesets
5.19 Before You Begin/Determine Hostname
5.20 Working with the Data Links File Manager: Cleaning up After Dropping a DB2 Data Links Manager from a DB2 Database
5.21 User Action for dlfm Client_conf Failure
5.22 DLFM1001E (New Error Message)
5.23 DLFM Setup Configuration File Option
|5.24 Potential Problem When Restoring Files
5.25 Error when Running Data Links/DFS Script dmapp_prestart on AIX
|5.26 Tivoli Space Manager Integration with Data Links
|5.26.1 Restrictions and Limitations
5.27 Chapter 4. Installing and Configuring DB2 Data Links Manager for AIX
5.27.1 Common Installation Considerations
5.27.1.1 Migrating from DB2 File Manager Version 5.2 to DB2 Data Links Manager Version 7
|5.28 Chapter 6. Verifying the Installation on AIX
|5.28.1 Workarounds in NFS environments
Installation and Configuration Supplement
6.1 Chapter 5. Installing DB2 Clients on UNIX Operating Systems
|6.1.1 HP-UX Kernel Configuration Parameters
6.2 Chapter 12. Running Your Own Applications
6.2.1 Binding Database Utilities Using the Run-Time Client
6.2.2 UNIX Client Access to DB2 Using ODBC
|6.3 Chapter 24. Setting Up a Federated System to Access Multiple Data Sources
|6.3.1 Federated Systems
|6.3.2 Restriction
|6.3.3 Installing DB2 Relational Connect
|6.3.3.1 Installing DB2 Relational Connect on Windows NT servers
|6.3.3.2 Installing DB2 Relational Connect on UNIX Servers
|6.3.4 Chapter 24. Setting Up a Federated System to Access Multiple Data Sources
|6.3.4.1 Understanding the schema used with nicknames
|6.3.4.2 Issues when restoring a federated database onto a different federated server
|6.4 Chapter 26. Accessing Oracle Data Sources
|6.4.1 Documentation Errors
|6.5 Avoiding problems when working with remote LOBs
|6.6 Accessing Sybase Data Sources
|6.6.1 Adding Sybase Data Sources to a Federated Server
|6.6.1.1 Step 1: Set the environment variables and update the profile registry (AIX and Solaris only)
|6.6.1.2 Step 2: Link DB2 to Sybase client software (AIX and Solaris only)
|6.6.1.3 Step 3: Recycle the DB2 instance (AIX and Solaris only)
|6.6.1.4 Step 4: Create and set up an interfaces file
|6.6.1.5 Step 5: Create the wrapper
|6.6.1.6 Step 6: Optional: Set the DB2_DJ_COMM environment variable
|6.6.1.7 Step 7: Create the server
|6.6.1.8 Step 8: Optional: Set the CONNECTSTRING server option
|6.6.1.9 Step 9: Create a user mapping
|6.6.1.10 Step 10: Create nicknames for tables and views
|6.6.2 Specifying Sybase code pages
|6.7 Accessing Microsoft SQL Server Data Sources using ODBC (new chapter)
|6.7.1 Adding Microsoft SQL Server Data Sources to a Federated Server
|6.7.1.1 Step 1: Set the environment variables (AIX only)
|6.7.1.2 Step 2: Run the shell script (AIX only)
|6.7.1.3 Step 3: Optional: Set the DB2_DJ_COMM environment variable (AIX only)
|6.7.1.4 Step 4: Recycle the DB2 instance (AIX only)
|6.7.1.5 Step 5: Create the wrapper
|6.7.1.6 Step 6: Create the server
|6.7.1.7 Step 7: Create a user mapping
|6.7.1.8 Step 8: Create nicknames for tables and views
|6.7.1.9 Step 9: Optional: Obtain ODBC traces
|6.7.2 Reviewing Microsoft SQL Server code pages (Windows NT only)
6.8 Accessing Informix Data Sources (new chapter)
6.8.1 Adding Informix Data Sources to a Federated Server
6.8.1.1 Step 1: Set the environment variables and update the profile registry
6.8.1.2 Step 2: Link DB2 to Informix client software
6.8.1.3 Step 3: Recycle the DB2 instance
|6.8.1.4 Step 4: Create the Informix sqlhosts file
6.8.1.5 Step 5: Create the wrapper
6.8.1.6 Step 6: Optional: Set the DB2_DJ_COMM environment variable
6.8.1.7 Step 7: Create the server
6.8.1.8 Step 8: Create a user mapping
6.8.1.9 Step 9: Create nicknames for tables, views, and Informix synonyms
Administration
Administration Guide
|7.1 Update Available
Administration Guide: Planning
|8.1 Chapter 8. Physical Database Design
|8.1.1 Table Space Design Considerations
|8.1.1.1 Optimizing Table Space Performance when Data is Place on Raid
|8.1.2 Partitioning Keys
8.2 Appendix D. Incompatibilities Between Releases
|8.2.1 Error SQL30081N not Returned when Lost Connection is Detected
8.3 Appendix E. National Language Support (NLS)
|8.3.1 Country/Region Code and Code Page Support:
|8.3.2 Import/Export/Load Considerations -- Restrictions for Code Pages 1394 and 5488
|8.3.3 Datetime Values
|8.3.3.1 String Representations of Datetime Values
|8.3.3.2 Date Strings
|8.3.3.3 Time Strings
|8.3.3.4 Time Stamp Strings
|8.3.3.5 Character Set Considerations
|8.3.3.6 Date and Time Formats
|Administration Guide: Implementation
|9.1 Chapter 8. Recovering a Database
|9.1.1 How to Use Suspended I/O
|9.2 New Method for Specifying DMS containers on Windows 2000 and Later Systems
|9.3 Example for Extending Control Center
|Administration Guide: Performance
|10.1 System Temporary Table Schemas
|10.2 Chapter 8. Operational Performance
|10.2.1 Block- Based Buffer Pool
|10.2.1.1 Block-based Buffer Pool Examples
|10.3 Chapter 10. Scaling Your Configuration Through Adding Processors
|10.3.1 Problems When Adding Nodes to a Partitioned Database
|10.4 Chapter 13. Configuring DB2
|10.4.1 Log Archive Completion Now Checked More Frequently
|10.5 DB2 Registry and Environment Variables
|10.5.1 Corrections to Performance Variables
|10.5.2 Corrections and Additions to Miscellaneous Registry Variables
|10.5.3 Corrections and Additions to General Registry Variables
|Administering Satellites Guide and Reference
|11.1 Setting up Version 7.2 DB2 Personal Edition and DB2 Workgroup Edition as Satellites
|11.1.1 Prerequisites
|11.1.1.1 Installation Considerations
|11.1.2 Configuring the Version 7.2 System for Synchronization
|11.1.3 Installing FixPak 2 or Higher on a Version 6 Enterprise Edition System
|11.1.3.1 Upgrading Version 6 DB2 Enterprise Edition for Use as the DB2 Control Server
|11.1.4 Upgrading a Version 6 Control Center and Satellite Administration Center
|Command Reference
|12.1 Update Available
|12.2 db2updv7 - Update Database to Version 7 Current Fix Level
|12.3 REBIND
|Missing value
|12.4 db2inidb - Initialize a Mirrored Database
|12.4.1 Usage Information
|12.5 Additional Option in the GET ROUTINE Command
|GET ROUTINE
|12.6 CREATE DATABASE
|Data Recovery and High Availability Guide and Reference
|13.1 Data Recovery and High Availability Guide and Reference Available Online
|13.2 New Backup and Restore Behavior When LOGRETAIN=CAPTURE
|13.3 NEWLOGPATH2 Now Called DB2_NEWLOGPATH2
|13.4 Choosing a Backup Method for DB2 Data Links Manager on AIX or Solaris
|13.5 Tivoli Storage Manager -- LAN Free Data Transfer
Data Movement Utilities Guide and Reference
|14.1 Change to LOB File Handling by Export, Import and Load
|14.1.1 IXF considerations
|14.2 Code Page Support for Import, Export and Load Utilities
|14.3 db2relocatedb (new command)
|db2relocatedb - Relocate Database
|14.4 db2move -- New Options Available
|Moving Data Using the db2move Tool
14.5 Chapter 2. Import
14.5.1 Using Import with Buffered Inserts
14.6 Chapter 3. Load
14.6.1 Pending States After a Load Operation
14.6.2 Load Restrictions and Limitations
14.6.3 totalfreespace File Type Modifier
14.7 Chapter 4. AutoLoader
14.7.1 rexecd Required to Run AutoLoader When Authentication Set to YES
14.8 AutoLoader May Hang During a Fork
14.9 Appendix C. Export/Import/Load Utility File Formats
Replication Guide and Reference
15.1 Replication and Non-IBM Servers
15.2 Replication on Windows 2000
|15.3 Known Error When Saving SQL Files
|15.4 DB2 Maintenance
|15.5 Data Difference Utility on the Web
15.6 Chapter 3. Data Replication Scenario
15.6.1 Replication Scenarios
15.7 Chapter 5. Planning for Replication
15.7.1 Table and Column Names
15.7.2 DATALINK Replication
15.7.3 LOB Restrictions
15.7.4 Planning for Replication
15.8 Chapter 6. Setting up Your Replication Environment
15.8.1 Update-anywhere Prerequisite
15.8.2 Setting Up Your Replication Environment
15.9 Chapter 8. Problem Determination
15.10 Chapter 9. Capture and Apply for AS/400
15.11 Chapter 10. Capture and Apply for OS/390
|15.11.1 Prerequisites for DB2 DataPropagator for OS/390
|15.11.2 UNICODE and ASCII Encoding Schemes on OS/390
|15.11.2.1 Choosing an Encoding Scheme
|15.11.2.2 Setting Encoding Schemes
15.12 Chapter 11. Capture and Apply for UNIX platforms
|15.12.1 Setting Environment Variables for Capture and Apply on UNIX and Windows
15.13 Chapter 14. Table Structures
15.14 Chapter 15. Capture and Apply Messages
15.15 Appendix A. Starting the Capture and Apply Programs from Within an Application
System Monitor Guide and Reference
16.1 db2ConvMonStream
Troubleshooting Guide
17.1 Starting DB2 on Windows 95, Windows 98, and Windows ME When the User Is Not Logged On
|17.2 Chapter 1. Good Troubleshooting Practices
|17.2.1 Problem Analysis and Environment Collection Tool
|17.2.1.1 Collection Outputs
|17.2.1.2 Viewing detailed_system_info.html
|17.2.1.3 Viewing DB2 Support Tool Syntax One Page at a Time
|17.3 Chapter 2. Troubleshooting the DB2 Universal Database Server
|17.4 Chapter 8. Troubleshooting DB2 Data Links Manager
Using DB2 Universal Database on 64-bit Platforms
18.1 Chapter 5. Configuration
18.1.1 LOCKLIST
18.1.2 shmsys:shminfo_shmmax
18.2 Chapter 6. Restrictions
XML Extender Administration and Programming
|MQSeries
|20.1 Installation and Configuration for the DB2 MQSeries Functions
|20.1.1 Install MQSeries
|20.1.2 Install MQSeries AMI
|20.1.3 Enable DB2 MQSeries Functions
|20.2 MQSeries Messaging Styles
|20.3 Message Structure
|20.4 MQSeries Functional Overview
|20.4.1 Limitations
|20.4.2 Error Codes
|20.5 Usage Scenarios
|20.5.1 Basic Messaging
|20.5.2 Sending Messages
|20.5.3 Retrieving Messages
|20.5.4 Application-to-Application Connectivity
|20.5.4.1 Request/Reply Communications
|20.5.4.2 Publish/Subscribe
|20.6 enable_MQFunctions
|enable_MQFunctions
|20.7 disable_MQFunctions
|disable_MQFunctions
Administrative Tools
|Additional Setup Before Running Tools
|21.1 Disabling the Floating Point Stack on Linux
|21.2 Specific Java Level Required in a Japanese Linux Environment
Control Center
22.1 Ability to Administer DB2 Server for VSE and VM Servers
22.2 Java 1.2 Support for the Control Center
22.3 "Invalid shortcut" Error when Using the Online Help on the Windows Operating System
22.4 Keyboard Shortcuts Not Working
22.5 Java Control Center on OS/2
22.6 "File access denied" Error when Attempting to View a Completed Job in the Journal on the Windows Operating System
22.7 Multisite Update Test Connect
22.8 Control Center for DB2 for OS/390
22.9 Required Fix for Control Center for OS/390
22.10 Change to the Create Spatial Layer Dialog
22.11 Troubleshooting Information for the DB2 Control Center
22.12 Control Center Troubleshooting on UNIX Based Systems
22.13 Possible Infopops Problem on OS/2
22.14 Help for the jdk11_path Configuration Parameter
22.15 Solaris System Error (SQL10012N) when Using the Script Center or the Journal
22.16 Help for the DPREPL.DFT File
22.17 Launching More Than One Control Center Applet
22.18 Online Help for the Control Center Running as an Applet
22.19 Running the Control Center in Applet Mode (Windows 95)
|22.20 Working with Large Query Results
Command Center
|23.1 Command Center Interactive Page Now Recognizes Statement Terminator
Information Center
|24.1 Corrections to the Java Samples Document
24.2 "Invalid shortcut" Error on the Windows Operating System
24.3 Opening External Web Links in Netscape Navigator when Netscape is Already Open (UNIX Based Systems)
24.4 Problems Starting the Information Center
Wizards
25.1 Setting Extent Size in the Create Database Wizard
|25.2 MQSeries Assist Wizard
|25.3 OLE DB Assist Wizard
|25.4 Building Java stored procedures for OS/390 using Stored Procedure Builder
Business Intelligence
Business Intelligence Tutorial
26.1 Revised Business Intelligence Tutorial
DB2 Universal Database Quick Tour
|Data Warehouse Center Administration Guide
|28.1 Update Available
|28.2 Warehouse Server Enhancements
|28.3 Using the OS/390 Agent to Run a Trillium Batch System JCL
|28.4 Two New Sample Programs in the Data Warehouse Center
|28.5 Managing ETI.Extract(R) Conversion Programs with DB2 Warehouse Manager Updated
|28.6 Importing and Exporting Metadata Using the Common Warehouse Metadata Interchange (CWMI)
|28.6.1 Introduction
|28.6.2 Importing Metadata
|28.6.3 Updating Your Metadata After Running the Import Utility
|28.6.4 Exporting Metadata
|28.7 Tag Language Metadata Import/Export Utility
|28.7.1 Key Definitions
|28.7.2 Step and Process Schedules
|28.8 SAP Step Information
|28.8.1 Possible to Create Logically Inconsistent Table
|28.9 SAP Connector Information
|28.9.1 SAP Connector Installation Restrictions
|28.9.2 Performance of GetDetail BAPI
DB2 OLAP Starter Kit
|29.1 OLAP Server Web Site
|29.2 Supported Operating System Service Levels
29.3 Completing the DB2 OLAP Starter Kit Setup on UNIX
|29.4 Additional Configuration for the Solaris Operating Environment
|29.5 Additional Configuration for All Operating Systems
|29.6 Configuring ODBC for the OLAP Starter Kit
|29.6.1 Configuring Data Sources on UNIX Systems
|29.6.1.1 Configuring ODBC Environment Variables
|29.6.1.2 Editing the odbc.ini File
|29.6.1.3 Adding a Data Source to an odbc.ini File
|29.6.1.4 Example of ODBC Settings for DB2
|29.6.1.5 Example of ODBC Settings for Oracle
|29.6.2 Configuring the OLAP Metadata Catalog on UNIX Systems
|29.6.3 Configuring Data Sources on Windows Systems
|29.6.4 Configuring the OLAP Metadata Catalog on Windows Systems
|29.6.5 After You Configure a Data Source
29.7 Logging in from OLAP Starter Kit Desktop
29.7.1 Starter Kit Login Example
29.8 Manually Creating and Configuring the Sample Databases for OLAP Starter Kit
|29.9 Migrating Applications to OLAP Starter Kit Version 7.2
|29.10 Known Problems and Limitations
29.11 OLAP Spreadsheet Add-in EQD Files Missing
Information Catalog Manager Administration Guide
30.1 Information Catalog Manager Initialization Utility
30.1.1
30.1.2 Licensing issues
30.1.3 Installation Issues
|30.2 Enhancement to Information Catalog Manager
|30.3 Incompatibility between Information Catalog Manager and Sybase in the Windows Environment
30.4 Accessing DB2 Version 5 Information Catalogs with the DB2 Version 7 Information Catalog Manager
30.5 Setting up an Information Catalog
30.6 Exchanging Metadata with Other Products
30.7 Exchanging Metadata using the flgnxoln Command
30.8 Exchanging Metadata using the MDISDGC Command
30.9 Invoking Programs
Information Catalog Manager Programming Guide and Reference
31.1 Information Catalog Manager Reason Codes
Information Catalog Manager User's Guide
Information Catalog Manager: Online Messages
33.1 Corrections to FLG messages
33.1.1 Message FLG0260E
33.1.2 Message FLG0051E
33.1.3 Message FLG0003E
33.1.4 Message FLG0372E
33.1.5 Message FLG0615E
Information Catalog Manager: Online Help
34.1 Information Catalog Manager for the Web
DB2 Warehouse Manager Installation Guide
|35.1 DB2 Warehouse Manager Installation Guide Update Available
|35.2 Software requirements for warehouse transformers
|35.3 Post-installation considerations for the iSeries agent
|35.4 Before using transformers with the iSeries warehouse agent
Query Patroller Administration Guide
36.1 DB2 Query Patroller Client is a Separate Component
|36.2 Changing the Node Status
36.3 Migrating from Version 6 of DB2 Query Patroller Using dqpmigrate
36.4 Enabling Query Management
|36.5 Location of Table Space for Control Tables
|36.6 New Parameters for dqpstart Command
|36.7 New Parameter for iwm_cmd Command
|36.8 New Registry Variable: DQP_RECOVERY_INTERVAL
36.9 Starting Query Administrator
36.10 User Administration
|36.11 Data Source Administration
36.12 Creating a Job Queue
|36.13 Job Accounting Table
36.14 Using the Command Line Interface
36.15 Query Enabler Notes
36.16 DB2 Query Patroller Tracker may Return a Blank Column Page
|36.17 Additional Information for DB2 Query Patroller Tracker GUI Tool
|36.18 Query Patroller and Replication Tools
|36.19 Improving Query Patroller Performance
36.20 Lost EXECUTE Privilege for Query Patroller Users Created in Version 6
36.21 Query Patroller Restrictions
36.22 Appendix B. Troubleshooting DB2 Query Patroller Clients
Application Development
Administrative API Reference
37.1 db2ArchiveLog (new API)
db2ArchiveLog
37.2 db2ConvMonStream
37.3 db2DatabasePing (new API)
db2DatabasePing - Ping Database
37.4 db2HistData
37.5 db2HistoryOpenScan
37.6 db2XaGetInfo (new API)
db2XaGetInfo - Get Information for Resource Manager
37.7 db2XaListIndTrans (new API that supercedes sqlxphqr)
db2XaListIndTrans - List Indoubt Transactions
37.8 db2GetSnapshot - Get Snapshot
|37.9 Forget Log Record
37.10 sqlaintp - Get Error Message
37.11 sqlbctcq - Close Tablespace Container Query
|37.12 sqleseti - Set Client Information
37.13 sqlubkp - Backup Database
37.14 sqlureot - Reorganize Table
37.15 sqlurestore - Restore Database
37.16 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
37.17 SQLFUPD
37.17.1 locklist
37.18 SQLEDBDESC
Application Building Guide
|38.1 Update Available
|38.2 Additional Notes for Distributing Compiled SQL Procedures
|Application Development Guide
|39.1 Update Available
|39.2 New Requirements for executeQuery and executeUpdate
|39.3 JDBC Driver Support for Additional Methods
|39.4
|39.5 IBM OLE DB Provider for DB2 UDB
CLI Guide and Reference
40.1 Binding Database Utilities Using the Run-Time Client
40.2 Using Static SQL in CLI Applications
40.3 Limitations of JDBC/ODBC/CLI Static Profiling
40.4 ADT Transforms
|40.5 Chapter 1. Introduction to CLI
|40.5.1 Differences Between DB2 CLI and Embedded SQL
40.6 Chapter 3. Using Advanced Features
|40.6.1 Writing Multi-Threaded Applications
40.6.2 Writing a DB2 CLI Unicode Application
40.6.2.1 Unicode Functions
40.6.2.2 New datatypes and Valid Conversions
40.6.2.3 Obsolete Keyword/Patch Value
40.6.2.4 Literals in Unicode Databases
40.6.2.5 New CLI Configuration Keywords
|40.6.3 Microsoft Transaction Server (MTS) as Transaction Monitor
40.6.4 Scrollable Cursors
40.6.4.1 Server-side Scrollable Cursor Support for OS/390
40.6.5 Using Compound SQL
40.6.6 Using Stored Procedures
|40.6.6.1 Privileges for building and debugging SQL and Java stored procedures
40.6.6.2 Writing a Stored Procedure in CLI
40.6.6.3 CLI Stored Procedures and Autobinding
40.7 Chapter 4. Configuring CLI/ODBC and Running Sample Applications
|40.7.1 Configuration Keywords
|40.7.1.1 CURRENTFUNCTIONPATH
|40.7.1.2 SKIPTRACE
40.8 Chapter 5. DB2 CLI Functions
40.8.1 SQLBindFileToParam - Bind LOB File Reference to LOB Parameter
|40.8.2 SQLColAttribute -- Return a Column Attribute
|40.8.3 SQLGetData - Get Data From a Column
|40.8.4 SQLGetInfo - Get General Information
|40.8.5 SQLGetLength - Retrieve Length of A String Value
40.8.6 SQLNextResult - Associate Next Result Set with Another Statement Handle
40.8.6.1 Purpose
40.8.6.2 Syntax
40.8.6.3 Function Arguments
40.8.6.4 Usage
40.8.6.5 Return Codes
40.8.6.6 Diagnostics
40.8.6.7 Restrictions
40.8.6.8 References
|40.8.7 SQLSetEnvAttr - Set Environment Attribute
|40.8.8 SQLSetStmtAttr -- Set Options Related to a Statement
|40.9 Appendix C. DB2 CLI and ODBC
|40.9.1 ODBC Unicode Applications
|40.9.1.1 ODBC Unicode Versus Non-Unicode Applications
40.10 Appendix D. Extended Scalar Functions
40.10.1 Date and Time Functions
40.11 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility
|Message Reference
|41.1 Update Available
|41.2 Message Updates
|41.3 Reading Message Text Online
SQL Reference
|42.1 SQL Reference Update Available
|42.2 Enabling the New Functions and Procedures
|42.3 SET SERVER OPTION - Documentation Error
|42.4 GRANT (Table, View, or Nickname Privileges) - Documentation Error
42.5 MQSeries Information
42.5.1 Scalar Functions
|42.5.1.1 MQPUBLISH
|42.5.1.2 MQREADCLOB
|42.5.1.3 MQRECEIVECLOB
|42.5.1.4 MQSEND
42.5.2 Table Functions
|42.5.2.1 MQREADALLCLOB
|42.5.2.2 MQRECEIVEALLCLOB
|42.5.3 CLOB data now supported in MQSeries functions
42.6 Data Type Information
42.6.1 Promotion of Data Types
42.6.2 Casting between Data Types
42.6.3 Assignments and Comparisons
42.6.3.1 String Assignments
42.6.3.2 String Comparisons
42.6.4 Rules for Result Data Types
42.6.4.1 Character and Graphic Strings in a Unicode Database
42.6.5 Rules for String Conversions
42.6.6 Expressions
42.6.6.1 With the Concatenation Operator
42.6.7 Predicates
|42.7 Unicode Information
|42.7.1 Scalar Functions and Unicode
|42.8 GRAPHIC type and DATE/TIME/TIMESTAMP compatibility
|42.8.1 String representations of datetime values
|42.8.1.1 Date strings, time strings, and datetime strings
|42.8.2 Casting between data types
|42.8.3 Assignments and comparisons
|42.8.4 Datetime assignments
|42.8.5 DATE
|42.8.6 GRAPHIC
|42.8.7 TIME
|42.8.8 TIMESTAMP
|42.8.9 VARGRAPHIC
42.9 Larger Index Keys for Unicode Databases
42.9.1 ALTER TABLE
42.9.2 CREATE INDEX
42.9.3 CREATE TABLE
|42.10 ALLOCATE CURSOR Statement Notes Section Incorrect
|42.11 Additional Options in the GET DIAGNOSTICS Statement
|GET DIAGNOSTICS Statement
|42.12 ORDER BY in Subselects
|42.12.1 fullselect
|42.12.2 subselect
|42.12.3 order-by-clause
|42.12.4 select-statement
|SELECT INTO statement
|42.12.5 OLAP Functions (window-order-clause)
|New Input Argument for the GET_ROUTINE_SAR Procedure
|Required Authorization for the SET INTEGRITY Statement
|Appendix N. Exception Tables
Unicode Updates
46.1 Introduction
46.1.1 DB2 Unicode Databases and Applications
46.1.2 Documentation Updates
Connecting to Host Systems
|DB2 Connect User's Guide
|47.1 Increasing DB2 Connect data transfer rate
|47.1.1 Extra Query Blocks
|47.1.2 RFC-1323 Window Scaling
|47.2 DB2 Connect Support for Loosely Coupled Transactions
|47.3 Kerberos support
Connectivity Supplement
48.1 Setting Up the Application Server in a VM Environment
48.2 CLI/ODBC/JDBC Configuration PATCH1 and PATCH2 Settings
Additional Information
Additional Information
49.1 DB2 Everywhere is Now DB2 Everyplace
49.2 Accessibility Features of DB2 UDB Version 7
49.2.1 Keyboard Input and Navigation
49.2.1.1 Keyboard Input
49.2.1.2 Keyboard Focus
49.2.2 Features for Accessible Display
49.2.2.1 High-Contrast Mode
49.2.2.2 Font Settings
49.2.2.3 Non-dependence on Color
49.2.3 Alternative Alert Cues
49.2.4 Compatibility with Assistive Technologies
49.2.5 Accessible Documentation
49.3 Mouse Required
49.4 Attempting to Bind from the DB2 Run-time Client Results in a "Bind files not found" Error
49.5 Search Discovery
49.6 Memory Windows for HP-UX 11
49.7 Uninstalling DB2 DFS Client Enabler
49.8 Client Authentication on Windows NT
49.9 Federated Systems Restrictions
|49.10 Federated Limitations with MPP Partitioned Tables
49.11 DataJoiner Restriction
49.12 Hebrew Information Catalog Manager for Windows NT
49.13 DB2's SNA SPM Fails to Start After Booting Windows
49.14 Service Account Requirements for DB2 on Windows NT and Windows 2000
49.15 Need to Commit all User-defined Programs That Will Be Used in the Data Warehouse Center (DWC)
49.16 Client-side Caching on Windows NT
|49.17 Life Sciences Data Connect
|49.17.1 New Wrappers
|49.17.2 Notices-
49.18 Enhancement to SQL Assist
|49.19 Help for Backup and Restore Commands
49.20 "Warehouse Manager" Should Be "DB2 Warehouse Manager"
Appendixes
Appendix A. Notices
A.1 Trademarks
Index
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]