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 Operating Environment Patch Level
|4.3 Installing DB2 Enterprise-Extended Edition on AIX
|4.4 Additional Installation Steps for AIX CICS Users
|4.5 Netscape LDAP directory support
|4.5.1 Extending the Netscape LDAP schema
|4.6 Support for Windows ME, Windows XP and Windows 2000 Datacenter Edition Platforms
|4.6.1 Windows XP
|4.6.1.1 Limitations
|4.6.2 Windows ME
|4.6.2.1 Limitations
|4.6.3 Windows 2000 Datacenter Server
|4.7 Installing DB2 in Windows 95
4.8 Installing DB2 on Windows 2000
|4.9 Running DB2 under Windows 2000 Terminal Server, Administration Mode
4.10 Microsoft SNA Server and SNA Multisite Update (Two Phase Commit) Support
4.11 Define User ID and Password in IBM Communications Server for Windows NT (CS/NT)
4.11.1 Node Definition
4.12 DB2 Install May Hang if a Removable Drive is Not Attached
4.13 Error SQL1035N when Using CLP on Windows 2000
4.14 Migration Issue Regarding Views Defined with Special Registers
4.15 IPX/SPX Protocol Support on Windows 2000
4.16 Stopping DB2 Processes Before Upgrading a Previous Version of DB2
4.17 Run db2iupdt After Installing DB2 If Another DB2 Product is Already Installed
4.18 Setting up the Linux Environment to Run the DB2 Control Center
4.19 DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition for Linux on S/390
|4.20 Possible Data Loss on Linux for S/390
|4.21 Gnome and KDE Desktop Integration for DB2 on Linux
|4.22 Solaris Kernel Configuration Parameters (Recommended Values)
|4.23 DB2 Universal Database Enterprise - Extended Edition for UNIX Quick Beginnings
4.24 shmseg Kernel Parameter for HP-UX
4.25 Migrating IBM Visual Warehouse Control Databases
|4.26 Migrating Unique Indexes Using the db2uiddl Command
|4.27 64-bit AIX Version Installation Error
|4.27.1 Using SMIT
4.28 Errors During Migration
|4.29 IBM(R) DB2(R) Connect License Activation
|4.29.1 Installing Your License Key and Setting the License Type Using the License Center
|4.29.2 Installing your License Key and Setting License Type Using the db2licm Command
|4.29.3 License Considerations for Distributed Installations
4.30 Accessing Warehouse Control Databases
4.31 Trial Products on Enterprise Edition UNIX CD-ROMs
4.32 Trial Products on DB2 Connect Enterprise Edition UNIX CD-ROMs
|4.33 Merant Driver Manager and the DB2 UDB Version 7 ODBC Driver on UNIX
|4.34 Additional Configuration Needed Before Installing the Information Catalog Center for the Web
|4.35 Code Page and Language Support Information - Correction
DB2 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 Operating Systems
|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 DB2 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 Operating Environment only)
|6.6.1.3 Step 3: Recycle the DB2 instance (AIX and Solaris Operating Environment 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.2.2 Export Utility Requires FixPak 7 or Later to Properly Handle Identity Attributes
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 New Method for Specifying DMS containers on Windows 2000 and Later Systems
|9.2 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 New Parameters for Registry Variable DB2BPVARS
|10.5.3 Corrections and Additions to Miscellaneous Registry Variables
|10.5.4 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 Additional Context for ARCHIVE LOG Usage Note
|12.4 REBIND
|Missing value
|12.5 db2inidb - Initialize a Mirrored Database
|12.5.1 Usage Information
|12.6 db2relocatedb (new command)
|db2relocatedb - Relocate Database
|12.7 db2move
|Database Movement Tool
|12.8 Additional Option in the GET ROUTINE Command
|GET ROUTINE
|12.9 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 Archive Logging Behavior
|13.3 How to Use Suspended I/O for Database Recovery
|13.4 New Backup and Restore Behavior When LOGRETAIN=CAPTURE
|13.5 Incremental Backup and Recovery - Additional Information
|13.6 NEWLOGPATH2 Now Called DB2_NEWLOGPATH2
|13.7 Choosing a Backup Method for DB2 Data Links Manager on AIX or Solaris Operating Environment
|13.8 Tivoli Storage Manager -- LAN Free Data Transfer
Data Movement Utilities Guide and Reference
|14.1 Extended Identity Values Now Fully Supported by Export Utility
|14.2 Change to LOB File Handling by Export, Import, and Load
|14.2.1 IXF Considerations
|14.3 Code Page Support for Import, Export and Load Utilities
14.4 Chapter 2. Import
14.4.1 Using Import with Buffered Inserts
14.5 Chapter 3. Load
14.5.1 Pending States After a Load Operation
14.5.2 Load Restrictions and Limitations
14.5.3 totalfreespace File Type Modifier
14.6 Chapter 4. AutoLoader
14.6.1 rexecd Required to Run AutoLoader When Authentication Set to YES
14.7 AutoLoader May Hang During a Fork on AIX Systems Prior to 4.3.3
14.8 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
|17.5 Chapter 15. Logged Information
|17.5.1 Gathering Stack Traceback Information on UNIX-Based Systems
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 Choosing Redirected Restore Commits You to Restoring the Database
22.2 Ability to Administer DB2 Server for VSE and VM Servers
22.3 Java 1.2 Support for the Control Center
22.4 "Invalid shortcut" Error when Using the Online Help on the Windows Operating System
22.5 Keyboard Shortcuts Not Working
22.6 Java Control Center on OS/2
22.7 "File access denied" Error when Attempting to View a Completed Job in the Journal on the Windows Operating System
22.8 Multisite Update Test Connect
22.9 Control Center for DB2 for OS/390
22.10 Required Fix for Control Center for OS/390
22.11 Change to the Create Spatial Layer Dialog
22.12 Troubleshooting Information for the DB2 Control Center
22.13 Control Center Troubleshooting on UNIX Based Systems
22.14 Possible Infopops Problem on OS/2
22.15 Help for the jdk11_path Configuration Parameter
22.16 Solaris System Error (SQL10012N) when Using the Script Center or the Journal
22.17 Help for the DPREPL.DFT File
22.18 Launching More Than One Control Center Applet
22.19 Online Help for the Control Center Running as an Applet
22.20 Running the Control Center in Applet Mode (Windows 95)
|22.21 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
|Stored Procedure Builder
|25.1 Support for Java Stored Procedures for z/OS or OS/390
|25.2 Support for SQL Stored Procedures for z/OS or OS/390
|25.3 Stored Procedure Builder Reference Update to z/OS or OS/390 Documentation
|25.4 Support for Setting Result Set Properties
|25.5 Dropping Procedures from a DB2 Database on Windows NT
Wizards
26.1 Setting Extent Size in the Create Database Wizard
|26.2 MQSeries Assist Wizard
|26.3 OLE DB Assist Wizard
Business Intelligence
Business Intelligence Tutorial
27.1 Revised Business Intelligence Tutorial
DB2 Universal Database Quick Tour
|Data Warehouse Center Administration Guide
|29.1 Update Available
|29.2 Warehouse Server Enhancements
|29.3 Using the OS/390 Agent to Run a Trillium Batch System JCL
|29.4 Two New Sample Programs in the Data Warehouse Center
|29.5 Managing ETI.Extract(R) Conversion Programs with DB2 Warehouse Manager Updated
|29.6 Importing and Exporting Metadata Using the Common Warehouse Metadata Interchange (CWMI)
|29.6.1 Introduction
|29.6.2 Importing Metadata
|29.6.3 Updating Your Metadata After Running the Import Utility
|29.6.4 Exporting Metadata
|29.7 Tag Language Metadata Import/Export Utility
|29.7.1 Key Definitions
|29.7.2 Step and Process Schedules
|29.8 SAP Step Information
|29.8.1 Possible to Create Logically Inconsistent Table
|29.9 SAP Connector Information
|29.9.1 SAP Connector Installation Restrictions
|29.9.2 Performance of GetDetail BAPI
DB2 OLAP Starter Kit
|30.1 OLAP Server Web Site
|30.2 Supported Operating System Service Levels
30.3 Completing the DB2 OLAP Starter Kit Setup on UNIX
|30.4 Additional Configuration for the Solaris Operating Environment
|30.5 Additional Configuration for All Operating Systems
|30.6 Configuring ODBC for the OLAP Starter Kit
|30.6.1 Configuring Data Sources on UNIX Systems
|30.6.1.1 Configuring ODBC Environment Variables
|30.6.1.2 Editing the odbc.ini File
|30.6.1.3 Adding a Data Source to an odbc.ini File
|30.6.1.4 Example of ODBC Settings for DB2
|30.6.1.5 Example of ODBC Settings for Oracle
|30.6.2 Configuring the OLAP Metadata Catalog on UNIX Systems
|30.6.3 Configuring Data Sources on Windows Systems
|30.6.4 Configuring the OLAP Metadata Catalog on Windows Systems
|30.6.5 After You Configure a Data Source
30.7 Logging in from OLAP Starter Kit Desktop
30.7.1 Starter Kit Login Example
30.8 Manually Creating and Configuring the Sample Databases for OLAP Starter Kit
|30.9 Migrating Applications to OLAP Starter Kit Version 7.2
|30.10 Known Problems and Limitations
30.11 OLAP Spreadsheet Add-in EQD Files Missing
Information Catalog Manager Administration Guide
31.1 Information Catalog Manager Initialization Utility
31.1.1
31.1.2 Licensing issues
31.1.3 Installation Issues
|31.2 Enhancement to Information Catalog Manager
|31.3 Incompatibility between Information Catalog Manager and Sybase in the Windows Environment
31.4 Accessing DB2 Version 5 Information Catalogs with the DB2 Version 7 Information Catalog Manager
31.5 Setting up an Information Catalog
31.6 Exchanging Metadata with Other Products
31.7 Exchanging Metadata using the flgnxoln Command
31.8 Exchanging Metadata using the MDISDGC Command
31.9 Invoking Programs
Information Catalog Manager Programming Guide and Reference
32.1 Information Catalog Manager Reason Codes
Information Catalog Manager User's Guide
Information Catalog Manager: Online Messages
34.1 Corrections to FLG messages
34.1.1 Message FLG0260E
34.1.2 Message FLG0051E
34.1.3 Message FLG0003E
34.1.4 Message FLG0372E
34.1.5 Message FLG0615E
Information Catalog Manager: Online Help
35.1 Information Catalog Manager for the Web
DB2 Warehouse Manager Installation Guide
|36.1 DB2 Warehouse Manager Installation Guide Update Available
|36.2 Software requirements for warehouse transformers
|36.3 Post-installation considerations for the iSeries agent
|36.4 Before using transformers with the iSeries warehouse agent
Query Patroller Administration Guide
37.1 DB2 Query Patroller Client is a Separate Component
|37.2 Changing the Node Status
37.3 Migrating from Version 6 of DB2 Query Patroller Using dqpmigrate
37.4 Enabling Query Management
|37.5 Location of Table Space for Control Tables
|37.6 New Parameters for dqpstart Command
|37.7 New Parameter for iwm_cmd Command
|37.8 New Registry Variable: DQP_RECOVERY_INTERVAL
37.9 Starting Query Administrator
37.10 User Administration
|37.11 Data Source Administration
37.12 Creating a Job Queue
|37.13 Job Accounting Table
37.14 Using the Command Line Interface
37.15 Query Enabler Notes
37.16 DB2 Query Patroller Tracker may Return a Blank Column Page
|37.17 Additional Information for DB2 Query Patroller Tracker GUI Tool
|37.18 Query Patroller and Replication Tools
|37.19 Improving Query Patroller Performance
37.20 Lost EXECUTE Privilege for Query Patroller Users Created in Version 6
37.21 Query Patroller Restrictions
37.22 Appendix B. Troubleshooting DB2 Query Patroller Clients
Application Development
Administrative API Reference
38.1 db2ArchiveLog (new API)
db2ArchiveLog
38.2 db2ConvMonStream
38.3 db2DatabasePing (new API)
db2DatabasePing - Ping Database
38.4 db2HistData
38.5 db2HistoryOpenScan
38.6 db2XaGetInfo (new API)
db2XaGetInfo - Get Information for Resource Manager
38.7 db2XaListIndTrans (new API that supercedes sqlxphqr)
db2XaListIndTrans - List Indoubt Transactions
38.8 db2GetSnapshot - Get Snapshot
|38.9 Forget Log Record
38.10 sqlaintp - Get Error Message
38.11 sqlbctcq - Close Tablespace Container Query
|38.12 sqleseti - Set Client Information
38.13 sqlubkp - Backup Database
38.14 sqlureot - Reorganize Table
38.15 sqlurestore - Restore Database
38.16 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
38.17 SQLFUPD
38.17.1 locklist
38.18 SQLEDBDESC
Application Building Guide
|39.1 Update Available
|39.2 Linux on S/390 and zSeries Support
|39.3 Linux Rexx Support
|39.4 Additional Notes for Distributing Compiled SQL Procedures
|Application Development Guide
|40.1 Update Available
|40.2 Correction to "Debugging Stored Procedures in Java"
|40.3 New Requirements for executeQuery and executeUpdate
|40.4 JDBC Driver Support for Additional Methods
|40.5 IBM OLE DB Provider for DB2 UDB
CLI Guide and Reference
41.1 Binding Database Utilities Using the Run-Time Client
41.2 Using Static SQL in CLI Applications
41.3 Limitations of JDBC/ODBC/CLI Static Profiling
41.4 ADT Transforms
|41.5 Chapter 1. Introduction to CLI
|41.5.1 Differences Between DB2 CLI and Embedded SQL
41.6 Chapter 3. Using Advanced Features
|41.6.1 Writing Multi-Threaded Applications
41.6.2 Writing a DB2 CLI Unicode Application
41.6.2.1 Unicode Functions
41.6.2.2 New datatypes and Valid Conversions
41.6.2.3 Obsolete Keyword/Patch Value
41.6.2.4 Literals in Unicode Databases
41.6.2.5 New CLI Configuration Keywords
|41.6.3 Microsoft Transaction Server (MTS) as Transaction Monitor
41.6.4 Scrollable Cursors
41.6.4.1 Server-side Scrollable Cursor Support for OS/390
41.6.5 Using Compound SQL
41.6.6 Using Stored Procedures
|41.6.6.1 Privileges for building and debugging SQL and Java stored procedures
41.6.6.2 Writing a Stored Procedure in CLI
41.6.6.3 CLI Stored Procedures and Autobinding
41.7 Chapter 4. Configuring CLI/ODBC and Running Sample Applications
|41.7.1 Configuration Keywords
|41.7.1.1 CURRENTFUNCTIONPATH
|41.7.1.2 SKIPTRACE
41.8 Chapter 5. DB2 CLI Functions
41.8.1 SQLBindFileToParam - Bind LOB File Reference to LOB Parameter
|41.8.2 SQLColAttribute -- Return a Column Attribute
|41.8.3 SQLGetData - Get Data From a Column
|41.8.4 SQLGetInfo - Get General Information
|41.8.5 SQLGetLength - Retrieve Length of A String Value
41.8.6 SQLNextResult - Associate Next Result Set with Another Statement Handle
41.8.6.1 Purpose
41.8.6.2 Syntax
41.8.6.3 Function Arguments
41.8.6.4 Usage
41.8.6.5 Return Codes
41.8.6.6 Diagnostics
41.8.6.7 Restrictions
41.8.6.8 References
|41.8.7 SQLSetEnvAttr - Set Environment Attribute
|41.8.8 SQLSetStmtAttr -- Set Options Related to a Statement
|41.9 Appendix C. DB2 CLI and ODBC
|41.9.1 ODBC Unicode Applications
|41.9.1.1 ODBC Unicode Versus Non-Unicode Applications
41.10 Appendix D. Extended Scalar Functions
41.10.1 Date and Time Functions
41.11 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility
|Message Reference
|42.1 Update Available
|42.2 Message Updates
|42.3 Reading Message Text Online
SQL Reference
|43.1 SQL Reference Update Available
|43.2 Enabling the New Functions and Procedures
|43.3 SET SERVER OPTION - Documentation Error
|43.4 Correction to CREATE TABLESPACE Container-clause, and Container-string Information
|43.5 GRANT (Table, View, or Nickname Privileges) - Documentation Error
43.6 MQSeries Information
43.6.1 Scalar Functions
|43.6.1.1 MQPUBLISH
|43.6.1.2 MQREADCLOB
|43.6.1.3 MQRECEIVECLOB
|43.6.1.4 MQSEND
43.6.2 Table Functions
|43.6.2.1 MQREADALLCLOB
|43.6.2.2 MQRECEIVEALLCLOB
|43.6.3 CLOB data now supported in MQSeries functions
43.7 Data Type Information
43.7.1 Promotion of Data Types
|43.7.2 Casting between Data Types
43.7.3 Assignments and Comparisons
43.7.3.1 String Assignments
43.7.3.2 String Comparisons
43.7.4 Rules for Result Data Types
43.7.4.1 Character and Graphic Strings in a Unicode Database
43.7.5 Rules for String Conversions
43.7.6 Expressions
43.7.6.1 With the Concatenation Operator
43.7.7 Predicates
|43.8 Unicode Information
|43.8.1 Scalar Functions and Unicode
|43.9 GRAPHIC type and DATE/TIME/TIMESTAMP compatibility
|43.9.1 String representations of datetime values
|43.9.1.1 Date strings, time strings, and datetime strings
|43.9.2 Casting between data types
|43.9.3 Assignments and comparisons
|43.9.4 Datetime assignments
|43.9.5 DATE
|43.9.6 GRAPHIC
|43.9.7 TIME
|43.9.8 TIMESTAMP
|43.9.9 VARGRAPHIC
43.10 Larger Index Keys for Unicode Databases
43.10.1 ALTER TABLE
43.10.2 CREATE INDEX
43.10.3 CREATE TABLE
|43.11 ALLOCATE CURSOR Statement Notes Section Incorrect
|43.12 Additional Options in the GET DIAGNOSTICS Statement
|GET DIAGNOSTICS Statement
|43.13 ORDER BY in Subselects
|43.13.1 fullselect
|43.13.2 subselect
|43.13.3 order-by-clause
|43.13.4 select-statement
|SELECT INTO statement
|43.13.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
47.1 Introduction
47.1.1 DB2 Unicode Databases and Applications
47.1.2 Documentation Updates
Connecting to Host Systems
|DB2 Connect User's Guide
|48.1 Increasing DB2 Connect data transfer rate
|48.1.1 Extra Query Blocks
|48.1.2 RFC-1323 Window Scaling
|48.2 DB2 Connect Support for Loosely Coupled Transactions
|48.3 Kerberos support
Connectivity Supplement
49.1 Setting Up the Application Server in a VM Environment
49.2 CLI/ODBC/JDBC Configuration PATCH1 and PATCH2 Settings
Additional Information
Additional Information
50.1 DB2 Everywhere is Now DB2 Everyplace
50.2 Accessibility Features of DB2 UDB Version 7
50.2.1 Keyboard Input and Navigation
50.2.1.1 Keyboard Input
50.2.1.2 Keyboard Focus
50.2.2 Features for Accessible Display
50.2.2.1 High-Contrast Mode
50.2.2.2 Font Settings
50.2.2.3 Non-dependence on Color
50.2.3 Alternative Alert Cues
50.2.4 Compatibility with Assistive Technologies
50.2.5 Accessible Documentation
50.3 Mouse Required
50.4 Attempting to Bind from the DB2 Run-time Client Results in a "Bind files not found" Error
50.5 Search Discovery
50.6 Memory Windows for HP-UX 11
50.7 Uninstalling DB2 DFS Client Enabler
50.8 Client Authentication on Windows NT
50.9 Federated Systems Restrictions
|50.10 Federated Limitations with MPP Partitioned Tables
50.11 DataJoiner Restriction
50.12 Hebrew Information Catalog Manager for Windows NT
50.13 DB2's SNA SPM Fails to Start After Booting Windows
50.14 Service Account Requirements for DB2 on Windows NT and Windows 2000
50.15 Need to Commit all User-defined Programs That Will Be Used in the Data Warehouse Center (DWC)
50.16 Client-side Caching on Windows NT
|50.17 Life Sciences Data Connect
|50.17.1 New Wrappers
|50.17.2 Notices-
50.18 Enhancement to SQL Assist
|50.19 Help for Backup and Restore Commands
50.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 ]