IBM(R) DB2(R) Data Archive Expert, Version 2 Release 1, Fix Pack 2 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 ENHANCEMENTS 1.2 CORRECTED KNOWN PROBLEMS 2.0 PREREQUISITES 2.1 Hardware requirements 2.2 Software requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Migrating existing DB2 Data Archive Expert databases to Fix Pack 2 3.2 Configuring databases to work with DB2 Data Archive Expert 4.0 CUSTOMIZATION INSTRUCTIONS 5.0 CORRECTIONS TO DOCUMENTATION 6.0 HOW TO GET HELP 7.0 KNOWN PROBLEMS, RESTRICTIONS, AND WORKAROUNDS 8.0 NOTICES 8.1 Use of Evaluation Program 8.2 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Data Archive Expert, Version 2 Release 1, Fix Pack 2 README file. This README file contains information about installing IBM DB2 Data Archive Expert. IBM DB2 Data Archive Expert has been tested and validated with DB2 Universal Database(TM) Version 8 Fix Pack 9. Subsequent releases might require additional maintenance. 1.1 ENHANCEMENTS - Added Tivoli Storage Manager (TSM) support. With Fix Pack 2, you can archive to any storage device that TSM supports, such as an IBM DR550. For additional information and installation instructions, see the DB2 Data Archive Expert User's Guide - Added support for executing stored procedures. With Fix Pack 2, you can execute archive and retrieve specifications through a Java callable interface for stored procedures. For additional information, see the DB2 Data Archive Expert User's Guide. - Includes the Node Directory Tool. The DB2 Data Archive Expert User Interface requires you to enter database location information used to connect to the DB2 databases. If you have already cataloged databases on client systems you can use this tool to extract some of the connection information from the DB2 Node directory on those client systems and import it into DB2 Data Archive Expert. You can find information about how to install and use the Node Directory Tool in the Reference section of the User's Guide. 1.2 CORRECTED KNOWN PROBLEMS The following problems are corrected by this fix pack: - Added support for column names with the "_" character in remote archives. - Added support for LOB objects in file archives. - Improved performance in the delete process. - Improved the DB2 Data Archive Expert Integrated Solutions Console (ISC) component installation. With DB2 Data Archive Expert Version 2.1.0 or Fix Pack 1, the installation required you to copy 4 JCC driver files and restart the ISC server. With Fix Pack 2 (Version 2.1.2), the InstallShield for the DB2 Data Archive Expert ISC component automatically restores 4 JCC files to the newly deployed Data Archive Expert client environment, restarts the ISC server, and makes the DB2 Data Archive Expert ISC component available for you to use after installation. - Corrected the schema names for remote archive packages. When you configure a database with the DB2 Data Archive Expert database server GA driver, the configuration creates a remote archive package with a schema name that does not contain the product prefix AHX. With this fix pack, the problem is corrected. If you already have a database configured with the GA driver, you must complete the following steps: On Windows systems: 1. For each database, drop the package "HALLER.DAEXLOAD" and the schema "HALLER" by issuing the DB2 commands, "drop package" and "drop schema". 2. Install the DB2 Data Archive Expert database server Fix Pack 2 driver. 3. Connect to the database and issue the "DB2 BIND daexload.bnd" command from the server installation directory. On AIX systems: 1. For each database, drop the package "SHUWANG8.DAEXLOAD" and the schema "SHUWANG8" by issuing the DB2 commands, "drop package" and "drop schema". 2. Install the DB2 Data Archive Expert database server Fix Pack 2 driver. 3. Connect to the database and issue the "DB2 BIND DAEXLOAD.bnd" command from the server installation directory. On other UNIX systems: 1. For each database, drop the package "DREHER8.DAEXLOAD" and the schema "DREHER8" by issuing the DB2 commands, "drop package" and "drop schema". 2. Install the DB2 Data Archive Expert database server Fix Pack 2 driver. 3. Connect to the database and issue the "DB2 BIND DAEXLOAD.bnd" command from the server install directory. 2.0 PREREQUISITES DB2 Data Archive Expert has hardware and software requirements. 2.1 Hardware requirements DB2 Data Archive Expert has the following hardware requirements: - Memory and disk space sufficient to fulfill DB2 minimum requirements. - Approximately 25 MB of free disk space on any supported platform. - Additional space for user data (varies depending on the size of your databases and the amount of activity your system encounters). The DB2 Data Archive Expert database server requires the following amount of disk space for the installation: UNIX and Linux Systems - 20 MB for the system TEMP directory Windows Systems - 100 MB for the system TEMP directory The DB2 Data Archive Expert ISC component requires the following amount of disk space for the installation: UNIX and Linux Systems - 30 MB for the system TEMP directory Windows Systems - 100 MB for the system TEMP directory 2.2 Software requirements DB2 Data Archive Expert requires: - JVM (JRE) 1.3.1 or higher for all source or target servers - DB2 UDB Version 8.0 on Linux, UNIX, and Windows with Fix Pack 9 or higher for sources and targets of remote archives. DB2 Version 8.0 Fix Pack 9 is required for archiving to local tables. - Remote archiving is not supported for Linux, UNIX, and Windows Unicode databases. - If you are archiving to a TSM enabled storage device, you need the Tivoli Storage Manager Version 5.3 server and the Version 5.3 client API. You need to install the client API on the DB server system. - IBM JDBC driver: If you want to use DB2 Data Archive Expert with a database server, you must install the DB2 UDB Administration Client. The DB2 UDB Administration Client is a stand alone UDB installation package that contains the JDBC drivers, the Configuration Assistant, and other DB2 UDB for Multiplatforms components. The DB2 Data Archive Expert Integrated Solutions Console (ISC) component has been tested on the following operating systems: AIX 5.2, 5.3 with the 5300-01 Recommended Maintenance Package Windows 2000 32 bit Linux for xSeries 32 bit Solaris 8 32 bit The DB2 Data Archive Expert database server has been tested on the following operating systems: AIX 5.1, 5.2, 5.3 64 bit Windows 2000, XP, 2003 32 bit Solaris 8 and 9 32 bit and 64 bit Linux RHEL 3 for xSeries 32 bit Linux RHEL 3 for pSeries and zSeries 64 bit Linux SuSE 8 for xSeries 32 bit Linux SuSE 8 for pSeries and zSeries 64 bit 3.0 INSTALLATION INSTRUCTIONS The installation program detects whether DB2 Data Archive Expert is installed. If the installation program cannot find DB2 Data Archive Expert Version 2.1.0 or Fix Pack 1 installed, the installation program issues a message and exits. If the installation program finds DB2 Data Archive Expert Version 2.1.0 or Fix Pack 1 installed, the installation program installs Fix Pack 2 in the directory that contains your current DB2 Data Archive Expert files. This is true for both the DB2 Data Archive Expert ISC component and database server installation programs on all platforms with the exception of the ISC component behavior on Solaris systems. For Solaris systems, you must know the directory where DB2 Data Archive Expert is installed before installing Fix Pack 2. To install DB2 Data Archive Expert Fix Pack 2, complete the following steps: 1. Ensure that the ISC server is running. If the ISC server is not running, start the ISC server with the ISC_installation_directory\PortalServer\bin\startISC.bat command for Windows systems or the ISC_installation_directory/PortalServer/bin/startISC.sh command for UNIX and Linux systems. If the ISC server is not running, the DB2 Data Archive Expert ISC component installation will fail with error code 4. 2. Start the DB2 Data Archive Expert ISC component installation program by running the following platform-specific setup files: AIX: setupDAEClientAix Windows 32 bit: setupDAEClientWin32.exe Linux for xSeries 32-bit: setupDAEClientLinux Solaris: setupDAEClientSolaris For Solaris systems only: When you install Fix Pack 2 through GUI mode, a dialog box after the welcome panel reminds you to install Fix Pack 2 to the same location where you installed DB2 Data Archive Expert. Select "Yes" to continue if you remember where you installed DB2 Data Archive Expert. Select "No" to exit the installation program and check where you originally installed DB2 Data Archive Expert. Once you find the directory information, return to install Fix Pack 2. If you use the console mode, it is assumed that you know the directory where you originally installed DB2 Data Archive Expert. Fix Pack 2 will create a separate uninstallation program under the install directory. If you want to uninstall DB2 Data Archive Expert, you should uninstall Fix Pack 2 first (for example, under the daeiscuninst2 directory), then uninstall DB2 Data Archive Expert (for example, under the daeiscuninst directory). Note: When you attempt to uninstall DB2 Data Archive Expert, you might get a return code of 200. The uninstallation program is trying to remove the DB2 Data Archive Expert client from the ISC. You can ignore this error because the DB2 Data Archive Expert client was already removed when you uninstalled Fix Pack 2. 3. Start the DB2 Data Archive Expert database server installation program by running on of the following platform-specific setup files: Note: You must ensure that a JRE is defined in your PATH before running the installation program for the DB2 Data Archive Expert database server. Before you run the set up file, ensure that you have a valid DB2 environment where you can run the "db2level" command. AIX: setupDAEServerAix Windows 32 bit: setupDAEServerWin32.exe Solaris: setupDAEServerSolaris Linux for pSeries 64 bit: setupDAEServerPlnx Linux for zSeries 64 bit: setupDAEServerZlnx Linux for xSeries 32 bit: setupDAEServerXlnx 4. For all source databases that have been configured to be used with DB2 Data Archive Expert Version 2.1.0 or Fix Pack 1, issue the following SQL statements to refresh the stored procedures: CONNECT TO USER USING CALL SQLJ.refresh_classes() 5. Check the support website for any service updates that might need your attention. See section 6.0 for more details. 6. Configure DB2 Data Archive Expert. See Section 4.0 for more details. Note: If you are using an AIX 5.3 system and receive a java core dump error when you attempt to install or uninstall DB2 Data Archive Expert, you might have a problem with the native library libaixppk.so, which is used by the AIX platform. For a resolution to this problem, see the InstallShield documentation at http://support.installshield.com/kb/view.asp?articleid=Q111262. 3.1 Migrating existing DB2 Data Archive Expert Databases to Fix Pack 2 You can migrate your existing DB2 Data Archive Expert databases to Fix Pack 2 by running the provided migration script. Before you run the script, you can update the ahxaptf2.sql file to include the TSM node name and TSM password if you are using TSM. With Fix Pack 2, DB2 Data Archive Expert creates the AHXUSERPROPS table in the AHXPROPSTS table space, which has an 8K page size. To migrate your existing databases to Fix Pack 2: 1. (Optional) Update the ahxaptf2.sql file by editing the two ALTER statements for the AHX1 and AHX2 columns. Replace the "X" characters with the value for the TSM node name for the AHX1 column and the value of the TSM password for the AHX2 column in the AHXUSERPROPS table. 2. Run the ahxptf2.bat (Windows) or ahxPTF2.sh (with root authority on UNIX and Linux) script located in the server directory of your DB2 Data Archive Expert installation directory. 3. If you defined a target database for remote archiving with the DB2 Data Archive Expert GA or Fix Pack 1 driver, drop and recreate the nicknames for the AHXSPECS and AHXUSERPROC source tables. These source tables have been altered and DB2 does not automatically refresh the nicknames on the target database, so you must recreate them. To drop and recreate a nickname, issue the following SQL statements: db2 DROP NICKNAME db2 CREATE NICKNAME FOR 4. If you configured a source database and a target database for remote archiving with the DB2 Data Archive Expert GA or Fix Pack 1 driver, rebind both databases with the "db2 BIND DAEXLOAD.bnd" command. 3.2 Configuring databases to work with DB2 Data Archive Expert Version 2 Release 1 Fix Pack 2 You can configure a database to work with DB2 Data Archive Expert databases for Fix Pack 2 by running the provided configuration script. Before you run the script, you can update the ahxmeta.sql file to include the TSM node name and TSM password if you are using TSM. 1. (Optional) Update the ahxmeta.sql file by entering the value for the TSM node name for the AHX1 column and the value of the TSM password for the AHX2 column in the AHXUSERPOPR statement. 2. Run the ahxSetupl.bat (Windows) or ahxSetupl.sh (UNIX and Linux) script. If you have databases already configured by running ahxSetupl.bat or ahxSetupl.sh, and the values for AHX1 and AHX2 columns are X, then you can update these values by issuing the following SQL statements: UPDATE .AHXUSERPROPS SET AHX1 = '' WHERE USERID = '' UPDATE .AHXUSERPROPS SET AHX2 = '' WHERE USERID = '' 4.0 CUSTOMIZATION INSTRUCTIONS For complete instructions on how to customize and use DB2 Data Archive Expert, refer to the DB2 Data Archive Expert for z/OS and Multiplatforms User's Guide. If you received your copy of DB2 Data Archive Expert electronically, locate the User's Guide here: http://www.ibm.com/software/data/db2imstools/library.html 5.0 CORRECTIONS TO DOCUMENTATION The following sections describe corrections to documentation after the book was published. 6.0 HOW TO GET HELP For a complete and up-to-date source of DB2 Data Archive Expert information, including information on issues discovered after this README was published, go to the following Web site: DB2 Data Archive Expert Online Support: http://www.ibm.com/software/data/db2imstools/support.html If you are not able to find your answer searching the listed URL, call 1-800-IBM-SERV to speak to an IBM representative for assistance. 7.0 KNOWN PROBLEMS, RESTRICTIONS, AND WORKAROUNDS At the time the product went to distribution, the following problems, restrictions and workarounds surfaced during the final phases of product packaging and test. The items are listed below. See the restrictions section of the DB2 Data Archive Expert User's Guide for more information about product restrictions. 1. For AIX 64-bit systems, the DB2 Data Archive Expert uninstallation program will display the following message: An unhandled error occurred -- specify system property "is.debug" for more information. This is an InstallShield problem. There is no impact on the successful uninstall of DB2 Data Archive Expert. 2. After running the uninstallation program, if you intend to re-run the installation program, you must drop the DB2 Data Archive Expert database objects that were created during the installation. Once this is completed, the installation program can be run again. 3. Remote archive DAEXLOAD failure: If you are having trouble remote archiving to zLinux source or targets, and are receiving a -6555 SQL code message, run the following command: db2set DB2ATLD_PORTS=6000:6127 This will increase the number of ports that are available to the LOAD utility and might fix the problem. 4. If you receive the following error message and SQL codes when you are configuring a remote archive, your FEDERATED parameter might not be set correctly. Error message: AHXM030 SQLCode: -20076 SQLState: 0A502 SQLMessage: DB2 SQL error: SQLCODE: -20076, SQLSTATE: 0A502, SQLERRMC: 1 For a Federated server, set the DBM variable to YES and restart the database manager. Connect to your source and target databases and issue the DB2 command "DB2 CREATE WRAPPER DRDA." 5. If you receive the following error message and SQL codes when you are configuring a remote archive, the DRDA wrapper might not exist. Error message: AHXM030 SQLCode: -204 SQLState: 42704 SQLMessage: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DRDA Check your source and target databases to ensure that the DRDA wrapper was created. If it was not created, connect to the database and issue the DB2 command "DB2 CREATE WRAPPER DRDA." 6. If you receive the following error message, you might have a license issue. Error message: AHXM031 Exception has been thrown: LUM KEY CHECK FAILED Ensure that the schema in the stored procedure is correct. Check that the stored procedure AHXLICENSECHECK exists. On UNIX systems, check that symbolic links for the ahxv210.jar file exist for the DB2 instance in the SQLLIB/function directory. Ensure that the Path to the license key field has the correct directory name. 7. For the ISC interface, a retrieve specification cannot be created for a file archive specification that has a specified junction table. 8. For the ISC interface, Some ISC pages do not automatically refresh. For example, the "Working with specifications" page does not refresh automatically when you set up your remote target information. 9. For the ISC interface, the sample content text editor sometimes converts the < and > characters to corresponding hypertext substitution strings. 10. For the ISC interface, when you select unique columns for a table on the "Select columns" page, the behavior of the Apply button is inconsistent. Behavior: If you select a DB2-enforced index from the box, clicking the Apply button will check mark the columns that make up that index. If you select the NON DB2 ENFORCED choice, the behavior is different. If you make changes to the columns that are selected and click the Apply button, the selected columns may change. To specify columns for a NON DB2 ENFORCED index, you must do the following: 1. Select NON DB2 ENFORCED. 2. Click the Apply button. 3. Update the columns that you want for the index by selecting or deselecting the corresponding check boxes for those columns. 4. Do NOT click Apply. Click Next instead. 5. When you return to the Unique columns page, ensure that the correct columns are shown for each table in your archive unit. 11. For file and second-level archives on Multiplatforms, if you add columns that are not nullable to tables in your archive unit, you will be able to retrieve only the archive data versions that have all of the additional columns. 12. DB2 Data Archive Expert does not support archiving data from a table in an 8K pagesize table space to a target table in a 4K pagesize table space. 13. You cannot retrieve data from a file back to the source table if the source table is dropped. 14. If you delete a run data version for a file archive with TSM function support, the file(s) on the TSM server are not deleted. 15. On UNIX, both the dsm.opt and dsm.sys files need to be in the location that the DSMI_DIR points to. Otherwise, a dsmSetUp error is shown when running a file archive with the TSM function. 16. During the unique columns step of the ISC Create Archive wizard, you can create a new unique index by specifying the columns that are included in the index. However, you cannot specify the order of the columns. The order will be the column order shown in the select columns substep. If you edit or view an existing index in the select columns substep, the order of the index will change to the column order shown in the select columns substep, even if the order of the DB2 index is different. 17. When retrieving multiple versions of file archives that have a different number of columns from Multiplatform databases, only the latest version will have the default values in the newly added columns. Also, only the latest version will have the values in the columns added by Data Archive Expert (AHXEXECUTEDTS, AHXSEQNBR). This applies to file archives with or without TSM function support. 8.0 NOTICES This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other 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 10594-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country 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 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 publication 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. Licensees of this program who want 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 which has been exchanged, should contact: IBM Corporation J74/G4 555 Bailey Avenue San Jose, CA 95141-1003 U.S.A. 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 information 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 measurement 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. All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary. This information is for planning purposes only. The information herein is subject to change before the products described become available. This information contains 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 contains sample application programs in source language, which illustrates 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. 8.1 Use of Evaluation Program If you are using an evaluation copy of the program, the following terms apply: This program contains a disabling device that will prevent it from being used upon expiration of this license. You will not tamper with this disabling device or program. You should take precautions to avoid any loss of data that might result when the program can no longer be used. See the License Agreement terms that apply to the use of evaluation code. 8.2 Trademarks and service marks The following terms are trademarks or service marks of the IBM Corporation in the United States or other countries or both: DB2 IBM iSeries z/OS zSeries Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation 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, and service names may be trademarks or service marks of others. (C) Copyright IBM Corporation 2003, 2006. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.