DB2 Universal Database Version 8.1.2 Release Notes (version 8.1.2) Contents i) About the Release Notes What's New for Version 8.1.2 Windows enhancements Linux enhancements Informix integration Business intelligence enhancements DB2 Express Product changes Performance enhancements Usability enhancements DB2 for z/OS enhancements Application development enhancements Known problems and workarounds (Version 8.1.2) Product and product-level support Alternate FixPaks Back-level DB2 server support DB2 Universal Database version 7 server access Classic Connect unavailable Data Warehouse Center not available in Simplified Chinese Data Warehouse Center down-level server support restrictions DB2 administration server (DAS) DB2 license policy for DB2 Workgroup Server Edition DB2 Web Tools DB2 Warehouse Manager not available in Simplified Chinese Development Center APARs required for SQLJ and SQL Assist support on DB2 UDB Version 6 for OS/390 and DB2 UDB Version 7 for z/OS Development Center limitations for 64-bit operating systems Development Center on the Intel 32-bit Linux operating system Development Center supports the Windows 98 operating system Development Center now supports Actual Cost information for SQL statements run on OS/390 or z/OS servers Federated systems restrictions High availability function is included in DB2 Universal Database Workgroup Server Edition IBM DB2 Development Add-In for Microsoft Visual Studio .NET Installation on Linux License Center back-level versions not supported Microsoft Visual Studio, Visual C++ Microsoft XP fix needed on 64-bit operating systems MVS operating system not supported Support for DB2 XML Extender on a Solaris Operating Environment and on Windows Server 2003 Windows XP operating systems Application development Asynchronous execution of CLI CLI and ODBC on Windows 64-bit operating systems Configuration Assistant Unsupported bind options Configuration parameters NUM_LOG_SPAN configuration parameter on a multi-partition database DB2 Backup and Restore Backup and restore on Linux 390 operating systems DB2 Data Links Manager Data Links server backup fails using Tivoli Storage Manager archive server (AIX, Solaris Operating Environment) Migrating DB2 when using DataJoiner or replication DB2 Replication Java Administrative API documentation for DB2 Data Replication Column mapping restrictions and the Replication Center Replication Center restrictions on iSeries systems Workaround for the replication asnscrt command (Windows only) Data Warehouse Center ERwin 4.x metadata bridge Japanese names of remote objects Restrictions for the Clean Data transformer Using the warehouse agent for replication and accessing Client Connect warehouse sources Scheduling a warehouse process to run at intervals Documentation DB2 Replication Guide and Reference documentation DB2 Version 8 HTML documentation installation restriction (Windows) Documentation search may fail on AIX unless all documentation categories are installed Documentation search problem with Java 2 JRE1.4.0 Installation of the DB2 Information Center for languages that are not options during installation Official naming convention for DB2 for Linux when used on host systems GUI tools Control Center plugin support Displaying Indic characters in the DB2 GUI tools GUI tools not supported for zSeries servers running Linux operating systems Load and Import Columns page does not support DBCS characters in IXF files Incorrect indicators given when a load operation fails Minimum display settings for GUI tools SQL1224N error when using the GUI tools on AIX Health Monitor Health Monitor off by default Health indicator restrictions dasdrop limitation in multiple FixPak environments Information Catalog Center tables Do not partition information catalog tables Secure Windows environments SQL Assist SQL Assist button disabled in the Command Center Two versions of SQL Assist are launched from DB2 Throttled utility restrictions XML Extender Renaming of xml extender sample programs XML Extender on a partitioned database environment. Additional Information Change in Unicode server behavior Full message text is not returned when using SQLException.getMessage() IBM DB2 universal JDBC driver Java functions and routines on UNIX and Windows operating systems English Microsoft Data Access Components (MDAC) files are used for all national language versions of DB2 V8.1 unless translated MDAC files are installed first. The Simplified Chinese locale on AIX operating systems Online help corrections and updates Configuring the C environment for SQL stored procedures in the Development Center Enabling view docking when accessing Development Center with Hummingbird Exceed Microsoft Visual Studio .NET add-in information update in Development Center help Migrating DB2 XML Extender to Version 8.1.2 Path settings to enable Java routines to compile in the Development Center Runstats dialog - updated getting there information Spatial Extender - requirements when using the Index Advisor Specifying build options for a Java stored procedure in the Development Center Appendix. Notices Trademarks i) About the Release Notes Content The release notes contain the latest information for the following DB2, Version 8 products: DB2(R) Universal Database Personal Edition DB2 Universal Database(TM) Workgroup Server Edition DB2 Universal Database Workgroup Server Unlimited Edition DB2 Universal Database Enterprise Server Edition DB2 Personal Developer's Edition DB2 Universal Developer's Edition DB2 Warehouse Manager DB2 Warehouse Manager Sourcing Agent for z/OS(TM) DB2 Data Links Manager DB2 Net Search Extender DB2 Spatial Extender DB2 Intelligent Miner(TM) Scoring DB2 Intelligent Miner Modeling DB2 Intelligent Miner Visualization DB2 Connect(TM) Application Server Edition DB2 Connect Enterprise Edition DB2 Connect Personal Edition DB2 Connect Unlimited Edition Structure The release notes are divided into three parts. The first part highlights what is new in this release. The second part contains the details of the problems, limitations, and workarounds known at the time of publication that affect the latest version of the products listed above. Read these notes to become familiar with any known outstanding issues with this release of the DB2 family of products. The third part contains corrections and updates to the information available in the product GUI tools help. The most up-to-date documentation is available in the latest version of the DB2 Information Center accessed through a browser. A revision mark indicates text that has been added or changed since the PDF information for version 8.1 was originally made available. A vertical bar (|) indicates information that was added at the time that version 8.1 was first released. A numeric indicator, such as a 1 or a 2, indicates that the information was added for the FixPak or release level ending in the same number.For example, a 1 indicates that the information was added or changed in FixPak 1, a 2 indicates that the information was changed for Version 8.1.2. The Data Links Manager Administration Guide and Reference was updated in PDF form (book number SC27-1221-01) at the time of FixPak 1, and is available for download at the DB2 support site. Multiple FixPaks for Enterprise Server Edition (ESE) operating on UNIX-based systems Version 8 for DB2 Enterprise Server Edition (ESE) operating on UNIX-based operating systems now supports the coexistence of multiple FixPak levels through the use of Alternate FixPaks. Prior to DB2 Version 8, FixPaks only functioned as updates to an installed package or fileset. Essentially, this meant that the O/S installer would replace existing files with the updated ones provided within the FixPak. DB2 ESE Version 8.1 code and DB2 ESE Version 8.1 FixPak 1 code can now both be installed at the same time. This is accomplished by the fact that there are now two FixPaks for ESE on UNIX-based operating systems. The first one is the Regular FixPak which is installed directly on top of the existing installation either in /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1. The second one is an Alternate FixPak which installs a completely new copy of DB2 in a separate location with the FixPaks already applied. Alternate FixPaks are intended to be used for testing FixPaks alongside production systems, but not to be used as the production system itself. Notes: 1. The installation paths used in this documentation all specify the default path even though the product may have been installed somewhere else. 2. You are not required to perform a multiple FixPak installation if you do not feel it is necessary for your environment. 3. There is currently no plan to support the application of a regular FixPak on top of an Alternate FixPak. Therefore, the Alternate FixPak is intended for use alongside your production environment, but not as your primary production system.. For further information regarding downloading Alternate FixPaks, visit the IBM support site at http://www.ibm.com/software/data/db2/udb/winos2unix/support. Additional resources Documentation for the DB2 Life Sciences Data Connect product is available for download from the IBM software site: http://www.ibm.com/software/data/db2/lifesciencesdataconnect/library.html. More information on the DB2 Development Center and DB2 for z/OS is available at http://www.ibm.com/software/data/db2/os390/spb/. For the latest information about the DB2 family of products, obtain a free subscription to DB2 Magazine. The online edition of the magazine is available at http://www.db2mag.com; instructions for requesting a subscription are also posted on this site. What's New for Version 8.1.2 Windows enhancements Additional platform portability and openness DB2 UDB has added support for the new Microsoft(R) Windows(R) 2003 Server release. And provides new 64-bit version of DB2 for Windows optimized for servers based on Intel Itanium 2 processors. Add-ins for Microsoft Visual Studio .NET Simplify the task of building ADO.NET applications, using the Visual Studio .NET integrated development environment (IDE) to build DB2 server-side objects, such as, stored procedures and user-defined SQL functions (UDFs). Also enhanced is the interoperability between the Web Services implemented via DB2 and Microsoft .NET applications calling these web services. DB2 .NET Data Provider is native provider written in managed C# code Delivers high-performing, secure access to DB2 data. As with all other application programming interfaces provided by DB2, the DB2 .NET Data Provider is developed and tested in-house by the DB2 Development organization, the people who really know DB2, to deliver the best possible exploitation of DB2 features and functions for ADO.NET programmers. Application development using the ADO.NET APIs Application programmers can now develop high-performing WinForm, WebForm, and mobile WebForm applications using the ADO.NET APIs. These applications can be developed to work with data managed by DB2 UDB V8.1 servers running on Linux, UNIX(R) and Windows, as well as DB2 for OS/390(R) and z/OS database servers. When used in conjunction with stored procedures and the federated database capabilities of DB2 UDB and DB2 Connect servers, this data access can be extended to include a wide variety of other data sources, including non-DB2 mainframe data (such as VSAM, CICS, IMS), Informix(TM) Dynamic Server (IDS), Microsoft SQL Server, Sybase, and Oracle(R) databases as well as any data source that has an OLE DB Provider available. Linux enhancements Additional platform portability and openness DB2 UDB has added support for industry open Linux, including: * A 64-bit version of DB2 for Linux optimized for Intel Itanium 2 based servers. * 32-bit versions of DB2 for IBM eServer iSeries(TM) and pSeries(TM) running Linux. * A 64-bit version of DB2 for Linux optimized for AMD Opteron based servers will be added at a later time. Customers interested in participating in the beta program for the 64-bit AMD Opteron version of DB2 for Linux can find it at http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=dm-db2betas . LDAP functionality Added for Linux IA32 and Linux390 using IBM SecureWay(R) Directory Version 3.2.2. Informix integration DB2 now supports the SET ISOLATION statement when issued from the Informix set of products. Business intelligence enhancements Query Patroller Query Patroller is now a stand-alone product that manages and controls all aspects of query submission. Data Warehouse Center and Warehouse Manager You can now transfer data between Red Brick(TM) Warehouse and DB2. Health Center Health Center enhancements include improved alert filtering, better health indicator alerts and action recommendations for sort heap parameters, and an expanded Alert details dialog. DB2 Express DB2 Express is a specially tailored database offering for the worldwide small and medium business (SMB) customers. Its transparent install within a customer application, attractive entry price, simplified packaging, platform choices, autonomic manageability features, lower total cost of ownership, business partner applications, and support accelerate time to value for the SMB customers. Product changes IBM DB2 Information Integrator is the successor product for IBM DB2 Relational Connect, IBM DB2 Life Sciences Data Connect, and IBM DB2 DataJoiner. Performance enhancements Throttle utilities Utilities such as BACKUP and REBALANCE can be throttled or regulated to control their impact on your production systems. MERGE statement The MERGE statement lets you combine INSERT, DELETE, and UPDATE operations. Random sampling The TABLESAMPLE clause lets you run your queries against a random sample of your database. Usability enhancements Customized folders You can now create customized folders in your view of the Control Center's object tree. Information Center enhancements The DB2 Information Center has changed and expanded to include more libraries and allow better linking. DB2 for z/OS enhancements Enhancements to DB2 for z/OS include: * Control Center enhancements for managing DB2 for z/OS data sets * CURRENT PACKAGE PATH special register * Support for longer SQL statements (up to 2MB) * Support for SELECT from an INSERT * Diagnostic information that identifies the origin of an SQL statement Application development enhancements Application development enhancements include: * Java(TM) programmers * New enhanced JDBC Type 2 driver * J2EE and Web Services Enhancements * Improved support for JTA (Loosely Coupled Transactions) * Development Center enhancements * Microsoft programmers * Visual Studio .NET Add-ins * DB2 .NET Data Provider * Enhanced OLE DB provider * Improved support for COM+ (Loosely Coupled Transactions) * XML * Additional SQLXML function for simplified composition of XML documents from DB2 data * XML Extender enhancements * support for XML Schema * performance enhancements * support for use of XML Extender with partitioned databases * Web Services * Improved support for Microsoft .NET applications calling DB2 Web Services * An Integrated HTTP server and SOAP engine * SOAP calls as UDFs * SQL support * MERGE statement * SET ISOLATION statement SOAP engine * ALTER TABLE statement that allows extending length of a VARGRAPHIC columns * Support for IDENTITY columns in partitioned database environments * IBM eServer zSeries(TM) for Linux: Net Search Extender Support Known problems and workarounds (Version 8.1.2) The following are the currently known limitations problems and workarounds for DB2(R) Universal Database Version 8.1.2. The information in this section applies only to the version 8.1.2 release of DB2 Universal Database, and its supporting products. Any limitations and restrictions might or might not apply to other releases of the product. Product and product-level support Alternate FixPaks There is currently no plan to support the application of a regular FixPak on top of an Alternate FixPak. Therefore, the Alternate FixPak is only intended for use as a test system. Back-level DB2 server support If you migrate your DB2 client systems to version 8 before you have migrated all of your DB2 servers to version 8, several restrictions and limitations apply. For version 8 clients to work with version 7 servers, you need to configure and enable the use of DRDA(R) application server capability on the version 7 server. For information on how to do this, refer to the version 7 Installation and Configuration Supplement. You cannot access a DB2 Connect(TM) Version 7 server from a DB2 Version 8 client. When accessing version 7 servers from version 8 clients, there is no support available for the following: * The following data types: * Large object (LOB) data types * User-defined distinct types * DATALINK data types The DATALINK data type allows for the management of external data found in nonrelational storage. The DATALINK data type references files that physically reside on file systems external to DB2 Universal Database. * The following security capabilities: * Authentication type SERVER_ENCRYPT SERVER_ENCRYPT is a method to encrypt a password. The encrypted password is used with the user ID to authenticate the user. * Changing passwords You are not able to change passwords on the version 7 server from a version 8 client. * The following connections and communication protocols: * Instance requests that require an ATTACH instead of a connection ATTACH is not supported from a version 8 client to a version 7 server. * Network protocols other than TCP/IP. (SNA, NetBIOS, IPX/SPX, and others) * The following application features and tasks: * The DESCRIBE INPUT statement for all applications except ODBC/JDBC In order to support version 8 clients running ODBC/JDBC applications that access version 7 servers, a fix for DESCRIBE INPUT support must be applied to all version 7 servers where this type of access is required. This fix is associated with APAR IY30655. Use the "Contacting IBM(R)" information in any DB2 documentation set (PDF or HTML) to find out how to get the fix associated with APAR IY30655. The DESCRIBE INPUT statement is a performance and usability enhancement that allows an application requestor to obtain a description of input parameter markers in a prepared statement. For a CALL statement, this includes the parameter markers associated with the IN and INOUT parameters for the stored procedure. * Two-phase commit The version 7 server cannot be used as a transaction manager database when using coordinated transactions that involve version 8 clients, nor can a version 7 server participate in a coordinated transaction where a version 8 server may be the transaction manager database. * XA-compliant transaction managers An application using a version 8 client cannot use a version 7 server as an XA resource. This includes WebSphere, Microsoft(R) COM+/MTS, BEA WebLogic, and others that are part of a transaction management arrangement. * Monitoring * Utilities that can be initiated by a client to a server * SQL statements greater than 32 KB in size There are similar limitations and restrictions for version 8 tools working with version 7 servers. The following version 8 GUI tools, products, and Centers support only version 8 servers: * Control Center * Development Center * Health Center (including the Web version of this center) * Indoubt Transaction Manager * Information Catalog Center (including the Web version of this center) * Journal * License Center * Satellite Administration Center * Spatial Extender * Task Center * Tools Settings The following version 8 tools support version 7 servers (with some restrictions): * Command Center (including the Web version of this center) Saving, importing, and scheduling of scripts are not supported by the Command Center. * Data Warehouse Center * Replication Center * The import/export configuration file function of the Configuration Assistant * SQL Assist * Visual Explain In general, any version 8 tool that is only launched from within the navigation tree of the Control Center, or any details view based on such a tool, will not be available or accessible to version 7 and earlier servers. You should consider using the version 7 tools when working with version 7 or earlier servers. DB2 Universal Database version 7 server access To access a DB2 Universal Database(TM) Version 7 server on a Linux, UNIX, or Windows(R) operating system from a version 8 client, you must have version 7 FixPak 8 or later installed on your server and have run the db2updv7 command. For instructions on installing the version 7 FixPaks, refer to the version 7 FixPak Readme and Release Notes. You cannot access a DB2 Connect Version 7 server from a DB2 Version 8 client Classic Connect unavailable The Classic Connect product is not available. Although you may find references to the Classic Connect product in the Data Warehouse documentation and elsewhere, these should be ignored, as they are no longer applicable. Data Warehouse Center not available in Simplified Chinese The Data Warehouse Center is not available in Simplified Chinese. Data Warehouse Center down-level server support restrictions The following limitations exist for down-level server support for DB2 Enterprise Server Edition Version 8 Data Warehouse Center: Large Object (LOB) support * If you are using a warehouse control database on a server that is older than DB2 Enterprise Server Edition Version 8 you will not be able to work with LOBs. You must upgrade the warehouse control database to the correct level, or move the control database to the system where the DB2 Enterprise Server Edition Version 8 warehouse server is installed and use it locally from that system. * If you want to move LOBs back and forth between the Data Warehouse Center and DB2, you must upgrade to DB2 Enterprise Server Edition Version 8. SNA support If you use SNA to connect to your warehouse sources and targets, you must change the configuration to be TCP/IP over SNA, or use the Windows NT(R) warehouse agent. Support for EXPORT and LOAD utilities When you upgrade your warehouse agent, you must also upgrade your source target databases, or replace the EXPORT and LOAD utilities in your warehouse processes with SQL Select and Insert steps. SQL Select and Insert steps use a DELETE* command followed by SELECT and INSERT commands. SQL Select and Insert steps require the database to log all transactions. As a result, the performance for SQL Select and Insert steps is not as efficient as it is for EXPORT and LOAD utilities. DB2 administration server (DAS) On AIX(R) 5L, HP-UX and the Solaris(TM) Operating Environment, if the tools catalog database is created in a 64-bit instance, DAS migration (dasmigr) and back-level Script Center and Journal are not supported. DB2 license policy for DB2 Workgroup Server Edition Although the DB2 Quick Beginnings for Servers book and the online tools help for the License Center indicate otherwise, the Internet license policy is not valid for DB2 Universal Database Workgroup Server Edition. If you need a license for Internet users, you must purchase DB2 Universal Database Unlimited Workgroup Server Edition. DB2 Web Tools The application servers supported by DB2 Web Tools for the following languages are required to be compliant with the Servlet 2.3 specification: * Japanese * Korean * Simplified Chinese * Traditional Chinese * Russian * Polish DB2 Warehouse Manager not available in Simplified Chinese The DB2 Warehouse Manager is unavailable in Simplified Chinese. Therefore, the following dependent DB2 components are also unavailable in this environment: * The Information Catalog Center, which is dependent on the Manage Information Catalog wizard component of DB2 Warehouse Manager. * The DB2 Warehouse Manager Connector for the Web and the DB2 Warehouse Manager Connector for SAP, which are dependent on the installation of the DB2 Warehouse Manager. Development Center APARs required for SQLJ and SQL Assist support on DB2 UDB Version 6 for OS/390 and DB2 UDB Version 7 for z/OS When using the Development Center on an Application Development Client for DB2 Version 8 on Windows or UNIX(R) operating systems, the following APARs need to be installed on the server to enable SQLJ and SQL Assist support: DB2 UDB Version 7 on z/OS(TM) * PQ65125 - Provides SQLJ support for building JAVA SQLJ stored procedures * PQ62695 - Provides SQL Assist support DB2 UDB Version 6 on OS/390(R) * PQ62695 - Provides SQL Assist support Development Center limitations for 64-bit operating systems Debugging of JAVA stored procedures against a 64-bit server is not supported by the Development Center. Debugging SQL stored procedures is supported on 64-bit Windows operating systems. OLE DB and XML are not supported on 64-bit servers. Development Center on the Intel 32-bit Linux operating system You cannot use the Development Center to debug Java(TM) stored procedures running on the Intel 32-bit Linux operating system. Development Center supports the Windows 98 operating system The Development Center is supported on the Windows 98 operating system. Development Center now supports Actual Cost information for SQL statements run on OS/390 or z/OS servers The DB2 Development Center now provides Actual Cost information for SQL statements run on DB2 Version 6 and Version 7 OS/390 and z/OS servers. The following Actual Cost information is provided: * CPU time * CPU time in external format * CPU time as an integer in hundredths of a second * Latch/lock contention wait time in external format * Number of getpages in integer format * Number of read i/o in integer format * Number of write i/o in integer format This functionality also allows you to view multiple sets of Actual Cost results for a single SQL statement with different host variable values. Actual Cost information is available in the Development Center from the Create SQL Stored Procedure and Create Java Stored Procedure wizards, within the SQL Statement window for OS/390 and z/OS connections. To use the Actual Cost functionality , click the Actual Cost button in the OS/390 and z/OS connection window in either of the Stored Procedure wizards. You must have the Stored Procedure Monitor Program (DSNWSPM ) installed on your DB2 OS/390 server to use Actual Cost functionality. Federated systems restrictions For users of DB2 for UNIX and Windows Version 7.2 federated databases To successfully create nicknames for DB2 for UNIX and Windows Version 8 tables and views, you must apply the DB2 for UNIX and Windows Version 7.2 Fixpak 8 on your DB2 for UNIX and Windows Version 7.2 federated database. If you do not apply Fixpak 8 on your DB2 for UNIX and Windows Version 7.2 federated database, an error will occur when you access the nicknames. LONG VARCHAR and LONG VARGRAPHIC support The federated documentation indicates that the LONG VARCHAR and LONG VARGRAPHIC data types used by the DB2 family of products are unsupported. This is not entirely accurate. You can create nicknames for DB2 for UNIX and Windows data source objects that contain LONG VARCHAR and LONG VARGRAPHIC data type columns. These remote columns will be mapped to DB2 for UNIX and Windows LOB data types. For the other DB2 family of products, you can create a view that omits or recasts these data types and then create a nickname for the view. WITH HOLD cursors You can use the WITH HOLD semantics on a cursor that is defined on a nickname or in a PASSTHRU session. However, you will receive an error if you try to use the semantics (with a COMMIT) and the data source does not support the WITH HOLD semantics. Unsupported data sources The following data sources are not supported in version 8.1: * Microsoft SQL Server * ODBC * Oracle(R) * Sybase * BLAST * Documentum * Microsoft Excel * table-structured files * XML-tagged files Although these data sources are described in the federated systems documentation, they are not supported at this time. Support for DB2 Server for VM and VSE Federated support for DB2 Server for VM and VSE has been added in this Fixpak. Unsupported products The following products are not supported in version 8.1: * DB2 Relational Connect * DB2 Life Sciences Data Connect Although these products are described in the federated systems documentation, they are not supported at this time. Unsupported operating systems Federated systems are not supported on the Windows ME operating system. Setting up the federated server to access data sources The COMPACT installation option does not install the necessary access to the DB2 family or Informix(TM) data sources. You must use the TYPICAL or CUSTOM installation to access the DB2 family data sources. The CUSTOM installation option is the only option you can use to install access to both the DB2 family and the Informix data sources. Cataloging DB2 family data sources in the federated system database directory When the name of the remote database is more than 8 characters, it is necessary to create a database connection services (DCS) directory entry. An example of cataloging an entry in the DCS directory for the database using the CATALOG DCS DATABASE command is: CATALOG DCS DATABASE SALES400 AS SALES_DB2DB400 where: SALES400 Is the name of the remote database you entered in the CATALOG DATABASE command. AS SALES_DB2DB400 Is the name of the target host database that you want to catalog. High availability function is included in DB2 Universal Database Workgroup Server Edition Though it is not mentioned explicitly in the topic , the high availability function of the DB2 Universal Database Enterprise Server Edition that is referred to in the topic is included in the DB2 Universal Database Workgroup Server Edition. IBM DB2 Development Add-In for Microsoft Visual Studio .NET The IBM DB2 Development Add-In for Microsoft Visual Studio .NET does not support DB2 Universal Database for z/OS and OS/390, Version 8. Installation on Linux When you install version 8.1 of DB2 on Linux, theRPM-based installation attempts to install the IBM Java RPM (IBMJava2-SDK-1.3.1.-2.0.i386.rpm). If a higher level of the RPM (such as IBMJava2-SDK-1.4.0.-2.0.i386.rpm) already exists, then the back-level RPM is not installed. However, in this case, the installation leaves the JDK_PATH database configuration parameter pointing to the Java 1.3 path, /opt/IBMJava2-14/. As a result, none of the Java-dependant functionality, including the installation of the DB2 Tools Catalog, will work. To solve this problem, run the following command as the instance owner: db2 update dbm cfg using JDK_PATH /opt/IBMJava2-14 This will point DB2 to the correct JDK. License Center back-level versions not supported If a version 7 License Center attempts a connection to a version 8 server, the License Center receives an "SQL1650 - Function not supported" error message indicating that the connection is not supported. Microsoft Visual Studio, Visual C++ Despite being mentioned in the DB2 Development Center online help as a possible solution for the Build not successful: -1 error. Microsoft Visual Studio, Visual C++, Version 5.0, is not supported for the development of SQL stored procedures. However, Microsoft Visual Studio, Visual C++, Version 6.0 is supported. . Microsoft XP fix needed on 64-bit operating systems If you are using the Microsoft XP operating system (2600) configured to use the NETBIOS protocol with the DB2 family of products, you need to obtain a hotfix from Microsoft. Contact Microsoft with the Knowledge Base article number Q317437. MVS operating system not supported Despite being mentioned in the documentation, the MVS(TM) operating system is no longer supported by DB2 Universal Database. Support for DB2 XML Extender on a Solaris Operating Environment and on Windows Server 2003 The supported versoins of the Solaris Operating Evironment for use with XML Extender are version 7, version 8 and version 9. XML extender is also supported on Windows Server 2003 (32-bit). Windows XP operating systems The Windows XP Professional operating system is only supported by Personal Edition and Workgroup Server Edition products. The Windows XP Home Edition operating system is only supported by Personal Edition products. Application development Asynchronous execution of CLI Asynchronous execution with CLI is not available. CLI and ODBC on Windows 64-bit operating systems You cannot use an application with mixed ODBC and DB2 CLI on a Windows 64-bit operating system. Configuration Assistant Unsupported bind options The Configuration Assistant does not support the following bind options: * CALL RESOLUTION * CLIPKG * CNULREQD * DBPROTOCOL * ENCODING * MESSAGES * OPTHINT * OS400NAMING * GENERIC * IMMEDIATE * KEEP DYNAMIC * PATH * SORTSEQ * TRANSFORM_GROUP * VALIDATE * VARS Configuration parameters NUM_LOG_SPAN configuration parameter on a multi-partition database The NUM_LOG_SPAN specifies the maximum number of log files that a transaction can span. If at any time a transaction violates the NUM_LOG_SPAN setting, it is rolled back, and forces the application that caused the transaction off the database. However, in a multi-partition system, the db2loggr process can only force an application if the coordinating node for the application and the node of the db2loggr process that detects the error are both the same. For example, you have a system with 3 nodes (0,1 and 2) and have set the NUM_LOG_SPAN parameter to 2 on all nodes. An application connects to node 2 of the database, and begins a long-running transaction, which spans more than 2 log files. If the db2loggr process on node 1 is the first to detect this error, then nothing will happen. However, if the violation also occurs on node 2, then the db2loggr process will notice the error, the transaction will be rolled back and the application will be forced off. DB2 Backup and Restore Backup and restore on Linux 390 operating systems Backup and restore operations to and from multiple tape devices may not work if you are using the Linux 390 operating system. DB2 Data Links Manager Data Links server backup fails using Tivoli Storage Manager archive server (AIX, Solaris Operating Environment) Problem: During the installation of or migration to DB2 Data Links Manager Version 8.1, a Data Links File Manager (DLFM)-initiated backup of Data Links server data to a Tivoli(R) Storage Manager archive server fails. One of the following sets of error messages are shown, either on-screen or on the installation status report: DLFM129I: Automatic backup of DLFM_DB database has been triggered. Please wait for the backup to complete. DLFM901E: A system error occurred. Return code = "-2062". The current command cannot be processed. Refer to the db2diag.log file for additional information. -- or -- DLFM811E: The current DLFM database could not be backed up. SQL code = "-2062", Return code = "-2062" DLFM901E: A system error occurred. Return code = "-2062". The current command cannot be processed. Refer to the db2diag.log file for additional information. Cause: The DB2 Data Links Manager Installer program failed to set the variables required to use Tivoli Storage Manager as an archive (backup) server for a Data Links server machine. Tip: If you want to use Tivoli Storage Manager as an archive server, and you have not yet installed or migrated to DB2 Data Links Manager Version 8.1, you can prevent this problem from occurring. First, do not use the "Tivoli Storage Manager" backup option from the Installer program. Then, manually configure the Data Links Manager Administrator's profile to include the appropriate Tivoli Storage Manager variables, as described in step 2), below. After you have done both of these tasks, you can proceed with the installation or migration. Workaround: Perform the following tasks in the order listed. 1. Back up the DLFM database using this command: db2 backup . * is the name of the DLFM database. By default, the database is called DLFM_DB. * is the directory path to the backup storage location of your choice. 2. Manually configure the Data Links Manager Administrator's profile to include the appropriate Tivoli Storage Manager variables. The manual configuration procedure and the required variables are described in the following documentation topics: * Using Tivoli Storage Manager as an archive server (AIX) * Using Tivoli Storage Manager as an archive server (Solaris Operating Environment) You can find these topics either online in the DB2 Information Center, or in the "System Management Options" chapter of the DB2 Data Links Manager Administration Guide and Reference. * If you are completing a new installation of DB2 Data Links Manager Version 8.1, you are done. * If you are migrating to DB2 Data Links Manager Version 8.1, re-run the Migration Utility program, db2dlmmg. Migrating DB2 when using DataJoiner or replication If you want to migrate an instance of DataJoiner(R) or DB2 for UNIX and Windows on which you are running the Capture or Apply programs for DB2 replication, you must prepare to migrate your replication environment before you migrate the DB2 or DataJoiner instance. Detailed instructions for carrying out the required preparation are included in the migration documentation for DB2 DataPropagator(TM) Version 8. Migration documentation for DB2 DataPropagator Version 8 can be found at http://www.ibm.com/software/data/dpropr/library.html. DB2 Replication Java Administrative API documentation for DB2 Data Replication If you are developing applications using the administrative functions available in DB2 DataPropagator, you can obtain documentation for the relevant administrative Java APIs by contacting IBM support. Column mapping restrictions and the Replication Center You cannot map an expression in a source table to a key column in a target table if the TARGET_KEY_CHG column of the IBMSNAP_SUBS_MEMBR table is "Y" for that target table. This means that when using the Replication Center to create a subscription-set member, you should not select the option Let the Apply program use before-image values to update target-key columns if a key column in the target table is mapped to an expression in the source table. Replication Center restrictions on iSeries systems Administrative tasks in IASPs When using the Replication Center, you cannot perform administrative tasks in IASPs on iSeries(TM) systems. Restrictions for replication steps that use iSeries control, source and target servers The iSeries control, source, and target servers are supported only on the DB2 Universal Database Enterprise Server Edition. For both default and remote agents, the iSeries servers must be cataloged on the local machine. For a remote agent, the iSeries severs must also be cataloged on the machine where the agent resides. If the source or the target servers are on an iSeries operating system, then you must specify the system name on the Database page of the Source or Target notebook. Workaround for the replication asnscrt command (Windows only) You will receive an error if you run the asnscrt command according to the syntax diagram in the main documentation. To use the asnscrt command, specify the Windows service name for the DB2 instance instead of the DB2 instance name: Syntax: >>-asnscrt--+--C-+--db2_service--account--password--------------> +--A-+ '--M-' >--+-asncap_command---+---------------------------------------->< +-asnapply_command-+ '-asnmon_command---' Where db2_service is the Windows service name for the DB2 instance. For example, to create a Windows service that invokes a Capture program for the Windows service called db2-0: asnscrt -C db2-0 .\joesmith password asncap capture_server=sampledb capture_schema=ASN capture_path=X:\logfiles Data Warehouse Center ERwin 4.x metadata bridge ERwin 4.0 metadata cannot be imported on the Linux operating system. The ERwin 4.x bridge is supported on Windows 98 and WinME with the following restrictions: * The db2erwinimport command can only be run from the db2 command line processor. * You must fully qualify the XML and trace file names for the -x and -t parameters. Japanese names of remote objects Schema, table, and column names of remote sources in Japanese cannot contain certain characters. Unicode mapping differences may cause the names to be null. See http://www.ingrid.org/java/i18n/encoding/ja-conv.html for more information. Restrictions for the Clean Data transformer Linking restrictions You cannot link any OS/390 data resources such as tables or views with a new Clean Data step. You can still link OS/390 data resources with the deprecated programs Clean Data step. Parameter restrictions For the Find and Replace parameter: If your new Clean Data transformer rules table contains different data types for the Find and Replace columns, you must change the Target column data type in both the Target Table properties page and the Column Mapping page before you promote the transformer to test mode. For the Discretize parameter: If your new Clean Data rules table contains different data types for the Bounds and Replace columns, you must change the Target column data type in both the Target Table properties page and the Column Mapping page before you promote the transformer to test mode. iSeries platform restrictions On the iSeries platform, the new Clean Data transformer does not perform error processing. You can generate the All Matches match type only on the iSeries platform. Using the warehouse agent for replication and accessing Client Connect warehouse sources Using the warehouse agent for replication If the source, target, capture control, or apply control servers (databases) are remote to the client system, you must catalog the database with the same name, user ID, and password on both the client and the warehouse agent systems. After you catalog the source on the client and warehouse agent systems, verify that you can connect to the source, target, capture, and apply databases. If you cannot connect to the warehouse source, warehouse target, replication capture, or replication apply databases, verify that the environment variable DB2COMM on the remote system is set to TCP/IP, and that the port number matches the port number of the node that is cataloged on the client system. To verify the port number on the remote system, type the following command at a DB2 command prompt: get dbm cfg | grep SVCENAME You specify the port number of the client system when you catalog the node. Accessing Client Connect warehouse sources using the warehouse agent When you access a warehouse source that was defined using Client Connect with a warehouse agent, the source must be cataloged with the same name, user ID, and password on both the client and warehouse agent systems. If you are using the ODBC version of the warehouse agent, you must also catalog the source as an ODBC source on both the warehouse agent and client sites. Otherwise, actions that require the warehouse agent to access the warehouse source will fail. Scheduling a warehouse process to run at intervals When scheduling a warehouse process to run at intervals, you must determine the longest time it takes to run all the production steps in the process and schedule the intervals accordingly. If a process exceeds the scheduled time interval, all subsequently scheduled occurrences of that process will not run and will not be rescheduled. Documentation DB2 Replication Guide and Reference documentation The solutions information at http://www.ibm.com/software/data/dbtools/datarepl.htm, referred to in the preface to the Replication Guide and Reference, is no longer available. DB2 Version 8 HTML documentation installation restriction (Windows) On Windows, do not install the DB2 Version 8 HTML documentation on a workstation or server where a DB2 Version 7 (or earlier) product is already installed. The installer detects the earlier version and removes the earlier product. A workaround does exist. If you need to install the DB2 Version 8 HTML documentation on a machine where an older version of DB2 is installed, you can manually copy the files and directories from the DB2 Version 8 HTML Documentation CD, rather than using the installer. The DB2 Information Center and full text search will work, but you will not be able to apply any HTML documentation FixPaks. Documentation search may fail on AIX unless all documentation categories are installed If you do not to install all of the categories of documentation on the DB2 HTML Documentation CD-ROM, an attempt to search against "All topics" may fail with an InvalidParameterException reported in the Java console of your browser and no search results. To workaround the problem do one of the following: * narrow the scope of your search by selecting from the Search scope list box in the Search window, * install all the documentation categories from the DB2 HTML Documentation CD-ROM. Documentation search problem with Java 2 JRE1.4.0 If your browser uses Java 2 JRE v1.4.0 and your documentation is installed in a path that contains spaces (e.g., C:\Program Files\SQLLIB\doc\), the documentation search applet may fail with an InvalidParameterException reported in the Java console of your browser and no search results. This problems is fixed with JRE v1.4.1. To workaround the problem, do one of the following: * upgrade your browser's JRE version to 1.4.1, available at http://java.sun.com/j2se/1.4.1/download.html * downgrade your browser's JRE version to 1.3.x, available at http://www-3.ibm.com/software/data/db2/udb/ad/v8/java/ Installation of the DB2 Information Center for languages that are not options during installation The DB2 Setup wizard can only install the DB2 HTML documentation for languages that it also installs the DB2 product for. As a result, the DB2 HTML documentation cannot be installed using the DB2 Setup wizard in the following languages: * Hebrew * Greek (restriction for UNIX only) * Portuguese (restriction for UNIX only) To install the Information Center in one of these languages: 1. Insert the DB2 HTML Documentation CD in your CD-ROM drive. 2. Copy the following directory to your computer: * For Windows operating systems: d:\lang\ where d: is your CD-ROM drive and lang is the code for the language you want to use. * For UNIX operating systems /cdrom/language/ where cdrom is where you have mounted the CD and language is the code for the language you want to use. It does not matter where you place the folder. You can also view the DB2 HTML documentation directly from the CD. For instructions on how to do so, see the "Viewing technical information online directly from the DB2 HTML Documentation CD" topic in your Quick Beginnings manual. Notes: 1. To view the documentation, you must use Microsoft Internet Explorer 5.0 or later, or Netscape 6.1 browsers or later. 2. As well, if you launch the documentation from your product, it will go to the documentation installed as part of your product install, and not the documentation that you copied over manually. Official naming convention for DB2 for Linux when used on host systems The official naming convention for DB2 for Linux on host systems is DB2 on Linux for S/390(R) and zSeries(TM). S/390 refers to 32-bit and zSeries to 64-bit. In addition, it is important to note that the following terms are also obsolete: * 64-bit Linux/390 * Linux/SGI GUI tools Control Center plugin support The Control Center now supports custom folders. Custom folders can contain user-selected system or database objects. Creating Control Center plugins specifically for a custom Ffolder is not supported, but plugins can be created for the object contained in Custom Folders. See Introducing the plug-in architecture for the Control Center for more information about Control Center Plugins. Displaying Indic characters in the DB2 GUI tools If you have problems displaying Indic characters when using the DB2 GUI tools, you might not have the required fonts installed on your system. DB2 Universal Database has packaged the following IBM TrueType and OpenType proportional Indic language fonts for your use. They are located in the fonts directory of the IBM Developer Kit, Java Technology Edition, Version 1.3.1 for AIX operating systems on 64-bit systems CD. These fonts are to be used only in conjunction with DB2. You cannot engage in the general or unrestricted sale or distribution of these fonts: Table 1. Indic fonts packaged with DB2 Universal Database +-----------------------+----------------------+----------------------+ | Typeface | Weight | Font File Name | +-----------------------+----------------------+----------------------+ | Devanagari MT for IBM | Medium | devamt.ttf | +-----------------------+----------------------+----------------------+ | Devanagari MT for IBM | Bold | devamtb.ttf | +-----------------------+----------------------+----------------------+ | Tamil | Medium | TamilMT.ttf | +-----------------------+----------------------+----------------------+ | Tamil | Bold | TamilMTB.ttf | +-----------------------+----------------------+----------------------+ | Telugu | Medium | TeluguMT.ttf | +-----------------------+----------------------+----------------------+ | Telugu | Bold | TeleguMTB.ttf | +-----------------------+----------------------+----------------------+ Detailed instructions on how to install the fonts and modify the font.properties file can be found in the Internationalization section of the IBM development kit for Java documentation. In addition, the following Microsoft products also come with Indic fonts that can be used with our GUI tools: * Microsoft Windows 2000 operating system * Microsoft Windows XP operating system * Microsoft Publisher * Microsoft Office GUI tools not supported for zSeries servers running Linux operating systems With the exception of the DB2 Setup wizard, GUI tools will not work on zSeries servers running the Linux operating system. This limitation includes any items normally launched form the Install launchpad, such as the Quick Tour. If you want to use the GUI tools with one of these systems, install the administrative tools on a client system with a different system configuration, and use this client to connect to your zSeries server. Load and Import Columns page does not support DBCS characters in IXF files If you use the Load wizard or Import notebook to set up a load or import from an IXF input file containing DBCS characters, the Columns page will not correctly display the column names contained in the file. Incorrect indicators given when a load operation fails If a load fails, but only warnings were returned (not errors), then the task icon will still appear with a green checkmark in the Task Center. Be sure to double-check the success of any loads you carry out. Minimum display settings for GUI tools For the GUI tools such as the Control Center to work properly, you must have a screen resolution of at least 800 by 600 dpi, and be using a display palette of at least 32 colors. SQL1224N error when using the GUI tools on AIX If you are using the GUI tools on an AIX operating system, you may receive an SQL1224N error. This error is caused by a memory handling problem in DB2. The following workaround will help eliminate the error: Procedure To stop the SQL1224N error on AIX operating systems: 1. As the instance owner, run the following commands: export EXTSHM=ON db2set DB2ENVLIST=EXTSHM 2. Restart the instance with the following commands: db2stop db2start Once the instance restarts with the new environment variable settings, the SQL1224N errors should stop. Health Monitor Health Monitor off by default The default value for the database manager switch for the health monitor (HEALTH_MON) is OFF. Health indicator restrictions The health monitor is unable to execute actions for the db2.db2_op_status health indicator if the indicator enters the down state. This state can be caused, for example, when an instance that the indicator is monitoring becomes inactive because of an explicit stop request or an abnormal termination. If you want to have the instance restart automatically after any abnormal termination, you must configure the fault monitor to keep the instance "highly available". dasdrop limitation in multiple FixPak environments Alternate FixPaks install their own version of the dasdrop command. On AIX, it is installed in the /usr/opt/db2_08_FPn/ path. On other UNIX systems, it is installed in the /opt/IBM/db2/V8.FPn/ path. In both cases, n is the number of the FixPak. In a multiple FixPak Environment, you can only have one DAS set up at any one time. You can create the DAS against version 8.1 of the product, or against any of the Alternate FixPaks. To drop a DAS that was created against version 8.1 of the product, you can use any version of dasdrop to drop it. However, to drop a DAS that was created against an Alternate FixPak, you must use an Alternate FixPak version of dasdrop. For example, consider the following scenario on the AIX operating system: * You install DB2 Version 8.1. * You install Alternate FixPak 1 installed. * You create a DAS using the version 8.1 code, with the following command: /usr/opt/db2_08_01/instance/dascrt dasusr1 * You want to drop the DAS. You can drop this DAS by using either of the following commands: /usr/opt/db2_08_01/instance/dasdrop /usr/opt/db2_08_FP1/instance/dasdrop Both will work properly. However, in this example: * You install DB2 Version 8.1. * You install the Alternate FixPak 1. * You create a DAS using the Alternate FixPak 1 code, with the following command: /usr/opt/db2_08_FP1/instance/dascrt dasusr1 * You want to drop this DAS You must use the Alternate FixPak 1 dasdrop command: /usr/opt/db2_08_FP1/instance/dasdrop Trying to use the version 8.1 dasdrop command will cause an error. This limitation only applied to version 8.1 of the product, and not to any of the regular FixPaks. For example: * You install DB2 Version 8.1. * You apply regular FixPak 1, which corrects the problem with the version 8.1 dasdrop. * You install the Alternate FixPak 1. * You create a DAS using the Alternate FixPak 1 code, with the following command: /usr/opt/db2_08_FP1/instance/dascrt dasusr1 * You want to drop this DAS You can drop this DAS by using either of the following commands: /usr/opt/db2_08_01/instance/dasdrop /usr/opt/db2_08_FP1/instance/dasdrop Both will work properly because the version of dasdrop in the /usr/opt/db2_08_01/ path was corrected when you applied the regular FixPak. Information Catalog Center tables Do not partition information catalog tables Tables that the Information Catalog Manager uses must be contained within a single database partition. Numerous methods are available to put the tables within a single partition. The following procedure is one approach that works. 1. Open a DB2 Command Line Processor and issue these commands: a. CREATE DATABASE PARTITION GROUP pgname ON DBPARTITIONNUM pnumber b. CREATE REGULAR TABLESPACE tsname IN DATABASE PARTITION GROUP pgname MANAGED BY SYSTEM USING ('cname') Click Start --> Programs --> IBM DB2 --> Set-up Tools --> Manage Information Catalog Wizard. On the Options page, specify the table space name in the Table space field. Secure Windows environments You may experience file permission problems if you are using DB2 on Windows and are not an administrator on the Windows system. If you receive a SQL1035N, SQL1652N, or SQL5005C error message, possible causes and workarounds are as follows: User does not have sufficient authority on the sqllib directory Problem Received an SQL1035N or SQL1652N error when trying to open DB2 CLP or command window. The DB2 code (core files) are installed into a directory structure where write privileges are limited, but some DB2 tools need to write and create files in the DB2INSTPROF directory. Workaround Create a new directory where you can grant users, at minimum, the MODIFY permission and use either db2set -g db2tempdir to point to the new directory, or set the db2tempdir variable in the Windows system environment. User does not have sufficient authority to write to the sqllib\ directory even though user belongs to SYSADM_GROUP Problem Received an SQL5005C system error when trying to update the database manager configuration file (update dbm cfg). The user does not have the required NTFS permissions to write to the sqllib\instance_dir directory even though you have added this user to the SYSADM_GROUP. First workaround Grant the users, at minimum, the MODIFY permission on the instance_dir directory at the file system level. Second workaround Create a new directory where you can grant the user, at minimum, the MODIFY permission. Use the db2set db2instprof to point to the new directory. You will either need to recreate the instance so that the information is stored under the new instance directory specified by db2instprof, or you will need to move the old instance directory to the new directory. SQL Assist SQL Assist button disabled in the Command Center In the Command Center, the SQL Assist button only becomes enabled once a connection has been established. Two versions of SQL Assist are launched from DB2 You can invoke both version 7 and version 8 of SQL Assist from within DB2 Version 8.1. You can launch version 7 from the DB2 Data Warehouse Center. All other centers launch the latest version 8. The product online help has additional information for SQL assist version 7. Throttled utility restrictions The simultaneous execution of multiple throttled utilities is not supported. For example: * If you are running three online backups, only one can be throttled. The other two must have a priority of 0. * You can invoke a rebalance and backup at the same time but either the rebalance or backup must have a priority of 0. If you invoke multiple throttled utilities at the same time, it can cause the utilities to run for excessively long periods of time. It can also cause the system impact to be more severe than the limit set by the impact policy (UTIL_IMPACT_LIM). XML Extender Renaming of xml extender sample programs Conflicts between the system operations and XML Extender can cause some XML Extender sample programs to seriously damage your files. The following list shows the conflicting XML Extender sample programs as well as new replacement programs that are less likely to cause conflicts. Make sure to use the new sample programs in place of the old ones. Replacement sample programs for XML Extender (Windows) +----------------------------------+----------------------------------+ | Old Program (Do not use) | New Program (Use) | +----------------------------------+----------------------------------+ | insertx.exe | dxxisrt.exe | +----------------------------------+----------------------------------+ | retrieve.exe | dxxretr.exe | +----------------------------------+----------------------------------+ | retrieve2.exe | dxxretr2.exe | +----------------------------------+----------------------------------+ | retrievec.exe | dxxretrc.exe | +----------------------------------+----------------------------------+ | shred.exe | dxxshrd.exe | +----------------------------------+----------------------------------+ | tests2x.exe | dxxgenx.exe | +----------------------------------+----------------------------------+ | tests2xb.exe | dxxgenxb.exe | +----------------------------------+----------------------------------+ | tests2xc.exe | dxxgenxc.exe | +----------------------------------+----------------------------------+ Replacement sample programs for XML Extender (UNIX) +----------------------------------+----------------------------------+ | Old Program (Do not use) | Old Program (Use) | +----------------------------------+----------------------------------+ | insertc | dxxisrt | +----------------------------------+----------------------------------+ | retrieve | dxxretr | +----------------------------------+----------------------------------+ | retrieve2 | dxxretr2 | +----------------------------------+----------------------------------+ | retrievec | dxxretrc | +----------------------------------+----------------------------------+ | shred | dxxshrd | +----------------------------------+----------------------------------+ | tests2x | dxxgenx | +----------------------------------+----------------------------------+ | tests2xb | dxxgenxb | +----------------------------------+----------------------------------+ | tests2xc | dxxgencx | +----------------------------------+----------------------------------+ Using the new sample progams with the sample sqx files Samples of some of these sample programs are included with the product. If you create new executable files from these samples, you must copy the new files from the \SQLLIB\samples\db2xml\c\ directory into the \SQLLIB\bin\ directory, and then make an additional copy, renaming them according to the table above. XML Extender on a partitioned database environment. XSLT user defined functions are not supported in a partitioned database environment. When working with XML in a partitioned database environment the data is split across multiple physical nodes. The data distribution in this case is not predictable. When working in this kind of environment, you should ensure the following: * Use the XMLVARCHAR or XMLCLOB data types instead of XMLFile in your UDFs. * When using the UNIX or Windows operating systems, store your XML files on a file server, and mount or map that server to each machine so that the file has the same path regardless of what machine accesses it. * Create a response file when you install DB2 on the instance owning computer. Use this response file for the rest of your installations. This ensures that the same components are installed and configured the same way on each machine. * Use the -r option to specify the root id in the enable_column command, so that a consistent partitioning key is used for all the table data. Additional Information Change in Unicode server behavior In version 7, Unicode servers ignored any graphic codepages by applications at connect time and assumed that UCS2 Unicode (codepage 1200) was being used. Version 8 Unicode servers now respect the codepage sent by the client. Full message text is not returned when using SQLException.getMessage() By default, the DB2BaseDataSource.retrieveMessagesFromServerOnGetMessage property is disabled. If you enable this property, all calls to the standard JDBC SQLException.getMessage() invoke a server-side stored procedure, which retrieves the readable message text for the error. By default, the full message text is not returned to the client when a server-side error occurs. You can use the proprietary method DB2Sqlca.getMessage() to retrieve the fully formatted message text. A call to the SQLException.getMessage() method will start a unit of work only if retrieveMessagesFromServerOnGetMessage is enabled. A call to the DB2Sqlca.getMessage() method results in a stored procedure call, which starts a unit of work. Prior to FixPak 1, the DB2Sqlca.getMessage() method may throw an exception. IBM DB2 universal JDBC driver The IBM DB2 Universal JDBC Driver cannot connect to databases that were created using the HP default character set, roman8. All SQLJ and JDBC applications that use the universal JDBC driver, must connect to a database created with a different character set. If your LANG is set to "C" or to a "roman8" locale, you must change it to the corresponding ISO locale. For instance, if your LANG is set to de_DE.roman8, it must be changed to de_DE.iso88591: export LANG=de_DE.iso88591 To run the DB2 SQLJ and JDBC sample programs with the universal JDBC driver, you can create the sample database with the following commands (in this case, using the ISO locale for US English): export LANG=en_US.iso88591 db2 terminate db2sampl Note that if the sample database already exists, you must drop it before executing these commands. Java functions and routines on UNIX and Windows operating systems Due to limitations in the JVM, a Java routine defined as NOT FENCED will be invoked as if it had been defined as FENCED THREADSAFE. Java UDFs or methods defined with NO SQL, and with the parameter styles GENERAL or GENERAL WITH NULLS will not function if defined with LOB locators in the parameter definition. You must modify these functions to use LOB parameters instead of LOB LOCATORS. English Microsoft Data Access Components (MDAC) files are used for all national language versions of DB2 V8.1 unless translated MDAC files are installed first. If you do not install the national language version of MDAC 2.7 prior to installing the national language version of DB2, then DB2 installs English MDAC files by default. This causes the Windows ODBC Data Source Administrator panels to appear untranslated if your operating system is non-English. To fix this problem, you can install the "MDAC 2.7 RTM - Refresh" bundle from the Microsoft website at http://www.microsoft.com/data/download_270RTM.htm. Choose the language that you want to install, download the required executable, and run it. This will install the translated ODBC Data Source Administrator files. The Simplified Chinese locale on AIX operating systems AIX has changed the codeset bound to the Simplified Chinese locale Zh_CN on * AIX version 5.1.0000.0011 or higher * AIX version 5.1.0 with maintenance level 2 or later from GBK (code page 1386) to GB18030 (code page 5488). Since DB2 UDB for AIX supports the GBK and not the GB18030 codeset, DB2 will default the Zh_CN locale's codeset to ISO 8859-1 (code page 819), and in some operations will also default the locale's territory to the United States (US). To work around this limitation, you have two options: * You can override the locale's codeset from GB18030 to GBK and the territory from US to China (whose territory ID is CN and territory code is 86). * You can use a different Simplified Chinese locale. If you choose to use the first option, issue the following statements: db2set DB2CODEPAGE=1386 db2set DB2TERRITORY=86 db2 terminate db2stop db2start If you choose to use the second option, change your locale from Zh_CN to either ZH_CN or zh_CN. The ZH_CN locale's codeset is Unicode (UTF-8), while the zh_CN locale's codeset is eucCN (code page 1383). Online help corrections and updates Configuring the C environment for SQL stored procedures in the Development Center If you are working with DB2(R) for Windows(R) on the server and you are using the Visual C++ compiler, you must configure your SQL build settings. You will be not be able to build SQL stored procedures until you configure your SQL Build options. Use the Database Connection Properties notebook in the Development Center to configure your SQL build settings. To configure the C compiler environment for SQL stored procedures: 1. On the SQL Build Settings page of the notebook, specify a compiler environment that you want to use for building SQL objects. * Click Refresh. * In the Compiler environment field, type the location of the VC98\BIN\VCVARS32.BAT file on your Windows server. 2. Click OK to close the notebook and save your changes. If you click Apply, the changes are saved and you can continue changing the properties. Enabling view docking when accessing Development Center with Hummingbird Exceed When accessing the Development Center on UNIX with Hummingbird Exceed, the XTEST extension version 2.2 must be enabled before you can move and dock views by dragging their title bars within the Development Center. To enable the XTEST extension: 1. From the Start menu, select Programs -> Hummingbird Connectivity 7.0 ->Exceed->XConfig. The XConfig window will open. 2. Optional: If your configuration requires a password, enter the XConfig password. 3. Double click the Protocol icon. The Protocol window will open. 4. Check the X Conformance Test Compatibility checkbox. 5. In the Protocol window, click the Extensions... button. The Protocol Extensions window will open. 6. In the Enable Extensions list, select the XTEST(X11R6) checkbox. 7. Click OK. Microsoft Visual Studio .NET add-in information update in Development Center help The "About the Development Center" help topic does not include information about the new Microsoft Visual Studio .NET add-in in the list of development environment add-ins provided. The following information describes the .NET add-in that supports Development Center functionality in the Microsoft Visual Studio .NET development environment: DB2 Development Add-In for the Microsoft Visual Studio .NET development environment A new component of the DB2 Application Development Client is the IBM DB2 Development Add-In for Microsoft Visual Studio .NET for the .NET framework version 1.0. This add-in extends the Visual Studio .NET IDE to provide tightly integrated DB2 application development support using the DB2 .NET Managed Provider as well as DB2 server-side development support. Using this add-in available in Microsoft Visual Studio .NET you can: * Develop DB2 specific database projects from the new IBM Projects folder with advanced script generation wizards. * Explore the DB2 catalogue information using DB2 data connections in the new IBM Explorer. * Make use of the extended intelligence features for DB2 table/view columns and procedure/function parameters. * Generate ADO.NET code for your windows forms using drag and drop. * Configure your DB2 Managed Provider objects using properties custom editors and wizards. * Launch various DB2 development and administration centers. * View add-in help from the existing dynamic help window. The DB2 Development Add-In for Microsoft Visual Studio .NET database connections are managed using the DB2 .NET managed provider and ADO.NET. Migrating DB2 XML Extender to Version 8.1.2 If you are migrating from a Version 7 FixPak, refer to each of the release notes for the Version 7 FixPack for more information on what changes are included when upgrading to Version 8.1.2. Each new FixPak contains all of the previous FixPaks' updates. To migrate DB2 XML Extender from previous versions to Version 8.1.2, complete the following steps. 1. From the DB2 command line, enter: db2 connect to database_name db2 bind dxxinstall\@dxxMigv.lst where dxxinstall is the directory path in which you installed DB2. 2. From the DB2 command line, enter: dxxMigv database_name Path settings to enable Java routines to compile in the Development Center The Development Center cannot compile Java(TM) routines unless it knows where your developer kit versions are installed. Default locations for these will be written to your $HOME/IBM/DB2DC/DB2DC.settings file when the Development Center starts for the first time. You may copy these into your $USER.settings file and modify them with a Unicode editor, or you may create symbolic links to your developer kit directories in the default locations. Runstats dialog - updated getting there information To open the Runstats notebook: 1. From the Control Center, expand the object tree until you find the Tables folder. 2. Click the Tables folder. Any existing tables are displayed in the contents pane. 3. Right-click all the tables that you want to run statistics on, and select Run Statistics from the pop-up menu. The Runstats notebook opens. Spatial Extender - requirements when using the Index Advisor The ANALYZE clause requires use of a user temporary table space. If the ANALYZE clause is needed, then you must have the USE privilege for the table space in order to use the index advisor. Specifying build options for a Java stored procedure in the Development Center Use the Stored Procedure Properties notebook to specify the compile options that will be used when building a Java stored procedure. These steps are part of the larger task of changing stored procedure properties. To specify the build options of a stored procedure: 1. On the Build page of the Stored Procedure Properties notebook, specify the compile options for building the stored procedure. See your compiler documentation for information about available options. a. In the Precompile options field, type the DB2 precompiler options that you want to use when building stored procedures. The package name must not exceed 7 characters. b. In the Compile options field, type the compiler options that you want to use when building stored procedures. 2. Click OK to close the notebook and save your changes. If you click Apply, the changes are saved and you can continue changing the properties. Appendix. Notices IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country/region or send inquiries, in writing, to: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan The following paragraph does not apply to the United Kingdom or any other country/region where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions; therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product, and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information that has been exchanged, should contact: IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA Such information may be available, subject to appropriate terms and conditions, including in some cases payment of a fee. The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us. Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems, and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements, or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility, or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. This information may contain examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious, and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information may contain sample application programs, in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM for the purposes of developing, using, marketing, or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows: (C) (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_. All rights reserved. Trademarks The following terms are trademarks of International Business Machines Corporation in the United States, other countries, or both, and have been used in at least one of the documents in the DB2 UDB documentation library. +----------------------------------+----------------------------------+ | ACF/VTAM | LAN Distance | | AISPO | MVS | | AIX | MVS/ESA | | AIXwindows | MVS/XA | | AnyNet | Net.Data | | APPN | NetView | | AS/400 | OS/390 | | BookManager | OS/400 | | C Set++ | PowerPC | | C/370 | pSeries | | CICS | QBIC | | Database 2 | QMF | | DataHub | RACF | | DataJoiner | RISC System/6000 | | DataPropagator | RS/6000 | | DataRefresher | S/370 | | DB2 | SP | | DB2 Connect | SQL/400 | | DB2 Extenders | SQL/DS | | DB2 OLAP Server | System/370 | | DB2 Query Patroller | System/390 | | DB2 Universal Database | SystemView | | Distributed Relational | Tivoli | | Database Architecture | VisualAge | | DRDA | VM/ESA | | eServer | VSE/ESA | | Extended Services | VTAM | | FFST | WebExplorer | | First Failure Support Technology | WebSphere | | IBM | WIN-OS/2 | | IMS | z/OS | | IMS/ESA | zSeries | | iSeries | | +----------------------------------+----------------------------------+ The following terms are trademarks or registered trademarks of other companies and have been used in at least one of the documents in the DB2 UDB documentation library: Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Intel and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Other company, product, or service names may be trademarks or service marks of others.