IBM(R) DB2(R) High Performance Unload for Multiplatform(T) Version 4 Release 1 Fix Pack 2 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 2, 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.3 Corrected known problems This Fix Pack contains corrections for the following problems: PK95444 - DB2 High Performance Unload returns INZU353I and INZU331E messages when using a DB2 nickname during an unload from DB2 v9. PK97389 - DB2 High Performance Unload returns INZI347E when using DB2 Workgroup edition. PM01992 - The output from DB2 High Performance Unload has corrupted data. PM01141 - DB2 High Performance Unload returns INZU466E when unloading from DB2 v9.7 compressed tables. PM01720 - DB2 High Performance Unload hangs intermittently. PM01713 - DB2 High Performance Unload leaves the table space quiesced. PM04270 - DB2 High Performance Unload installation process assigns directory and file ownership to an ID that does not exist on the system. PM03153 - DB2 High Performance Unload returns INZU312E. PM04756 - DB2 High Performance Unload on HP-UX systems fails with a ".../SHIF_JIS NOT FOUND" message. PM05090 - DB2 High Performance Unload output shows no data for the nullable timestamp column data type on DB2 V9.7. PM05649 - DB2 High Performance Unload trace facility grants write privileges to a user ID when that user ID has no file system privileges. PM06845 - DB2 High Performance Unload returns control to the session without performing any functions and without any messages. PM08887 - DB2 High Performance Unload produces a segmentation violation when db2hpu is run on a backup and localhost has been defined as the hostname. PM09015 - DB2 High Performance Unload receives the following messages when the scalar functions min() and/or max() and the GROUP BY clause are a part of the SELECT statement: INZU010I, INZU016E, and INZU366I. PM09393 - DB2 High Performance Unload returns INZI006E and INZU361W when unloading 1351 and 5039 code page data from SJIS databases on HP-UX machines. 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 install DB2 High Performance Unload for Multiplatforms, Version 4 Release 1 Fix Pack 2, you must have already installed the fully licensed version of DB2 High Performance Unload for Multiplatforms, Version 4 Release 1. 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 HPU4120 subdirectory will be created. 6. Change to the HPU4120 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-01.ibm.com/software/data/db2imstools/db2tools-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 None. 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/support/entry/portal/Overview/Software/Information_Management/DB2_Tools_for_z~OS 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, 2010. Copyright InfoTel 2001, 2010. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.