IBM(R) DB2(R) High Performance Unload for Multiplatform(T) Version 4 Release 1 Fix Pack 1 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 2.0 PREREQUISITES 2.1 Hardware requirements 2.2 Software requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Installation instructions for Windows(TM) 3.2 Installation instructions for non-Windows systems 4.0 CUSTOMIZATION INSTRUCTIONS 5.0 KNOWN PROBLEMS AND RESTRICTIONS 6.0 HOW TO GET HELP 7.0 NOTICES 7.1 Use of Evaluation Program 7.2 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 High Performance Unload for Multiplatforms, Version 4 Release 1 Fix Pack 1, README file. This README file contains information about IBM DB2 High Performance Unload. In this README file, the following naming convention applies: IBM DB2 High Performance Unload for Multiplatforms is abbreviated to DB2 High Performance Unload. IBM DB2 High Performance Unload has been tested and validated with all supported releases of DB2 Universal Database(TM) through Version 9.7. Subsequent releases might require additional maintenance. 1.1 Evaluation Code If you are using evaluation code, the evaluation code enables you to try this product for a period of 30 days. After 30-days, you must purchase a license to continue to use the product. When you purchase the product, the license is enforced based upon the platform on which you are running IBM DB2 High Performance Unload for Multiplatforms. Read NOTICES Section 7.1, Use of Evaluation Code and the License Agreement provided with your evaluation copy of the program. 1.2 Enhancements This Fix Pack contains the following enhancements: DB2 High Performance Unload now supports IBM DB2 for Linux, UNIX, and Windows v 9.7. 1.3 Corrected known problems This Fix Pack contains corrections for the following problems: PK76917 - DB2 High Performance Unload returns the INZU363E message when the SQLSPCS.1 file is larger than 2 GB. PK78153 - DB2 High Performance Unload returns the INZU063I message "Unsupported select" for a simple SELECT statement. PK80998 - DB2 High Performance Unload finishes with a segmentation fault when unloading from backups. PK81839 - When unloading from a DMS backup, DB2 High Performance Unload returns either a bad row count or an assertion error. PK82504 - DB2 High Performance Unload returns a segmentation fault when unloading remote partitions if RTRIM is used in the SELECT block. PK83779 - DB2 High Performance Unload returns a segmentation fault on a database with more than one local or remote node and the SELECT is not natively supported by DB2 High Performance Unload. PK85885 - The number of unloaded rows reported in the INZU410I message is too high when unloading from backup. PK86026 - DB2 High Performance Unload returns INZI347E when unloading a tablespace. PK88580 - DB2 High Performance Unload returns INZU366I RC 16 (reason code 0X112C001) when unloading from backup PK89400 - High Performance Unload returns INZU458E when unloading all of the remote partitions where table partitioning is used and there is a large number of physical nodes. PK91268 - DB2 High Performance Unload freezes in the control step when a required db2hpu.map file is missing and there are more than 4 partitions and 4 CPUs on the system. PK92413 - DB2 High Performance Unload freezes when unloading from backup on an archival system. PK95449 - DB2 High Performance Unload fails unexpectedly in reaction to some DB2 return codes that do not indicate failure. PK96750 - An unload from a backup image fails with an ABORT. 2.0 PREREQUISITES DB2 High Performance Unload has hardware and software requirements. For complete details, see the DB2 High Performance Unload User's Guide (SC19-2526-00). http://www.ibm.com/software/data/db2imstools/db2tools-library.html 2.1 Hardware Requirements DB2 High Performance Unload has the same hardware requirements as the DB2 server it is supporting. Depending on options selected, High Performance Unload will require up to 266 megabytes of disk space plus approximately an additional 30 megabytes of temporary disk space during installation. 2.2 Software Requirements To use IBM DB2 High Performance Unload, you must have a supported version of DB2 installed. For the table partition feature, you must have DB2 Version 9 installed. 3.0 INSTALLATION INSTRUCTIONS For complete installation details, see the DB2 High Performance Unload User's Guide (SC19-2526-00). http://www.ibm.com/software/data/db2imstools/db2tools-library.html 3.1 Installation Instructions for Windows Systems DB2 High Performance Unload for Windows uses a GUI installation tool. To install High Performance Unload for Windows, complete the following tasks: 1. Log into the Windows system where High Performance Unload is to be installed using the built-in administrator id. 2. Copy or move the High Performance Unload .zip file into a directory that has at least 70 megabytes of available space. 3. Unzip the file. 4. Launch the High Performance Unload installation by running the install.exe program. 5. Click Next. The Select Components page is displayed. 6. You can choose from the following DB2 High Performance Unload components: DB2 High Performance Unload Base This option is required. It provides the base DB2 High Performance Unload functionality. DB2 Network Support This option installs the DB2 High Performance Unload daemon, which is required for communication between the partitions in a partitioned DB2 environment and communication with the DB2 stored procedure. DB2 Stored Procedure This option installs DB2 High Performance Unload as a stored procedure. In order to install this option, you also need to install DB2 network support. Attention: If you choose this option, the DB2 High Performance Unload installation process will install all of the files necessary to configure DB2 High Performance Unload as a DB2 stored procedure. Refer to Configuring DB2 High Performance Unload DB2 stored procedure on Windows systems for configuration instructions. 7. Click Next to continue the installation. The License Agreement page is displayed. 8. Choose OK to accept the terms. 9. When you have finished, click Next. The Pre-Installation Summary page is displayed. 10. Review your selections from the Pre-Installation Summary page You can click Back to return to a previous page to change any of your selections. Attention: Make sure that before installing the Fix Pack, the GA version of DB2 Hight Performance Unload is already installed on your system. 11. Click Next to start the installation. 3.2 Installation Instructions for Non-Windows Systems Use the console mode to install DB2 High Performance Unload on non-Windows systems: 1. Log into the system where DB2 High Performance Unload is to be installed as a user with root authority. 2. Mount the CD on a suitable mount point (for example, /mnt/cdrom). 3. Change to the directory that corresponds to the platform under the CD mount point. For example, for AIX® systems, enter: cd /mnt/cdrom/aix 4. Copy or move the compressed DB2 High Performance Unload tar file (xxx.tar.gz) into a directory with sufficient free space. 5. Uncompress and untar the file. For example: gunzip -c xxxxx.tar.gz | tar -xvf - After the file is untarred, an additional HPU4110 subdirectory will be created. 6. Change to the HPU4110 subdirectory. 7. Run either the ./install_hpu.sh command or the .install_hpu.sh -d command as a root user. If you start the installer without any parameters, DB2 High Performance Unload will be installed in the /opt/IBM/DB2TOOLS/HighPerformanceUnload41 directory. 8. Follow the instructions in the prompts. The install process will automatically install all of the following components: DB2 High Performance Unload Base This option is required. It provides the base DB2 High Performance Unload functionality. DB2 Network Support This option installs the DB2 High Performance Unload daemon, which is required for communication between the partitions in a partitioned DB2 environment and communication with the DB2 stored procedure. DB2 Stored Procedure This option installs DB2 High Performance Unload as a stored procedure. In order to install this option, you also need to install DB2 network support. 3.2.1 Uninstallation Instructions See the discussion about uninstalling DB2 High Performance Unload in the DB2 High Performance Unload User's Guide. The information is provided for both Windows and non-Windows systems. 4.0 CUSTOMIZATION INSTRUCTIONS For complete instructions on how to customize and use DB2 High Performance Unload, refer to IBM DB2 High Performance Unload User's Guide. If you received your copy of IBM DB2 High Performance Unload electronically, locate the User's Guide here: http://www.ibm.com/software/data/db2imstools/library.html If you are installing this image from a CD-ROM, the documentation is located in /doc directory. The User's Guide on the Web can contain updates to the publication on CD-ROM. 5.0 KNOWN PROBLEMS AND RESTRICTIONS 1. If you specify the partitions only in the XML IN clause ("xml path" FOR PARTS (1)) where the table space resides, DB2 High Performance Unload returns the INZU425W warning. Solution: Ignore the message because the control file is valid. 2. If you try to unload data when at least one partition requested for unloading has not been specified in the XML IN clause ("xml path" FOR PARTS (1,2)) or a LOB IN clause ("lob path" FOR PARTS (1,2)), DB2 High Performance Unload returns the INZU425W warning. Solution: Specify all the partitions requested for unloading in a LOB IN or XML IN clause. 3. If you use the deprecated OUTPUT clause to unload data and specify an absolute path in the XML IN clause, DB2 High Performance Unload returns the INZI347E error. Solution: Use the new OUTFILE clause instead of the OUTPUT clause or specify a relative path instead of the absolute path. 4. If you try to unload a table having XML or LOB data into more then one output files by either using the OUTFILE or OUTPUT clauses, DB2 High Performance Unload returns a segmentation fault and the INZ0666F error. This issue is only relevant if you are using the XML output format. Solution: Unload into a single output file instead or use template keywords to specify multiple files. 5. If you try to unload XML data from DB2 v9.5 or later on Solaris or HP-UX platforms, DB2 High Performance Unload can return the INZ0666F error. Solution: None. 6. DB2 High Performance Unload returns the INZU366I error with return code 8 (reason code 0x123a02b) when unloading data on Windows XP Professional SP2 (32 bit) system with DB2 v 9.7. Solution: Not available. 6.0 HOW TO GET HELP For a complete and up-to-date source of IBM DB2 High Performance Unload information, including information on issues discovered after this README was published, go to the following Web site: IBM DB2 High Performance Unload 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 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 ther 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 as 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 a pplication 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. 7.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. 7.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 Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds 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 2001, 2008. Copyright InfoTel 2001, 2008. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.