Release Notes

Contents

About the Release Notes

About this release

  • 6New in this release
  • 6Support for additional collating sequences when a new Unicode database is created
  • Product fix history
  • Backward compatibility
  • 3Alternate FixPaks (Linux and UNIX)
  • Data Warehouse Center previous server support restrictions
  • 4The Visual Warehouse 5.2 DB2 program "VW 5.2 Load flat file into DB2 UDB EEE (AIX only)" is not supported
  • DB2 Universal Database Version 7 server access
  • 2Development 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
  • 5Command Center and Version 7 servers
  • Two versions of SQL Assist are launched from DB2 UDB
  • Change in Unicode server behavior
  • Classic Connect unavailable
  • Product compatibility
  • 2IBM DB2 Development Add-In for Microsoft Visual Studio .NET
  • 6WebSphere Application Server's execution of SQL statements in an SQLJ program
  • 1Microsoft Visual Studio, Visual C++
  • Microsoft XP fix needed on 64-bit operating systems
  • 2CLI and ODBC on Windows 64-bit operating systems
  • 4Supported LDAP client and server configurations
  • Windows XP operating systems
  • 6Alternative Unicode conversion tables for the coded character set identifier (CCSID) 5039
  • 6Replacing the Unicode conversion tables for coded character set (CCSID) 5039 with the Microsoft conversion tables
  • 6Alternative Unicode conversion tables for the coded character set identifier (CCSID) 954
  • 6Replacing the Unicode conversion tables for coded character set (CCSID) 954 with the Microsoft conversion tables
  • MVS operating system not supported
  • 5DB2 UDB for AIX 4.3.3 and 5.1 and above require AIX C++ Version 6 Runtime
  • 5Accessing Java shared libraries (Linux)
  • Backup and restore (Linux 390)
  • ERwin 4.x metadata bridge
  • 2Enabling view docking when accessing the Development Center with Hummingbird Exceed

    • Installation, migration, upgrade, and configuration information

  • Installation information
  • 3Installing DB2 UDB (AIX)
  • 2Installing DB2 UDB (Linux)
  • 5Installing additional Asian fonts (Linux)
  • 6Restrictions to adding products using the db2setup command
  • 6Downloading and uncompressing Spatial Extender FixPaks
  • 6Binding Query Patroller packages after applying fixpaks
  • 6Installing Query Patroller at FixPak 3 level or later
  • DB2 Web Tools
  • Installing the DB2 Information Center for languages that are not options during installation
  • DB2 Universal Database, Version 8 HTML documentation installation restriction (Windows)
  • Installing MDAC files for national language versions of DB2 UDB
  • Migration information
  • 1Migrating DB2 Universal Database when using DataJoiner or replication
  • 5Migrating a DB2 Version 8 Windows 32-bit database to Windows 64-bit
  • 2Migrating XML Extender from previous versions
  • 4Database migration (HP-UX on IA64)

    • Known limitations, problems, and workarounds

  • Limitations
  • Development Center limitations for 64-bit operating systems
  • 2Development Center (Linux)
  • 4Debugging stored procedures with double quotation marks
  • Path settings needed to enable Java routines to compile in the Development Center
  • 6Development Center limitations to run and debug Java stored procedures simultaneously
  • 6Using LOB locators on a DB2 UDB for z/OS or OS/390 server
  • 5Failures when reporting a successful login during a connect (AIX)
  • 4JDBC driver limitation (HP-UX)
  • 3SNA support limitations in Version 8
  • 5Tools catalog database creation not supported (Linux AMD64)
  • 5Tools catalog database creation not supported (AIX, Solaris Operating Environments, and HP-UX)
  • 5Workgroup Server Edition 64-bit server instance limitations
  • Asynchronous execution of CLI
  • 2NUM_LOG_SPAN configuration parameter on a partitioned database
  • Limitation to the dasdrop command in multiple fix pack environments
  • Data Warehouse Center not available in simplified Chinese
  • Japanese names of remote objects
  • Restrictions for the Clean Data transformer
  • Replicating and accessing Client Connect warehouse sources using the warehouse agent
  • Scheduling a warehouse process to run at intervals
  • 3Data Warehouse Center restriction for import and export
  • 6Initialize the warehouse control database after installing version 8.1.2 or later
  • 4Cube Views sample application differs from sample source
  • Load and Import Columns page does not support DBCS characters in IXF files
  • Incorrect Task Center indicators given when a load operation fails
  • Minimum display settings for GUI tools
  • 2Do not partition Information Catalog Center tables
  • 5Query Patroller limitations when DYN_QUERY_MGMT is disabled
  • 5Query Patroller result tables now use DB2QPRT schema
  • 5ALTER WRAPPER SQL statement not supported
  • Health indicator restrictions
  • System monitor snapshot UDF restrictions
  • Known problems and workarounds
  • DB2 license policy for DB2 Universal Database Workgroup Server Edition
  • 5IBM Developer Kit for Java 1.3.1 required on Linux (x86, 32-bit)
  • The simplified Chinese locale (AIX)
  • 5The simplified Chinese locale (Red Hat Linux)
  • 5Merant Driver Manager incompatibility (UNIX)
  • Data Links server backup fails using Tivoli Storage Manager archive server (AIX, Solaris Operating Environment)
  • 4SQLFLAG (STD) precompiler option error
  • 5DB2 UDB Path for SQL Routine Compile Command (Windows)
  • 1Documentation search might fail unless all documentation categories are installed (AIX)
  • 1Documentation search problem with Java 2 JRE1.4.0
  • Displaying Indic characters in the DB2 GUI tools
  • GUI tools are not supported for zSeries servers (Linux)
  • 4Information Catalog Center log file not generated when importing tag language files
  • 6Binding Query Patroller packages
  • 1Secure environments (Windows)
  • 2XML Extender sample programs renamed
  • 4Decomposing documents in XML Extender that contain non unique attribute and element names
  • 5Differences between SNA and TCP/IP when using DB2 Connect

    • Documentation updates

  • Administration: Performance tuning
  • 6Default value for DB2_ENABLE_BUFPD registry variable
  • Application development: Call Level Interface (CLI)
  • 6MapDateDescribe CLI/ODBC configuration keyword
  • 6MapTimeDescribe CLI/ODBC configuration keyword
  • 6MapTimestampDescribe CLI/ODBC configuration keyword
  • Command Reference
  • 6db2inidb - Initialize a mirrored database command
  • Data Warehouse Center
  • 6Updates to the Business Intelligence Tutorial
  • 6Setting the purge limit for warehouse log files
  • 4Data Warehouse Center support for CURSOR load
  • GUI tools
  • Control Center plug-in support
  • Message Reference
  • 5Version 8.1.4 Information Center message topics
  • 5ADM message updates
  • 5SQL message additions
  • 5DBI message updates
  • Query Patroller
  • 5Create Explain tables before running Query Patroller Historical Data Generator
  • 5Checking Query Patroller log files for historical analysis
  • 6Dynamic query class updates
  • 6Nested query behavior
  • 6Abnormal shutdown of the Historical Data Generator
  • 6Limitations by SQL statement type
  • System Monitor
  • 6SYSMON_GROUP database manager configuration parameter replaces DB2_SNAPSHOT_NOAUTH registry variable
  • SQL Reference
  • 5SQL limits
  • XML Extender
  • 6XMLVARCHAR UDT size limit removed
  • 6New environment variable: DB2DXX_MIN_TMPFILE_SIZE

    • 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 | Table of Contents ]