Contents

About the Release Notes
About this release
New in this release
8 8
DB2 UDB Workgroup Server Edition and DB2 UDB Workgroup Server Unlimited Edition enhancements
8 8
DB2 UDB support on Windows AMD64 platform
8 8
Creation of 32-bit and 64-bit instances
8 8
New registry variable: DB2_ASYNC_IO_MAXFILOP
8 8
New SMS user table space for automatic maintenance and maintenance health indicators
Product fix history
Backward compatibility
8 8
Backward compatibility of DB2 UDB Version 8.2 databases
8 8
Clarification of DB2 UDB client support
7 7
Health registry changes when migrating from DB2 UDB Version 8.2 back to DB2 UDB Version 8.1
3 3
Alternate FixPaks (Linux and UNIX)
Data Warehouse Center previous server support restrictions
Development Center APARs required for SQLJ and SQL Assist support on DB2 UDB for OS/390, Version 6 and DB2 UDB for z/OS, Version 7
Two versions of SQL Assist are launched from DB2 UDB
Change in Unicode server behavior
8 8
Database configuration parameter changes during migration
7 7
db2diag.log format message enhancements
7 7
db2set profile registry variables and DB or DBM configuration parameters are now logged
Product compatibility
Microsoft XP fix is needed on 64-bit operating systems
Windows XP operating systems
8 8
DB2 UDB HADR separately priced option available
8 8
DB2 Warehouse Manager (Version 8.2) and IBM DB2 OLAP Server FP3 and later
8 8
Red Hat Linux support with the Data Warehouse Center
6 6
Alternative Unicode conversion tables for the coded character set identifier (CCSID) 5039
6 6
Replacing the Unicode conversion tables for coded character set (CCSID) 5039 with the Microsoft conversion tables
6 6
Alternative Unicode conversion tables for the coded character set identifier (CCSID) 954
6 6
Replacing the Unicode conversion tables for coded character set (CCSID) 954 with the Microsoft conversion tables
7 7
Alternative Unicode conversion tables for the coded character set identifier (CCSID) 943
7 7
Replacing the Unicode conversion tables for coded character set (CCSID) 943 with the Microsoft conversion tables
MVS operating system is not supported
Backup and restore operations (Linux 390)
2 2
Enabling view docking when accessing the Development Center with Hummingbird Exceed
Installation, migration, upgrade, and configuration information
Hardware and software requirements
Installation notes
3 3
Directory path cannot contain blanks (Linux and UNIX)
JDK levels for DB2 UDB (Linux on IA64 and Linux on PowerPC)
7 7
Uncompressing installation images (Linux and UNIX)
2 2
DB2 UDB does not allow non-English installation path (Windows)
6 6
Downloading and uncompressing FixPaks for multiple products (Windows)
7 7
Installing DB2 UDB from installation images (Linux and UNIX)
7 7
Installing DB2 UDB from installation images (Windows)
7 7
Disk space required for a DB2 UDB response file installation
6 6
Restrictions to adding products using the db2setup command (Linux and UNIX)
DB2 Web Tools
6 6
Binding Query Patroller packages after applying fixpaks
6 6
Query Patroller installation at FixPak 3 level or later
2 2
Query Patroller server installation
7 7
Defining a new database partition group in Query Patroller
2 2
Query Patroller client tools installation
7 7
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)
7 7
Creating group and user IDs on United Linux 1.0 and SuSE Linux distributions
7 7
Help system daemon does not start after installing with the db2_install command (UNIX and Linux)
Ready for Tivoli enablement (UNIX)
7 7
Installation image reduction tool (Windows)
DB2 Universal Database, Version 8 HTML documentation installation restriction (Windows)
3 3
Previous installations updated to the latest level (Windows)
3 3
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
Migrating DB2 Universal Database (Windows)
1 1
Migrating DB2 Universal Database when using DataJoiner or replication
5 5
Migrating a DB2 Version 8 Windows 32-bit database to Windows 64-bit
2 2
Migrating XML Extender from previous versions
4 4
Database migration (HP-UX on IA64)
Uninstallation information
7 7
Uninstalling DB2 UDB silently (Windows)
7 7
Product code for DB2 Information Center removal using a silent uninstall (Windows)
Limitations
7 7
IMPORT REPLACE does not honor the Not Logged Initially clause
7 7
Data export with ODBC to file warehouse program
8 8
Data types that are not supported in the Development Center's integrated SQL debugger
7 7
Structured types in the Development Center
Development Center limitations for 64-bit operating systems
2 2
Development Center (Linux)
4 4
Debugging stored procedures with double quotation marks
Path settings needed to enable Java routines to compile in the Development Center
6 6
Development Center limitations to run and debug Java stored procedures simultaneously
7 7
Cursors in PHP applications
8 8
AM_GET_LOCK_RPT procedure is not supported in partitioned database environments (AIX)
7 7
Four unsupported SQL administrative routines
7 7
Bind option limitations for CLI packages
7 7
CLI LOAD restriction for specifying column names
5 5
Failures when reporting a successful login during a connection attempt (AIX)
3 3
SNA support limitations in Version 8
5 5
Tools catalog database creation not supported (Linux for AMD64)
5 5
Tools catalog database creation not supported (AIX, Solaris Operating Environments, and HP-UX)
8 8
Memory limitations for DB2 UDB Express and DB2 Workgroup Server Edition V8.2
8 8
DB2 UDB Workgroup Server Edition 64-bit server instance limitations
Scheduling a warehouse process to run at intervals
Load and Import Columns page does not support DBCS characters in IXF files
8 8
Security plug-in problem and restriction for DB2 UDB clients (Windows)
7 7
Two-part user ID not supported (Windows ME)
Minimum display settings for GUI tools
2 2
Do not partition Information Catalog Center tables
7 7
Improper display of GB18030 characters in the title bar of a window
5 5
Query Patroller limitations when DYN_QUERY_MGMT is disabled
5 5
Query Patroller result tables now use DB2QPRT schema
Health indicator restrictions
Known problems and workarounds
8 8
The db2nkill tool is not shipped in DB2 UDB Workgroup Server Edition
8 8
The "db2gcf -k" command fails on DB2 UDB Workgroup Server Edition
7 7
SQL1224 error from DRDA wrapper (AIX)
7 7
Hotkeys not working in Microsoft Visual Studio .NET Framework 1.1
The simplified Chinese locale (AIX)
The simplified Chinese locale (Red Hat Linux)
5 5
Merant Driver Manager incompatibility (UNIX)
2 2
NFS APAR IY32512 - Unavailable threads (AIX)
4 4
SQLFLAG (STD) precompiler option error
7 7
DB2 Connect Custom Advisor
8 8
Tools catalog database creation fails (HP-UX)
Displaying Indic characters in the DB2 GUI tools
GUI tools are not supported for zSeries servers (Linux)
7 7
Enclose DB2 Information Center search terms within quotation marks if they contain numbers
4 4
Information Catalog Center log file not generated when importing tag language files
6 6
Binding Query Patroller packages
7 7
Unavailability of ports with Query Patroller (Windows)
1 1
Secure environments (Windows)
2 2
XML Extender sample programs renamed
2 2
Using the new sample programs with the sample sqx files
4 4
Decomposing documents in XML Extender that contain non unique attribute and element names
5 5
Differences between SNA and TCP/IP when using DB2 Connect
Documentation updates
Administration: Implementation
8 8
Authentication considerations for remote clients
8 8
Direct I/O (DIO) and concurrent I/O (CIO) support
8 8
Distributor technology and automatic client rerouting
7 7
Automatic client reroute considerations for cataloging on a DB2 Connect server
7 7
Local system account support (Windows)
7 7
Two-part user ID support
7 7
Additional information for Kerberos support
Administration: Performance
8 8
New system environment variables (Linux)
7 7
New communication registry variable
7 7
New performance variable
8 8
SQL compiler variables
8 8
Configuration parameter updates
8 8
SQLDBCONF database configuration parameter file
8 8
Change to the DB2_HASH_JOIN default value
7 7
DB2NTNOCACHE registry variable is deprecated
7 7
Explain tables and organization of explain information
7 7
Guidelines for capturing explain information
7 7
Additional return codes from db2CfgGet API, collate_info parameter
8 8
Automatic setting of default prefetch size and update defaults
Administration: Planning
8 8
Supported territory codes and code pages
7 7
XA function supported by DB2 Universal Database
8 8
Updated TPM and tp_mon_name values for xa_open string formats
7 7
Activating conversion tables for code pages 923 and 924
7 7
Conversion table files for euro-enabled code pages
API Reference
8 8
SYNCPOINT option support
7 7
New field for SQLEDBDESC structure
7 7
Correction to new field in the SQLB-TBSPQRY-DATA structure
Application development: Building and Running Applications
7 7
Customizing precompile and bind options for SQL procedures
7 7
C/C++ compile option required (Linux on PowerPC 64-bit)
7 7
Compile and link command for Micro Focus COBOL stored procedures (HP-UX)
7 7
Minimum supported version of Micro Focus COBOL (HP-UX)
7 7
Setting environment variables for Micro Focus COBOL stored procedures (Windows)
Application development: Call Level Interface (CLI)
7 7
MapBigintCDefault CLI/ODBC configuration keyword
7 7
DescribeOutputLevel CLI/ODBC configuration keyword
Application development: Programming Client Applications
8 8
OleDbReportIsLongForLongTypes CLI/ODBC configuration keyword
8 8
OleDbSQLColumnsSortByOrdinal CLI/ODBC configuration keyword
8 8
DB2 Data Source property group for the IBM DB2 OLE DB Provider
8 8
Incorrect URL syntax in the DB2Binder syntax diagram
8 8
Rerouting DB2 Universal JDBC driver clients
7 7
Customizing the DB2 Universal JDBC driver configuration properties
7 7
db2secFreeToken function removed
8 8
Deploy custom security plug-ins carefully
7 7
Security plug-ins
7 7
Security plug-in APIs
7 7
Security plug-in naming conventions (Linux and UNIX)
7 7
Restrictions on security plug-in libraries
8 8
GSS-API security plug-ins do not support multiple-flow authentication
8 8
GSS-API security plug-ins do not support message encryption and signing
7 7
Implicit ending of transactions in stand-alone applications
8 8
Distributed transaction support
Application development: Programming Server Applications
7 7
Common language run time (CLR) routine execution control modes (EXECUTION CONTROL clause)
7 7
Maximum decimal precision and scale in common language run time (CLR) routines
Command Reference
6 6
db2inidb - Initialize a mirrored database command
7 7
Usage note for the db2iupdt command
7 7
db2pd - Monitor and troubleshoot DB2 command
7 7
New parameter for the db2sqljcustomize command
7 7
New parameter for the sqlj command
8 8
Update to the SET CLIENT command
8 8
Update to the PRECOMPILE command
8 8
Update to the UPDATE HISTORY FILE command
8 8
Updates to the EXPORT and IMPORT commands
8 8
Update to the LOAD command
8 8
File type modifiers for the load utility
8 8
File type modifiers for the import utility
7 7
ATTACH command
7 7
RECOVER DATABASE command
7 7
UPDATE HISTORY FILE command
7 7
db2updv8 - Update database to version 8 current level command
7 7
Formatting trap files (Windows)
Data Movement
8 8
Index information lost when the import utility is used
Data Recovery and High Availability
8 8
High availability disaster recovery overview
7 7
Cross-platform backup and restore support
7 7
Backing up to tape (Linux)
7 7
Tivoli Storage Manager
7 7
Value restrictions for the HADR local host and local service parameters
7 7
Additional system requirements for high availability disaster recovery
7 7
Non-replicated operations for high availability disaster recovery
7 7
HADR does not support raw logs
Data Warehouse Center
8 8
Defining DB2 warehouse sources and targets
6 6
Updates to the Business Intelligence tutorial
6 6
Setting the purge limit for warehouse log files
4 4
Data Warehouse Center support for CURSOR load
7 7
Unicode warehouse control database migration and limitations
7 7
Change in date format for Modified column
7 7
Defining statistical transformers in the Data Warehouse Center
7 7
Prerequisite for the iSeries warehouse agent
DB2 .NET Data Provider
7 7
DB2Connection.ConnectionString property
DB2 Connect
7 7
New security scenario
7 7
Corrections to diagrams
Development Center
7 7
Restrictions to DB2 Universal type 2 and type 4 drivers
GUI Tools
8 8
Modifying the statement termination character
7 7
Database unavailable status in the database details pane of the Control Center
7 7
Default write to table output generation (Create Event Monitor)
Information Catalog Center
7 7
Configuration sample scripts
7 7
Web server configuration
Installation and Configuration Supplement
7 7
Application server for DB2 UDB
7 7
DB2 Embedded Application Server enablement
7 7
Deploying DB2 Web Tools
7 7
Direct I/O on block devices (Linux)
7 7
DB2 Information Center daemon (Linux and UNIX)
8 8
Response file keywords and sample files
7 7
Response file installation error codes
7 7
Required user accounts for installation of DB2 servers (Windows)
7 7
Asynchronous I/O support (Linux)
8 8
db2ln command modified to create DB2 UDB 64-bit library links (Linux and UNIX)
Message Reference
ADM message updates
CLP message updates
5 5
DBI message updates
SQL message additions and updates
Query Patroller
8 8
Definition updates for managed query states
5 5
Create Explain tables before running Query Patroller historical data generator
5 5
Checking Query Patroller log files for historical analysis
6 6
Abnormal shutdown of the historical data generator
6 6
Dynamic query class updates
6 6
Nested query behavior
6 6
Limitations by SQL statement type
7 7
Resolution limitation when using the Terminal Services Client
7 7
New group support for query submissions
7 7
Query Patroller schedule limitations
7 7
Authorization required to use RUN IN BACKGROUND QUERY command
7 7
Creating an alias for a result table
8 8
Fenced user ID requires write access qpdiag.log file and path
Quick Beginnings
7 7
Verifying that your databases are ready for migration
7 7
Common Criteria certification for DB2 UDB
Spatial Extender
7 7
Verifying the Spatial Extender installation
SQL Administrative Routines
8 8
EXEC_DB2_SCRIPT procedure unavailable
8 8
GET_DB_CONFIG is a stored procedure
7 7
Column expansion for snapshot UDFs
SQL Reference
7 7
CONNECT statement
7 7
Schema used by the Explain facility
String representations of datetime values
System monitor
7 7
Decoupled applications list without connection concentrator enabled
7 7
Progress monitoring of the run time rollback process
XML Extender
8 8
Decomposing documents larger than 1 MB
7 7
Configuring MQ XML UDFs with XML Extender
7 7
XML Extender environment variable DB2DXX_MIN_TMPFILE_SIZE
7 7
DB2XML.XMLVarchar UDT redefinition
Appendix A. DB2 UDB FixPak CD directory structure
Appendix B. Contacting IBM
Product information
Appendix C. Notices
Trademarks
[ Top of Page |Previous Page | Next Page | Contents ]