Contents

About the Release Notes

About this release

New in this release

Product fix history

Compatibility issues

Backward compatibility

Product compatibility

Installation, migration, upgrade, and configuration information

Hardware and software requirements

Installation notes

New options for the DB2 Setup wizard (Windows)

Changes to the DB2 Setup wizard (Windows)

Extended security installation restrictions (Windows)

Directory path cannot contain blanks (Linux and UNIX)

Red Hat Enterprise Linux 4 Requirement

JDK levels for DB2 UDB (Linux on IA64 and Linux on POWER)

Uncompressing installation images (Linux and UNIX)

DB2 UDB does not allow non-English installation path (Windows)

Downloading and uncompressing FixPaks for multiple products (Windows)

Installing DB2 UDB from installation images (Linux and UNIX)

Installing DB2 UDB from installation images (Windows)

Disk space required for a DB2 UDB response file installation

Restrictions to adding products using the db2setup command (Linux and UNIX)

Binding Query Patroller packages after applying fixpaks

Query Patroller installation at FixPak 3 level or later

Query Patroller server installation

Defining a new database partition group in Query Patroller

Query Patroller client tools installation

Recreating beta versions of databases

Installing MDAC files for national language versions of DB2 UDB

DB2 license policy for DB2 Universal Database Workgroup Server Edition

Installing additional Asian fonts (Linux)

Configuring the Development Center to use Java Development Kits (Linux)

Creating group and user IDs on United Linux 1.0 and SuSE Linux distributions

Help system daemon does not start after installing with the db2_install command (UNIX and Linux)

Ready for Tivoli enablement (UNIX)

Installation image reduction tool - db2iprune (Windows)

DB2 Universal Database, Version 8 documentation installation restriction (Windows)

Previous installations updated to the latest level (Windows)

System requirements for the DB2 .NET Data Provider (Windows)

Installing DB2 Version 8 Clients and DB2 Connect PE as a non-Administrator (Windows)

Migration notes

| |

db2updv8 technote

| |

After running db2updv8, moving back to V 8.1 is not supported

Migration of EXPLAIN tables

Migrating XML Extender from previous versions

Migrating DB2 Universal Database when using DataJoiner or replication

Migrating DB2 Universal Database (Windows)

Migrating a DB2 Version 8 Windows 32-bit database to Windows 64-bit

Migrating to DB2 UDB Version 8.2.2 from Version 7 in an MSCS environment

Database migration (HP-UX on IA64)

Uninstallation information

Uninstalling DB2 UDB silently (Windows)

Product code for DB2 Information Center removal using a silent uninstall (Windows)

Known limitations, problems, and workarounds

| |

db2look - Limitation for automatic storage table space

SNAP_GET_DB table function returns incomplete results

IMPORT REPLACE does not honor the Not Logged Initially clause

Long field and LOB data cannot be reorganized with inplace table reorganization

Locking behavior in blocking cursors can appear inconsistent in client applications

Data export with ODBC to file warehouse program

Data types that are not supported in the Development Center's integrated SQL debugger

Structured types in the Development Center

Development Center limitations for 64-bit operating systems

Development Center (Linux)

Debugging stored procedures with double quotation marks

Path settings needed to enable Java routines to compile in the Development Center

Development Center limitations to run and debug Java stored procedures simultaneously

DB2SystemMonitor.getServerTimeMicros method not supported

IBM XL C/C++ compiler run time must be installed (Linux on iSeries and pSeries systems, 64-bit)

Universal JDBC Driver Type 2 not supported on DB2 UDB Version 8.2.2 (Linux AMD64 )

Cursors in PHP applications

ConnectNode CLI/ODBC configuration keyword limitation

SQLColumns function (CLI) restriction

Bind option limitations for CLI packages

CLI LOAD utility restrictions

Tools catalog database creation not supported (Linux for AMD64)

Tools catalog database creation not supported (AIX, Solaris Operating Environments, and HP-UX)

Memory limitations for DB2 UDB Express and DB2 Workgroup Server Edition V8.2

Scheduling a warehouse process to run at intervals

SNA support limitations in Version 8

Security plug-in problem and restriction for DB2 UDB clients (Windows)

Failures when reporting a successful login during a connection attempt (AIX)

Two-part user ID not supported (Windows ME)

Load and Import Columns page does not support DBCS characters in IXF files

| |

GUI tools for Linux operating systems on AMD64

Minimum display settings for GUI tools

Improper display of GB18030 characters in the title bar of a window

Do not partition Information Catalog Center tables

Query Patroller limitations when DYN_QUERY_MGMT is disabled

Query Patroller result tables now use DB2QPRT schema

Health indicator restrictions

Known problems and workarounds

Exporting to an IXF file with indexes on columns containing - and + characters

CLI0116E or SQL0428N error when calling the db2ReadLog API

The "db2gcf -k" command fails on DB2 UDB Workgroup Server Edition

SQL1224 error from DRDA wrapper (AIX)

Hotkeys not working in Microsoft Visual Studio .NET Framework 1.1

The simplified Chinese locale (AIX)

The simplified Chinese locale (Red Hat Linux)

Merant Driver Manager incompatibility (UNIX)

NFS APAR IY32512 - Unavailable threads (AIX)

SQLFLAG (STD) precompiler option error

Connection pooling must be enabled when using Sysplex in DB2 Connect

DB2 Connect Custom Advisor

Tools catalog database creation fails (HP-UX)

Displaying Indic characters in the DB2 GUI tools

GUI tools are not supported for zSeries servers (Linux)

Enclose DB2 Information Center search terms within quotation marks if they contain numbers

Information Catalog Center log file not generated when importing tag language files

Binding Query Patroller packages

Unavailability of ports with Query Patroller (Windows)

Secure environments (Windows)

XML Extender sample programs renamed

Decomposing documents in XML Extender that contain non unique attribute and element names

Differences between SNA and TCP/IP when using DB2 Connect

Documentation updates

Administration: Implementation

| |

Automatic client reroute configuration (DB2_MAX_CLIENT_CONNRETRIES and DB2_CONNRETRIES_INTERVAL)

| |

DB2TIMEOUT registry variable clarification

| |

Directories created during table space container creation

Automatic storage

Defining a generated column on an existing table

Aggregate registry variables

Authentication considerations for remote clients

Direct I/O (DIO) and concurrent I/O (CIO) support

Distributor technology and automatic client rerouting

Automatic client reroute considerations for cataloging on a DB2 Connect server

Local system account support (Windows)

Two-part user ID support

Kerberos authentication details

Additional information for Kerberos support

Administration: Performance

| |

Comparison of the DB2_FORCE_FCM_BP registry variable in 32-bit and 64-bit environments

| |

RUNSTATS recommended after table creation

| |

New reason code for SQL1169N

| |

Optimization strategies for MDC tables

| |

NEWLOGPATH, MIRRORPATH, and OVERFLOWLOGPATH configuration parameter description clarification

| |

DB2_COLLECT_TS_REC_INFO default value

The Governor utility

Choosing a table reorganization method

Large page support for FCM memory (AIX 5L 64-bit)

DB2_RESOURCE_POLICY registry variable accepts a new element

New system environment variables (Linux)

New communication registry variable

New performance variable

SQL compiler variables

Configuration parameter updates

SQLDBCONF database configuration parameter file

Change to the DB2_HASH_JOIN default value

DB2NTNOCACHE registry variable is deprecated

Explain tables and organization of explain information

Guidelines for capturing explain information

Additional return codes from db2CfgGet API, collate_info parameter

Automatic setting of default prefetch size and update defaults

Administration: Planning

Range-clustered tables

Catalog table space design

Supported territory codes and code pages

XA function supported by DB2 Universal Database

Updated TPM and tp_mon_name values for xa_open string formats

Activating conversion tables for code pages 923 and 924

Conversion table files for euro-enabled code pages

| |

Log record structure clarification

| |

db2Backup API oBackupsize parameter

SYNCPOINT option support

New field for SQLEDBDESC structure

Correction to new field in the SQLB-TBSPQRY-DATA structure

Application development: Building and Running Applications

Dynamic reconfiguration samples (AIX)

Linux supported development software

Customizing precompile and bind options for SQL procedures

C/C++ compile option required (Linux on POWER 64-bit)

Compile and link command for Micro Focus COBOL stored procedures (HP-UX)

Minimum supported version of Micro Focus COBOL (HP-UX)

Setting environment variables for Micro Focus COBOL stored procedures (Windows)

Application development: Call Level Interface (CLI)

| |

Trusted_Connection CLI/ODBC configuration keyword

Diagnostic table update for SQLDescribeParam function (CLI)

Asynchronous execution of Call Level Interface

SQL_ATTR_PING_DB connection attribute

SQLBindParameter function (CLI)

SQLMoreResults function (CLI)

Additional environment attributes

Dynamic scrollable cursors requirement

RetCatalogAsCurrServer CLI/ODBC configuration keyword

ReceiveTimeout CLI/ODBC configuration keyword

SQL_ATTR_RECEIVE_TIMEOUT connection attribute

Reopt CLI/ODBC configuration keyword

SQL_ATTR_REOPT statement and connection attribute

CurrentPackageSet CLI/ODBC configuration keyword

SQL_ATTR_CURRENT_PACKAGE_SET connection attribute

MapBigintCDefault CLI/ODBC configuration keyword

DescribeOutputLevel CLI/ODBC configuration keyword

Application development: Programming Client Applications

| |

DB2 Universal JDBC Driver Type 4 connectivity to DB2 for VM/VSE is not supported

DB2 Universal JDBC Driver connection concentrator and Sysplex workload balancing

OleDbReportIsLongForLongTypes CLI/ODBC configuration keyword

OleDbSQLColumnsSortByOrdinal CLI/ODBC configuration keyword

DB2 Data Source property group for the IBM DB2 OLE DB Provider

Incorrect URL syntax in the DB2Binder syntax diagram

Rerouting DB2 Universal JDBC driver clients

Customizing the DB2 Universal JDBC driver configuration properties

db2secFreeToken function removed

Deploy custom security plug-ins carefully

Security plug-ins

Security plug-in APIs

Security plug-in naming conventions (Linux and UNIX)

Restrictions on security plug-in libraries

| |

GSS-API plug-in support for DB2 Universal JDBC Driver

GSS-API security plug-ins do not support multiple-flow authentication

GSS-API security plug-ins do not support message encryption and signing

Implicit ending of transactions in stand-alone applications

Distributed transaction support

Application development: Programming Server Applications

Multiple result set common language runtime (CLR) procedures

Common language runtime (CLR) routine execution control modes (EXECUTION CONTROL clause)

Maximum decimal precision and scale in common language runtime (CLR) routines

Command Reference

| |

db2licm - License Management Tool Command parameter clarification

| |

RESTORE DATABASE command TSM example

| |

db2demigdbd usage examples

| |

db2ckbkp command usage note correction

| |

Naming conventions for database objects and for IDs

REORGCHK command

REORG INDEXES/TABLE command

BACKUP DATABASE command

Migrating Databases

db2inidb - Initialize a mirrored database command

Usage note for the db2iupdt command

New parameter for the db2sqljcustomize command

New parameter for the sqlj command

Monitor and troubleshoot command (db2pd) updates

Update to the SET CLIENT command

Update to the PRECOMPILE command

Update to the UPDATE HISTORY FILE command

Updates to the EXPORT and IMPORT commands

Update to the LOAD command

File type modifiers for the load utility

File type modifiers for the import utility

RECOVER DATABASE command

UPDATE HISTORY FILE command

| |

db2updv8 - Update database to version 8 current level command

Formatting trap files (Windows)

Bind files used by the export, import and load utilities

Using import with buffered inserts

Index information lost when the import utility is used

Data Recovery and High Availability

Backup overview

High availability disaster recovery overview

Cross-platform backup and restore support

Backing up to tape (Linux)

Tivoli Storage Manager

Value restrictions for the HADR local host and local service parameters

Additional system requirements for high availability disaster recovery

Non-replicated operations for high availability disaster recovery

HADR does not support raw logs

| |

Fault monitor and health monitor comparison

| |

Turning off fault monitoring

Data Warehouse Center

| |

Setting up the warehouse client environment on AIX and Solaris operating systems

Updating the database manager configuration before installing warehouse transformers

VW_NETRC environment variable added to the Data Warehouse Center (UNIX)

DB2 Data Warehouse Center requires Unicode format database

Defining DB2 warehouse sources and targets

Updates to the Business Intelligence tutorial

Setting the purge limit for warehouse log files

Data Warehouse Center support for CURSOR load

Unicode warehouse control database migration and limitations

Change in date format for Modified column

Defining statistical transformers in the Data Warehouse Center

| |

Preparing to install warehouse agents

Prerequisite for the iSeries warehouse agent

DB2 .NET Data Provider

Concurrent active data reader support

DB2Connection.ConnectionString property

Change to authentication type negotiation through a gateway

New security scenario

Corrections to diagrams

Development Center

DB2 Development Center Version 8.2 requires level 9.2.9 of the Distributed Debugger

Length restriction in the DB2 Development Center Change Variable Range window

Restrictions to DB2 Universal type 2 and type 4 drivers

Modifying the statement termination character

Database unavailable status in the database details pane of the Control Center

Default write to table output generation (Create Event Monitor)

Information Catalog Center

Configuration sample scripts

Web server configuration

Installation and Configuration Supplement

DB2 node configuration file - db2nodes.cfg

DB2NOLIOAIO registry variable replaced by DB2LINUXAIO (Linux)

Application server for DB2 UDB

DB2 Embedded Application Server enablement

Deploying DB2 Web Tools

Direct I/O on block devices (Linux)

DB2 Information Center daemon (Linux and UNIX)

Response file keywords and sample files

Response file installation error codes

Required user accounts for installation of DB2 servers (Windows)

Asynchronous I/O support (Linux)

db2ln command modified to create DB2 UDB 64-bit library links (Linux and UNIX)

Query Patroller

Query class behavior update

Definition updates for managed query states

Create Explain tables before running Query Patroller historical data generator

Checking Query Patroller log files for historical analysis

Abnormal shutdown of the historical data generator

Dynamic query class updates

Nested query behavior

Limitations by SQL statement type

Resolution limitation when using the Terminal Services Client

New group support for query submissions

Query Patroller schedule limitations

Authorization required to use RUN IN BACKGROUND QUERY command

Creating an alias for a result table

Fenced user ID requires write access qpdiag.log file and path

Quick Beginnings

| |

Updating the DB2 Information Center installed on your computer or intranet server

Memory requirements

| |

Clarification of DB2 UDB client support

Modifying kernel parameters (Linux)

Modifying kernel parameters (Solaris Operating Environment)

DB2 Universal Database Express Edition Version 8.2 Basics manual available for download

Verifying that your databases are ready for migration

Common Criteria certification for DB2 UDB

Spatial Extender

Verifying the Spatial Extender installation

SQL Administrative Routines

Incorrect column name documented in result set for SNAP_GET_DYN_SQL table function

Snapshot monitor table functions have version-specific views

GET_DB_CONFIG procedure requires an 8K minimum page size for a user temporary table space

| |

CREATE PROCEDURE (SQL) statement authorizations

EXPLAIN_DIAGNOSTIC: A new Explain table

EXPLAIN_DIAGNOSTIC_DATA: A new Explain table

Schema used by the Explain facility

String representations of datetime values

Health indicators summary

Decoupled applications list without connection concentrator enabled

Progress monitoring of the runtime rollback process

Parameter change to dxxGenXML, dxxGenXMLClob, dxxRetrieveXML, and dxxRetrieveXMLClob stored procedures

Decomposing XML documents into DB2 UDB data

Decomposing documents larger than 1 MB

Configuring MQ XML UDFs with XML Extender

XML Extender environment variable DB2DXX_MIN_TMPFILE_SIZE

DB2XML.XMLVarchar UDT redefinition

Appendix A. DB2 UDB FixPak CD directory structure

Appendix B. Contacting IBM

Product information

Appendix C. Notices

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