IBM(R) DB2(R) High Performance Unload for Multiplatforms, Version 2 Release 1 IBM DB2 High Performance Unload for Workgroups, Version 2 Release 1 Fix Pack 5 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 1.2 Corrected known problems 2.0 PREREQUISITES 2.1 Hardware requirements 2.2 Software requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Installation Instructions for Windows 3.2 Installation Instructions for Non-Windows Systems 3.2.1 Uninstall Instructions for Non-Windows Systems 4.0 RESTRICTIONS 5.0 CORRECTIONS TO DOCUMENTATION 6.0 SERVICE 7.0 NOTICES 7.1 Third Party Code 7.1.1 Excluded Components 7.2 Use of evaluation program 7.3 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 High Performance Unload, Version 2 Release 1 Fix Pack 5, 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 and IBM DB2 High Performance Unload for Workgroups are abbreviated to DB2 High Performance Unload. IBM DB2 High Performance Unload (HPU) has been tested and validated with all supported releases of DB2 Universal Database(TM) through Version 8 Release 1. 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 60 days. After 60-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. Read NOTICES Section 7.2, USE OF EVALUATION PROGRAM, and the License Agreement provided with your evaluation copy of the program. 1.2 Corrected known problems This Fix Pack contains the following corrections: -WIN error Instruction cannot be referenced. This is caused by a segmentation fault on Windows with the plug-in. -Invalid characters appear in the unloaded DECIMAL column. An invalid character (usually a <) appears in a DECIMAL column. This occurs when the number of digits before and after the decimal point are the same. -INZG900E A message MsgID INZG309E has been detected but High Performance Uload Plug-in messages file is not found. HPU gives this invalid message when it could not find the message file used for producing error messages in the plugin. -Unable to unload from TS backup. 2.0 PREREQUISITES DB2 High Performance Unload has hardware and software requirements. For complete details, please see Chapter 2 in the DB2 HPU User's Guide (SC27-1623). http://www.ibm.com/software/data/db2imstools/db2tools-library.html 2.1 Hardware requirements DB2 High Performance Unload has the following hardware requirements: DB2 HPU has the same hardware requirements as the DB2 server it is supporting. Depending upon options selected, HPU will require up to 42 Meg of disk space plus approximately an additional 30 Meg of temporary disk space during install. 2.2 Software requirements To use IBM DB2 High Performance Unload, you must have a supported version of DB2 installed. 3.0 INSTALLATION INSTRUCTIONS 3.1 Installation Instructions for Windows(TM) DB2 High Performance Unload for Windows uses a GUI installation tool. To install HPU for Windows, complete the following tasks: 1. Log in to the Windows system where HPU is to be installed using the built-in administrator id. 2. Copy or move the HPU zip file into some directory which has at least 70 megabytes of freespace. 3. Unzip the file. It will create a directory structure under the current directory which starts with the subdirectory name 'default'. 4. Open a command window and change into the subdirectory containing the setup.exe file. cd db2hpu\default\disk1 5. Launch the HPU install by running the setup.exe program. 6. Follow the instructions in the panels. We recommend 'typical' install. If you wish to do a 'custom' install, choose one or more of the following options: DB2 HPU Base : Required. The base HPU functionality. DB2 Network Support : The HPU daemon, required for communication between partitions in a DB2 EEE environment, and with the DB2 Control Center plugin. DB2 Control Center plugin : Provides GUI support through the DB2 Control Center. If you choose this option, you must also choose the other two options. 3.2 Installation Instructions for Non-Windows Systems DB2 High Performance Unload normally uses a GUI installation tool. It must be installed in an X Windows(TM) environment. If your server does not have a directly attached high function terminal (HFT) capable of displaying X Windows screens, you can use a remote terminal or system by telneting into the server and setting the DISPLAY environment variable on the server to use the remote terminal's display. Another option is to install in console mode. Exceptions or changes to the install tasks if you are using console mode are noted within the following directions. To install HPU, complete the following tasks: 1. Log in to the system where HPU is to be installed as a user with root authority. 2. Verify and change if necessary the umask to 022. umask <-- Displays current umask setting umask 022 <-- Sets umask for current session 3. Verify that X applications can use the desired display. ( This step is not needed if your are using donsole mode. ) echo $DISPLAY <-- shows the current DISPLAY variable setting export DISPLAY=hostname:0 <-- set DISPLAY if incorrect. hostname is for the system whose screen is to be used. xclock& <-- verifies that X applications can display correctly. You can close the clock display after it appears. 4. Copy or move the HPU tar file into a directory which has at least 70 megabytes of freespace. 5. Untar the file. It will create a directory structure under the current directory which starts with the subdirectory name 'db2hpu'. gunzip -c db2hpuXXX-NNN.tar.gz | tar -xvf - Where XXX equals the VRM and NNN equals the platform. 6. Change into the subdirectory containing the setup file. cd db2hpu/default/disk1 7. Launch the HPU install by running the setup program. AIX -> ./setupaix HP-UX -> ./setuphpux Linux -> ./setuplnx Solaris -> ./setupsun If you are using Console Mode, add the following parameter: ./setupNNN -is:javaconsole -console Where NNN equals the platform. At the terminal where you entered this command, you should see a series of dots showing that the installation program is initializing and running. Eventually, the first installation panel should appear, or if in console mode, the first prompt. 8. Follow the instructions in the panels or prompts. We recommend using a 'typical' install. If you wish to do a 'custom' install, choose one or more of the following options: DB2 HPU Base : Required. The base HPU functionality. DB2 Network Support : The HPU daemon, required for communication between partitions in a DB2 EEE environment, and HPU and its DB2 Control Center plugin. DB2 Control Center plugin : Provides GUI support through the DB2 Control Center. If you choose this option, you must also choose the other two options. 9. After the install completes, you need to sign off your login session and log in again for the environment variable change to take effect. The new environment variable $TOPHPU gets defined in /etc/profile. 10.The following actions are optional. You may want to change the ownership of the $TOPHPU/cfg directory and all the files contained within it to your DBA staff so that changes can be made by the DBAs without requiring the assistance of the system's support group. In addition to the configuration file itself, in the future you could be requested by IBM Service to create a special trace control file in this directory for problem determination. For example, to change it to the ownerid of 'mydba' and the group 'dbagroup', use the following command : chown -R mydba:dbagroup $TOPHPU/cfg You may also wish to change the countrycode and languagecode settings in the HPU configuration file (User Guide, Chapter two, sub-chapter titled "HPU configuration file"). These two parameters define the default codepage which HPU will use if none is explicitly requested,and the db2hpu command or daemon is not able to otherwise determine the LOCALE setting. That is, the default setting in the configuration file is used as a final default setting if and only if HPU can not determine the codepage setting another way. 3.2.1 Uninstall Instructions for Non-Windows Systems See the discussion about GUI installation in "3.2 Installation Instructions for Non-Windows System." Complete the first three steps. The same rulse and options apply for uninstalling the product. As root, change into the $TOPHPU/_uninst directory, and launch the uninstaller. cd $TOPHPU/_uninst ./uninstaller.bin For Console Mode, the command is : ./uninstaller.bin -is:javaconsole -console 4.0 RESTRICTIONS Applies to all platforms: -Unload from backup is supported except for from a backup of a DMS tablespace which has LOB or Long columns. This is a temporary restriction. -It is still possible in some rare cases, that HPU may leave the table space in a QUIESCE SHARE state. If this happens, you need to issue a QUIESCE RESET. If using db2hpu in a script, just include this DB2 command at the end of the script. 5 .0 CORRECTIONS TO DOCUMENTATION To obtain the latest refresh of DB2 High Performance Unload publications refer to: http://www.ibm.com/software/data/db2imstools/library.html 6.0 SERVICE For a complete and up-to-date source of DB2 High Performance Unload information, including information on issues discovered after this README was published, go the to following website: 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 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 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. 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. 7.1 Third Party Code The Program contains, and future updates and Fix Packs to the Program may contain, certain third party components which are provided to you under terms and conditions which are different from this Agreement, or which required IBM to provide you with certain notices and/or information. For each such third party component, either IBM will identify such third party component in the Program's "README" file (or in an updated "README" file accompanying a Fix Pack or update), or in a file or files referenced in such "README" files (and shall include any associated license agreement, notices and other related information therein), or the third party component will contain or be accompanied by its own license agreement (for example, provided when installing or starting such component, or accompanying such component in a file entitled "README," "COPYING," "LICENSE" or a substantially similar title, or included among the Program's paper documentation, if any). You use of each third party component which contains or is accompanied by its own license agreement, or for which IBM has identified a license agreement in one of the above "README" files (or in a file or files referenced therein), will be subject to the terms and conditions of such other license agreement, and not this Agreement. By using and not uninstalling such third party components after the initial installation of such third party components (thereby giving you access to the applicable license agreements, notices and information), you acknowledge and agree to all such license agreements, notices and information, including those provided only in the English language. You agree to review any updated "README" file which accompanies updates or Fix Packs to the Program. 7.1.1 Excluded Components Notwithstanding the terms and conditions of any other agreement you may have with IBM or any of its related or affiliated companies (collectively "IBM"), the following terms and conditions apply to all "Excluded Components" identified in this License Information document: (a) all Excluded Components are provided on an "AS IS" basis; (b) IBM DISCLAIMS ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND CONDITIONS INCLUDING, BUT NOT LIMITED TO, THE WARRANTY OF NON-INFRINGEMENT OR INTERFERENCE AND THE IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE; (c) IBM will not be liable to you or indemnify you for any claims related to the Excluded Components; and (d) IBM will not be liable for any direct, indirect, incidental, special exemplary, punitive or consequential damages with respect to the Excluded Components. The following components in the Program are Excluded Components: (a) all third party components, including third party components included or embedded in the Program and those components referenced in any "README" file included with the Program, and (b) all source code included with the Program. The International Component for Unicode, ICU4C, is an excluded component. 7.2 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 for a complete explanation of the terms that apply. 7.3 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: AIX DB2 IBM Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product, and service names may be trademarks or service marks of others. (C) Copyright IBM Corporation 2001, 2002. (C) Copyright Infotel 2001, 2002. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.