Release Notes

Contents

  • Preface

    • Read Me First

  • FixPak 8 Highlights

  • Product Notes
  • 2.1 Supported CPUs on DB2 Version 7 for the Solaris Operating Environment
  • 2.2 Chinese Locale Fix on Red Flag Linux
  • 2.3 Additional Locale Setting for DB2 for Linux in a Japanese and Simplified Chinese Linux Environment
  • |2.4 Limitation for Japanese on PTX
  • 2.5 Control Center Problem on Microsoft Internet Explorer
  • |2.6 Loss of Control Center Function
  • |2.7 Netscape CD not Shipped with DB2 UDB
  • |2.8 Error in XML Readme Files
  • |2.9 New Business Intelligence Enhancements in DB2 Version 7.2
  • |2.10 FixPak 2A and Later Causes Problems in IBM DB2 OLAP Server
  • |2.11 Segmentation Violation When Using WebSphere 3.5.5
  • |2.12 Veritas AIX Volume Manager Support
  • |2.13 Fix Required for Java Applications on AIX V4
  • |2.14 db2stop Hangs on AIX 5 Operating Systems due to an NFS problem

  • Online Documentation (HTML, PDF, and Search) Notes
  • 3.1 Supported Web Browsers on the Windows 2000 Operating System
  • 3.2 Searching the DB2 Online Information on the Solaris Operating Environment
  • 3.3 Switching NetQuestion for OS/2 to Use TCP/IP
  • 3.4 Error Messages when Attempting to Launch Netscape
  • 3.5 Configuration Requirement for Adobe Acrobat Reader on UNIX Based Systems
  • 3.6 SQL Reference is Provided in One PDF File

    • 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 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 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 ]