Release Notes

Table of Contents

Welcome to DB2 Universal Database Version 7.1!

Special Notes

  • 1.1 DB2 Universal Database Business Intelligence Quick Tour
  • 1.2 Downloading Installation Packages for All Supported DB2 Clients
  • 1.3 Installing DB2 on Windows 2000
  • 1.4 Notes on Greater Than 8-Character User IDs and Schema Names
  • 1.5 National Language Versions of DB2 Version 7.1
  • 1.5.1 Control Center and Documentation Filesets
  • 1.6 Accessibility Features of DB2 UDB Version 7.1
  • 1.6.1 Keyboard Input and Navigation
  • 1.6.1.1 Keyboard Input
  • 1.6.1.2 Keyboard Focus
  • 1.6.2 Features for Accessible Display
  • 1.6.2.1 High-Contrast Mode
  • 1.6.2.2 Font Settings
  • 1.6.2.3 Non-dependence on Color
  • 1.6.3 Alternative Alert Cues
  • 1.6.4 Compatibility with Assistive Technologies
  • 1.6.5 Accessible Documentation
  • 1.7 DB2 Everywhere is Now DB2 Everyplace
  • 1.8 Error Messages when Attempting to Launch Netscape
  • 1.9 Mouse Required
  • 1.10 Supported Web Browsers on the Windows 2000 Operating System
  • 1.11 Opening External Web Links in Netscape Navigator From The Information Center when Netscape is Already Open (UNIX Based Systems)
  • 1.12 Problems Starting the Information Center
  • 1.13 Configuration Requirement for Adobe Acrobat Reader on UNIX Based Systems
  • 1.14 Attempting to Bind from the DB2 Run-time Client Results in a "Bind files not found" Error
  • 1.15 Additional Required Solaris Patch Level
  • 1.16 Supported CPUs on DB2 Version 7.1 for Solaris
  • 1.17 Searching the DB2 Online Information on Solaris
  • 1.18 Java Control Center on OS/2
  • 1.19 Search Discovery
  • 1.20 Problems When Adding Nodes to a Partitioned Database
  • 1.21 Errors During Migration
  • 1.22 Memory Windows for HP-UX 11
  • 1.23 Spatial Extender is Unavailable
  • 1.24 SQL Reference is Provided in One PDF File
  • 1.25 Migration Issue Regarding Views Defined with Special Registers
  • 1.26 User Action for dlfm client_conf Failure
  • 1.27 In the Rare Event that the Copy Daemon Does Not Stop on dlfm stop
  • 1.28 Chinese Locale Fix on Red Flag Linux
  • 1.29 Uninstalling DB2 DFS Client Enabler
  • 1.30 DB2 Install May Hang if a Removable Drive is Not Attached
  • 1.31 Client Authentication on Windows NT
  • 1.32 AutoLoader May Hang During a Fork
  • 1.33 DATALINK Restore
  • 1.34 Define User ID and Password in IBM Communications Server for Windows NT (CS/NT)
  • 1.34.1 Node Definition
  • 1.35 Federated Systems Restrictions
  • 1.36 DataJoiner Restriction
  • 1.37 IPX/SPX Protocol Support on Windows 2000
  • 1.38 Stopping DB2 Processes Before Upgrading a Previous Version of DB2
  • 1.39 Run db2iupdt After Installing DB2 If Another DB2 Product is Already Installed
  • 1.40 JDK Level on OS/2
  • 1.41 Setting up the Linux Environment to Run DB2
  • 1.42 Hebrew Information Catalog Manager for Windows NT
  • 1.43 Error While Creating an SQL Stored Procedure on the Server
  • 1.44 Microsoft SNA Server and SNA Multisite Update (Two Phase Commit) Support
  • 1.45 DB2's SNA SPM Fails to Start After Booting Windows
  • 1.46 Additional Locale Setting for DB2 for Linux in a Japanese and Simplified Chinese Linux Environment
  • 1.47 Locale Setting for the DB2 Administration Server
  • 1.48 Java Method Signature in PARAMETER STYLE JAVA Procedures and Functions
  • 1.49 Shortcuts Not Working
  • 1.50 Service Account Requirements for DB2 on Windows NT and Windows 2000

    • Administration Guide: Planning

  • 2.1 Chapter 14. DB2 and High Availability on Sun Cluster 2.2
  • 2.2 Appendix E. National Language Support

    • Administration Guide: Implementation

  • 3.1 Chapter 4. Altering a Database
  • 3.1.1 Adding a Container to an SMS Table Space on a Partition
  • 3.1.2 Switching the State of a Table Space
  • 3.2 Chapter 8. Recovering a Database
  • 3.3 Appendix C. User Exit for Database Recovery
  • 3.4 Appendix I. High Speed Inter-node Communications
  • 3.4.1 Enabling DB2 to Run Using VI

    • Administration Guide: Performance

  • 4.1 Chapter 5. System Catalog Statistics
  • 4.1.1 Collecting and Using Distribution Statistics
  • 4.2 Chapter 6. Understanding the SQL Compiler
  • 4.2.1 Replicated Summary Tables
  • 4.2.2 Data Access Concepts and Optimization
  • 4.3 Chapter 13. Configuring DB2
  • 4.3.1 Sort Heap Size (sortheap)
  • 4.3.2 Sort Heap Threshold (sheapthres)
  • 4.4 Appendix A. DB2 Registry and Environment Variables
  • 4.4.1 Table of New and Changed Registry Variables
  • 4.5 Appendix C. SQL Explain Tools

    • Administrative API Reference

  • 5.1 db2ConvMonStream
  • 5.2 db2XaGetInfo (new API)
  • db2XaGetInfo - Get Information for Resource Manager
  • 5.3 db2XaListIndTrans (new API that supercedes sqlxphqr)
  • db2XaListIndTrans - List Indoubt Transactions
  • 5.4 sqlaintp - Get Error Message

    • Application Building Guide

  • 6.1 Chapter 1. Introduction
  • 6.1.1 Supported Software
  • 6.1.2 Sample Programs
  • 6.2 Chapter 3. General Information for Building DB2 Applications
  • 6.2.1 Build Files, Makefiles, and Error-checking Utilities
  • 6.3 Chapter 4. Building Java Applets and Applications
  • 6.3.1 Setting the Environment
  • 6.4 Chapter 5. Building SQL Procedures.
  • 6.4.1 Setting the SQL Procedures Environment
  • 6.4.1.1 Configuring the Compiler Environment
  • 6.4.1.2 Customizing Compiler Options
  • 6.4.1.3 Retaining Intermediate Files
  • 6.4.1.4 Backup and Restore
  • 6.4.2 Creating SQL Procedures
  • 6.4.3 Calling Stored Procedures
  • 6.5 Chapter 7. Building HP-UX Applications.
  • 6.5.1 HP-UX C
  • 6.5.2 HP-UX C++
  • 6.6 Chapter 10. Building PTX Applications
  • 6.6.1 ptx/C++
  • 6.7 Chapter 12. Building Solaris Applications
  • 6.7.1 SPARCompiler C++
  • 6.8 VisualAge C++ Version 4.0 on OS/2 and Windows

    • Application Development Guide

  • 7.1 Writing OLE Automation Stored Procedures
  • 7.2 Chapter 7. Stored Procedures
  • 7.2.1 DECIMAL Type Not Supported in Linux Java Routines
  • 7.3 Chapter 12. Working with Complex Objects: User-Defined Structured Types
  • 7.3.1 Inserting Structured Type Attributes Into Columns
  • 7.4 Chapter 20. Programming in C and C++
  • 7.4.1 C/C++ Types for Stored Procedures, Functions, and Methods
  • 7.5 Appendix B. Sample Programs
  • 7.6 Activating the IBM DB2 Universal Database Project and Tool Add-ins for Microsoft Visual C++

    • CLI Guide and Reference

  • 8.1 CLI Unicode Functions and SQL_C_WCHAR Support on AIX Only
  • 8.2 Binding Database Utilities Using the Run-Time Client
  • 8.3 Addition to the "Using Compound SQL" Section
  • 8.4 Writing a Stored Procedure in CLI
  • 8.5 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility
  • 8.6 Using Static SQL in CLI Applications
  • 8.7 Limitations of JDBC/ODBC/CLI Static Profiling
  • 8.8 Parameter Correction for SQLBindFileToParam() CLI Function
  • 8.9 ADT Transforms

    • Command Reference

  • 9.1 db2batch - Benchmark Tool
  • 9.2 db2cap (new command)
  • db2cap - CLI/ODBC Static Package Binding Tool
  • 9.3 db2gncol (new command)
  • db2gncol - Update Generated Column Values
  • 9.4 db2look - DB2 Statistics Extraction Tool
  • 9.5 db2updv6 (new command)
  • 9.6 New Command Line Processor Option (-x, Suppress printing of column headings)
  • 9.7 True Type Font Requirement for DB2 CLP
  • 9.8 CALL
  • 9.9 EXPORT
  • 9.10 GET DATABASE CONFIGURATION
  • 9.11 IMPORT
  • 9.12 LOAD

    • Connectivity Supplement

  • 10.1 Setting Up the Application Server in a VM Environment
  • 10.2 CLI/ODBC/JDBC Configuration PATCH1 and PATCH2 Settings

    • Data Links Manager Quick Beginnings

  • 11.1 Dlfm start Fails with Message: "Error in getting the afsfid for prefix"
  • 11.2 Setting Tivoli Storage Manager Class for Archive Files
  • 11.3 Disk Space Requirements for DFS Client Enabler
  • 11.4 Monitoring the Data Links File Manager Back-end Processes on AIX
  • 11.5 Installing and Configuring DB2 Data Links Manger for AIX: Additional Installation Considerations in DCE-DFS Environments
  • 11.6 Failed "dlfm add_prefix" Command
  • 11.7 Installing and Configuring DB2 Data Links Manger for AIX: Installing DB2 Data Links Manager on AIX Using the db2setup Utility
  • 11.8 Installing and Configuring DB2 Data Links Manager for AIX: DCE-DFS Post-Installation Task
  • 11.9 Installing and Configuring DB2 Data Links Manager for AIX: Manually Installing DB2 Data Links Manager Using Smit
  • 11.10 Installing and Configuring DB2 Data Links DFS Client Enabler
  • 11.11 Choosing a Backup Method for DB2 Data Links Manager on AIX
  • 11.12 Choosing a Backup Method for DB2 Data Links Manager on Windows NT
  • 11.13 Backing up a Journalized File System on AIX

    • Data Movement Utilities Guide and Reference

  • 12.1 Pending States After a Load Operation
  • 12.2 Load Restrictions and Limitations

    • Installation and Configuration Supplement

  • 13.1 Binding Database Utilities Using the Run-Time Client
  • 13.2 UNIX Client Access to DB2 Using ODBC
  • 13.3 Switching NetQuestion for OS/2 to Use TCP/IP

    • Message Reference

  • 14.1 SQL0270N (New Reason Code 40)
  • 14.2 SQL0301N (New Explanation Text)
  • 14.3 SQL0303N (New Text)
  • 14.4 SQL0358N (New User Response 26)
  • 14.5 SQL0408N (New Text)
  • 14.6 SQL0423N (Revised Text)
  • 14.7 SQL0670N (Revised Text)
  • 14.8 SQL1704N (New Reason Codes)
  • 14.9 SQL4942N (New Text)
  • 14.10 SQL20117N (Changed Reason Code 1)

    • Replication Guide and Reference

  • 15.1 Replication on Windows 2000
  • 15.2 DATALINK Replication
  • 15.3 LOB Restrictions
  • 15.4 Replication and Non-IBM Servers
  • 15.5 Update-anywhere Prerequisite
  • 15.6 Planning for Replication
  • 15.7 Setting Up Your Replication Environment
  • 15.8 Problem Determination
  • 15.9 Capture and Apply for AS/400
  • 15.10 Table Structures
  • 15.11 Capture and Apply Messages
  • 15.12 Starting the Capture and Apply Programs from Within an Application

    • SQL Reference

  • 16.1 IDENTITY_VAL_LOCAL
  • 16.2 OLAP Functions
  • 16.3 SQL Procedures/Compound Statement
  • 16.4 LCASE and UCASE (Unicode)
  • 16.5 WEEK_ISO
  • 16.6 Naming Conventions and Implicit Object Name Qualifications
  • 16.7 Queries (select-statement/fetch-first-clause)
  • 16.8 Libraries Used by the CREATE WRAPPER Statement on Linux

    • System Monitor Guide and Reference

  • 17.1 db2ConvMonStream

    • Troubleshooting Guide

  • 18.1 Starting DB2 on Windows 95 and Windows 98 When the User Is Not Logged On

    • Control Center

  • 19.1 Ability to Administer DB2 Server for VSE and VM Servers
  • 19.2 Java 1.2 Support for the Control Center
  • 19.3 "Invalid shortcut" Error when Using the Online Help on the Windows Operating System
  • 19.4 "File access denied" Error when Attempting to View a Completed Job in the Journal on the Windows Operating System
  • 19.5 Multisite Update Test Connect
  • 19.6 Control Center for DB2 for OS/390
  • 19.7 Required Fix for Control Center for OS/390
  • 19.8 Change to the Create Spatial Layer Dialog
  • 19.9 Troubleshooting Information for the DB2 Control Center
  • 19.10 Control Center Troubleshooting on UNIX Based Systems
  • 19.11 Possible Infopops Problem on OS/2
  • 19.12 Launching More Than One Control Center Applet
  • 19.13 Help for the jdk11_path Configuration Parameter
  • 19.14 Solaris System Error (SQL10012N) when Using the Script Center or the Journal
  • 19.15 Help for the DPREPL.DFT File
  • 19.16 Online Help for the Control Center Running as an Applet
  • 19.17 Running the Control Center in Applet Mode (Windows 95)

    • Data Warehouse Center

  • 20.1 Data Warehouse Center Publications
  • 20.1.1 Data Warehouse Center Application Integration Guide
  • 20.1.2 Data Warehouse Center Administration Guide
  • 20.1.3 Data Warehouse Center Messages
  • 20.1.4 Data Warehouse Center Online Help
  • 20.2 Warehouse Control Database
  • 20.2.1 The default warehouse control database
  • 20.2.2 The Warehouse Control Database Management window
  • 20.2.3 Changing the active warehouse control database
  • 20.2.4 Creating and initializing a warehouse control database
  • 20.2.5 Migrating IBM Visual Warehouse control databases
  • 20.3 Setting up and running replication with Data Warehouse Center
  • 20.4 Troubleshooting tips
  • 20.5 Correction to RUNSTATS and REORGANIZE TABLE Online Help
  • 20.6 Notification Page (Warehouse Properties Notebook and Schedule Notebook)
  • 20.7 Agent Module Field in the Agent Sites Notebook
  • 20.8 Accessing DB2 Version 5 data with the DB2 Version 7.1 warehouse agent
  • 20.8.1 Migrating DB2 Version 5 servers
  • 20.8.2 Changing the agent configuration
  • 20.8.2.1 UNIX warehouse agents
  • 20.8.2.2 Microsoft Windows NT, Windows 2000, and OS/2 warehouse agents
  • 20.9 Accessing warehouse control databases
  • 20.10 Accessing sources and targets
  • 20.11 Accessing DB2 Version 5 information catalogs with the DB2 Version 7.1 Information Catalog Manager
  • 20.12 Additions to supported non-IBM database sources
  • 20.13 Information Catalog Manager Initialization Utility
  • 20.14 Information Catalog Manager Administration Guide

    • DB2 Stored Procedure Builder

  • 21.1 Java 1.2 Support for the DB2 Stored Procedure Builder
  • 21.2 Remote Debugging of DB2 Stored Procedures
  • 21.3 Building SQL Procedures on the Intel and UNIX Platforms
  • 21.4 Using the DB2 Stored Procedure Builder on the Solaris Platform
  • 21.5 Known Problems and Limitations
  • 21.6 Using DB2 Stored Procedure Builder with Traditional Chinese Locale
  • 21.7 UNIX (AIX, Sun Solaris, Linux) Installations and the Stored Procedure Builder

    • DB2 Warehouse Manager

  • 22.1 "Warehouse Manager" Should Be "DB2 Warehouse Manager"
  • 22.2 DB2 Warehouse Manager Publications
  • 22.2.1 Information Catalog Manager Administration Guide
  • 22.2.2 Information Catalog Manager Programming Guide and Reference
  • 22.2.2.1 Information Catalog Manager Reason Codes
  • 22.2.3 Information Catalog Manager: Online Messages
  • 22.2.4 Information Catalog Manager: Online Help
  • 22.2.5 Query Patroller Administration Guide
  • 22.2.5.1 DB2 Query Patroller Client is a Separate Component
  • 22.2.5.2 Manual Installation of Query Patroller on AIX and Solaris
  • 22.2.5.3 Enabling Query Management
  • 22.2.5.4 Starting Query Administrator
  • 22.2.5.5 User Administration
  • 22.2.5.6 Creating a Job Queue
  • 22.2.5.7 Using the Command Line Interface
  • 22.2.5.8 Query Enabler Notes

    • Information Center

  • 23.1 "Invalid shortcut" Error on the Windows Operating System

    • OLAP Starter Kit

  • 24.1 Completing the DB2 OLAP Starter Kit Setup on AIX and Solaris
  • 24.2 Logging in from OLAP Integration Server Desktop
  • 24.2.1 Starter Kit Login Example
  • 24.3 Manually creating and configuring the sample databases for OLAP Integration Server
  • 24.4 Known problems and limitations
  • 24.4.1 DB2 OLAP Starter Kit
  • 24.4.2 DB2 OLAP Desktop Client
  • 24.4.3 Spreadsheet Clients
  • 24.4.4 DB2 OLAP Integration Server
  • 24.5 OLAP Starter Kit Spreadsheet Needs Current Windows svc.pack
  • 24.6 OLAP Spreadsheet Add-in EQD Files Missing

    • Wizards

  • 25.1 Setting Extent Size in the Create Database Wizard

    • Additional Information

  • 26.1 DB2 Universal Database and DB2 Connect Online Support
  • 26.2 DB2 magazine

    • Appendix A. Notices

  • A.1 Trademarks

    • [ Top of Page | Previous Page | Next Page | Table of Contents ]