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 Making the DB2 EE or DB2 Connect EE Install Image accessible on Linux on S/390
4.3 DB2 Connect Appendix Information Not Required
4.4 Installing DB2 on SuSE Linux
4.5 Additional Required Solaris Operating Environment Patch Level
4.6 Installing DB2 Enterprise-Extended Edition on AIX
4.7 Additional Installation Steps for AIX CICS Users
4.8 Netscape LDAP directory support
4.8.1 Extending the Netscape LDAP schema
4.9 Support for Windows ME, Windows XP and Windows 2000 Datacenter Edition Platforms
4.9.1 Windows XP
4.9.1.1 Limitations
4.9.2 Windows ME
4.9.2.1 Limitations
4.9.3 Windows 2000 Datacenter Server
4.10 Installing DB2 in Windows 95
4.11 Installing DB2 on Windows 2000
4.12 Running DB2 under Windows 2000 Terminal Server, Administration Mode
4.13 Microsoft SNA Server and SNA Multisite Update (Two Phase Commit) Support
4.14 Define User ID and Password in IBM Communications Server for Windows NT (CS/NT)
4.14.1 Node Definition
4.15 DB2 Install May Hang if a Removable Drive is Not Attached
4.16 Error SQL1035N when Using CLP on Windows 2000
4.17 Migration Issue Regarding Views Defined with Special Registers
4.18 IPX/SPX Protocol Support on Windows 2000
4.19 Stopping DB2 Processes Before Upgrading a Previous Version of DB2
4.20 Run db2iupdt After Installing DB2 If Another DB2 Product is Already Installed
4.21 Setting up the Linux Environment to Run the DB2 Control Center
4.22 DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition for Linux on S/390
4.23 Possible Data Loss on Linux for S/390
4.24 Gnome and KDE Desktop Integration for DB2 on Linux
4.25 Solaris Kernel Configuration Parameters (Recommended Values)
4.26 DB2 Universal Database Enterprise - Extended Edition for UNIX Quick Beginnings
4.27 shmseg Kernel Parameter for HP-UX
4.28 Migrating IBM Visual Warehouse Control Databases
4.29 Migrating Unique Indexes Using the db2uiddl Command
4.30 64-bit AIX Version Installation Error
4.30.1 Using SMIT
4.31 Errors During Migration
4.32 IBM(R) DB2(R) Connect License Activation
4.32.1 Installing Your License Key and Setting the License Type Using the License Center
4.32.2 Installing your License Key and Setting License Type Using the db2licm Command
4.32.3 License Considerations for Distributed Installations
4.33 Accessing Warehouse Control Databases
4.34 IBM e-server p690 and DB2 UDB Version 7 with AIX 5
4.35 Trial Products on Enterprise Edition UNIX CD-ROMs
4.36 Trial Products on DB2 Connect Enterprise Edition UNIX CD-ROMs
4.37 Merant Driver Manager and the DB2 UDB Version 7 ODBC Driver on UNIX
4.38 Additional Configuration Needed Before Installing the Information Catalog Center for the Web
4.39 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 FixPak 8 or Later Required If Using DB2 Version 8 Data Sources
6.3.3 Restriction
6.3.4 Installing DB2 Relational Connect
6.3.4.1 Installing DB2 Relational Connect on Windows NT servers
6.3.4.2 Installing DB2 Relational Connect on UNIX Servers
6.3.5 Chapter 24. Setting Up a Federated System to Access Multiple Data Sources
6.3.5.1 Understanding the schema used with nicknames
6.3.5.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.4.2 Correction to Collating Information (collate_info) Section
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 RUNSTATS
12.6 db2inidb - Initialize a Mirrored Database
12.6.1 Usage Information
12.7 db2relocatedb (new command)
db2relocatedb - Relocate Database
12.8 db2move
Database Movement Tool
12.9 Additional Option in the GET ROUTINE Command
GET ROUTINE
12.10 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 AutoLoader Restrictions and Limitations
14.6.2 Using AutoLoader
14.6.3 rexecd Required to Run AutoLoader When Authentication Set to YES
14.6.4 AutoLoader May Hang During a Fork on AIX Systems Prior to 4.3.3
14.7 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 Apply Program and Control Center Aliases
15.5 DB2 Maintenance
15.6 Data Difference Utility on the Web
15.7 Chapter 3. Data Replication Scenario
15.7.1 Replication Scenarios
15.8 Chapter 5. Planning for Replication
15.8.1 Table and Column Names
15.8.2 DATALINK Replication
15.8.3 LOB Restrictions
15.8.4 Planning for Replication
15.9 Chapter 6. Setting up Your Replication Environment
15.9.1 Update-anywhere Prerequisite
15.9.2 Setting Up Your Replication Environment
15.10 Chapter 8. Problem Determination
15.11 Chapter 9. Capture and Apply for AS/400
15.12 Chapter 10. Capture and Apply for OS/390
15.12.1 Prerequisites for DB2 DataPropagator for OS/390
15.12.2 UNICODE and ASCII Encoding Schemes on OS/390
15.12.2.1 Choosing an Encoding Scheme
15.12.2.2 Setting Encoding Schemes
15.13 Chapter 11. Capture and Apply for UNIX platforms
15.13.1 Setting Environment Variables for Capture and Apply on UNIX and Windows
15.14 Chapter 14. Table Structures
15.15 Chapter 15. Capture and Apply Messages
15.16 Appendix A. Starting the Capture and Apply Programs from Within an Application
System Monitor Guide and Reference
16.1 db2ConvMonStream
16.2 Maximum Database Heap Allocated (db_heap_top)
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
29.10 Web Connector Information
29.10.1 Supported WebSphere Site Analyzer Versions
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 Connector for SAP R/3
36.3.1 Installation Prerequisites
36.4 Connector for the Web
36.4.1 Installation Prerequisites
36.5 Post-installation considerations for the iSeries agent
36.6 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 db2Runstats
38.7 db2GetSnapshot - Get Snapshot
38.8 db2XaGetInfo (new API)
db2XaGetInfo - Get Information for Resource Manager
38.9 db2XaListIndTrans (new API that supercedes sqlxphqr)
db2XaListIndTrans - List Indoubt Transactions
38.10 Forget Log Record
38.11 sqlaintp - Get Error Message
38.12 sqlbctcq - Close Tablespace Container Query
38.13 sqleseti - Set Client Information
38.14 sqlubkp - Backup Database
38.15 sqlureot - Reorganize Table
38.16 sqlurestore - Restore Database
38.17 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
38.18 SQLFUPD
38.18.1 locklist
38.19 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 Precaution for registering C/C++ routines (UDFs, stored procedures, or methods) on Windows
40.3 Correction to "Debugging Stored Procedures in Java"
40.4 New Requirements for executeQuery and executeUpdate
40.5 JDBC Driver Support for Additional Methods
40.6 JDBC and 64-bit systems
40.7 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 Correction to CREATE TABLESPACE EXTENTSIZE information
43.6 GRANT (Table, View, or Nickname Privileges) - Documentation Error
43.7 MQSeries Information
43.7.1 Scalar Functions
43.7.1.1 MQPUBLISH
43.7.1.2 MQREADCLOB
43.7.1.3 MQRECEIVECLOB
43.7.1.4 MQSEND
43.7.2 Table Functions
43.7.2.1 MQREADALLCLOB
43.7.2.2 MQRECEIVEALLCLOB
43.7.3 CLOB data now supported in MQSeries functions
43.8 Data Type Information
43.8.1 Promotion of Data Types
43.8.2 Casting between Data Types
43.8.3 Assignments and Comparisons
43.8.3.1 String Assignments
43.8.3.2 String Comparisons
43.8.4 Rules for Result Data Types
43.8.4.1 Character and Graphic Strings in a Unicode Database
43.8.5 Rules for String Conversions
43.8.6 Expressions
43.8.6.1 With the Concatenation Operator
43.8.7 Predicates
43.9 Unicode Information
43.9.1 Scalar Functions and Unicode
43.10 GRAPHIC type and DATE/TIME/TIMESTAMP compatibility
43.10.1 String representations of datetime values
43.10.1.1 Date strings, time strings, and datetime strings
43.10.2 Casting between data types
43.10.3 Assignments and comparisons
43.10.4 Datetime assignments
43.10.5 DATE
43.10.6 GRAPHIC
43.10.7 TIME
43.10.8 TIMESTAMP
43.10.9 VARGRAPHIC
43.11 Larger Index Keys for Unicode Databases
43.11.1 ALTER TABLE
43.11.2 CREATE INDEX
43.11.3 CREATE TABLE
43.12 ALLOCATE CURSOR Statement Notes Section Incorrect
43.13 Additional Options in the GET DIAGNOSTICS Statement
GET DIAGNOSTICS Statement
43.14 ORDER BY in Subselects
43.14.1 fullselect
43.14.2 subselect
43.14.3 order-by-clause
43.14.4 select-statement
SELECT INTO statement
43.14.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 ]