IBM(R) DB2(R) High Performance Unload for Multiplatform(T) IBM(R) DB2(R) High Performance Unload for Workgroups(T) Version 3 Release 1 Fix Pack 1 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 2.0 CORRECTED KNOWN PROBLEMS 2.1 Additional corrected problems 3.0 PREREQUISITES 3.1 Hardware requirements 3.2 Software requirements 4.0 INSTALLATION INSTRUCTIONS 4.1 Installation instructions for Windows(TM) 4.2 Installation instructions for non-Windows systems 5.0 CUSTOMIZATION INSTRUCTIONS 6.0 RESTRICTIONS 7.0 HOW TO GET HELP 8.0 NOTICES 8.1 Use of Evaluation Program 8.2 Other notices 8.2.1 ICU4C 2.6.2 8.2.2 Info-Zip Zip 2.3 8.3 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 High Performance Unload for Multiplatforms, Version 3 Release 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 and IBM DB2 High Performance Unload for Workgroups are 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 8.2 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 for Multiplatforms. Read NOTICES Section 8.1, Use of Evaluation Code and the License Agreement provided with your evaluation copy of the program. 2.0 CORRECTED KNOWN PROBLEMS This Fix Pack contains corrections for the following problems: APAR PK28886 - INZU471E: Backup API error when running unload against a backup and the backup was created using PARALLELISM with the output files going to the same directory. PK29683 - INZU447E: Unable to load the Storage tool is posted when running 64-bit HPU v3.1 against 64-bit DB2 8.1 Fix Pack 10 and above. PK29561 - SEGMENTATION FAULT when trying to unload the value of a column defined as not null with the default. PK28730 - HPU is enabled by use of QUIESCE YES, handles interrupts poorly, and reports return codes "8" AND "16". 2.1 Additional corrected problems: - Bad value for graphic column data location in the LOAD command generated with ASC output format. - Missing double-quotes around the filename in the LOAD command generated with ASC output format. - Failure when unloading data from remote partitions only. - Remote unload processing not run using the appropriate user authorizations. - Failure if specifying a LOADFILE clause without any OUTPUT clause. - Unload hanging if the ulimit maximum file size is reached by an output file. - Failure when unloading a table with a column which default value is defined as the USER special registry. - Unload of a full table space or database not executed if a table is protected by Advanced Access Control for the user running. - Unload from a backup image of a data-partitioned table not supported. - Data-partitioned tables not unloaded when unloading a full database. - Unable to load the TSM library on AIX, if it is dependant on DB2 libraries. - Host name aliases not supported in the OUTPUT clause. - DB2 instance configuration file content badly handled by the plugin if there are several spaces between fields of this file. - Data-partitioned tables not supported on Windows. - Failure during the control step, due to a bad default value handling. - Failure on compressed row with DB2 9. - Nettohosts entries are limited by db2hpu.cfg line length restriction. 3.0 PREREQUISITES To install this fix pack, you must have DB2 High Performance Unload for Multiplatforms V3.1 or DB2 High Performance Unload for Workgroups V3.1 installed. DB2 High Performance Unload has hardware and software requirements. For complete details, please see Chapter 2 in the DB2 High Performance Unload User's Guide (SC27-1623). http://www.ibm.com/software/data/db2imstools/db2tools-library.html 3.1 Hardware Requirements DB2 High Performance Unload has the same hardware requirements as the DB2 server it is supporting. Depending upon options selected, High Performance Unload will require up to 42 megabytes of disk space plus approximately an additional 30 megabytes of temporary disk space during install. 3.2 Software Requirements To use IBM DB2 High Performance Unload, you must have a supported version of DB2 installed. To use the table partition feature, you must have DB2 Version 9 Fix Pack 2 installed. 4.0 INSTALLATION INSTRUCTIONS 4.1 Installation Instructions for Windows(TM) Before installing this fix pack, you must first stop the HPU network service if it is installed and running on your system. To do this, go to: Start -> Control panel -> Administrative Tools -> Services. Scroll down to the entry for "HPU for DB2 for network service V3". If this entry exists and its status is "Started", then right-click it and click Stop in the popup menu. 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. It will extract 4 files into the current directory. 4. Launch the High Performance Unload install by running the setup.exe program. 5. Follow the instructions in the panels. We recommend the 'typical' install. If you wish to do a 'custom' install, choose one or more of the following options: DB2 High Performance Unload Base: Required. The base High Performance Unload functionality DB2 Network Support: The High Performance Unload daemon, required for communication between partitions in a DB2 DPF 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. 4.2 Installation Instructions for non-Windows Systems DB2 High Performance Unload uses a GUI installation tool in an X Windows(TM) environment. There are several other ways you can install the product 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. - A third option is to create a response file and do a silent install. See "DB2 High Performance Unload User's Guide," available at the following Web location, for a description on how to create a response file: http://www.ibm.com/software/data/db2imstools/library.html To install High Performance Unload, complete the following tasks: 1. Log into the system where High Performance Unload 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 necessary if you are using console mode. ) echo $DISPLAY shows the current DISPLAY variable setting export DISPLAY=hostname:0 set DISPLAY if incorrect. Hostname is the name of 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 High Performance Unload tar file (XXXXXXX.tar.gz) into a directory which has at least 140 megabytes of available space. 5. Untar the file. It will extract 4 files into the current directory. gunzip -c XXXXXXX.tar.gz | tar -xvf - 6. Launch the High Performance Unload install by running the setup program: AIX -> ./setupaix Linux for pSeries -> ./setuplinuxppc Linux for zSeries -> ./setupzlinux390 Linux -> ./setuplinux Solaris -> ./setupsun If you are using Console Mode, add the following parameter: ./setupXXX -is:javaconsole -console where XXX 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. 7. Follow the instructions in the panels or prompts. Using a typical install is recommended. If you want to do a 'custom' install, choose one or more of the following options: DB2 High Performance Unload Base: Required. The base High Performance Unload functionality DB2 Network Support: The High Performance Unload daemon, required for communication between partitions in a DB2 EEE environment, and High Performance Unload and its DB2 Control Center plugin. DB2 Control Center plugin (available only on Linux for xSeries): Provides GUI support through the DB2 Control Center. If you choose this option, you must also choose the other two options. 8. After the install completes, you must sign off of your login session, then log in again. 9. The following actions are optional. You might want to change the ownership of the configuration directory and all the files contained within it to your Database Administrator 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 modify a special trace control file in this directory for problem determination. For example, to change ownership to the ownerid of 'mydba' and the group 'dbagroup', use the following command : chown -R mydba:dbagroup XXXXX/cfg where XXXXX is your install directory 5.0 CUSTOMIZATION INSTRUCTIONS This fix pack introduces a new file in the HPU configuration (cfg) subdirectory. This file is called db2hpu.map, and is a replacement for the nettohosts option in the db2hpu.cfg. Either can be used after applying this fix pack, but it is IBM's intention for nettohosts to eventually not be supported, and db2hpu.map to be its replacement. If you are currently setting nettohosts in your db2hpu.cfg file, here is how to create the db2hpu.map entries from them. nettohosts=netname1:hostname1,netname2:hostname2 These would be entered into the db2hpu.map file as the following two lines : netname1=hostname1 netname2=hostname2 If you do not set nettohosts today, you can ignore this change. For complete instructions on how to customize and use DB2 High Performance Unload, refer to IBM DB2 High Performance Unload for Multiplatforms User's Guide. If you received your copy of IBM DB2 High Performance Unload electronically, locate the User's Guide and any current updates for it : http://www.ibm.com/software/data/db2imstools/library.html If you are installing this product 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. 6.0 RESTRICTIONS There are no known restrictions when using this version of DB2 High Performance Unload. 7.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. 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 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. 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 Other notices 8.2.1 ICU4C 2.6.2 The International Components for Unicode (ICU4C) are excluded components. Notices for ICu4C 2.6.2 COPYRIGHT AND PERMISSION NOTICE Copyright (c) 1995-2002 International Business Machines Corporation and others All rights reserved. Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, provided that the above copyright notice(s) and this permission notice appear in all copies of the Software and that both the above copyright notice(s) and this permission notice appear in supporting documentation. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIALINDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT,NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. Except as contained in this notice, the name of a copyright holder shall not be used in advertising or otherwise to promote the sale, use or other dealings in this Software without prior written authorization of the copyright holder. 8.2.2 Info-Zip Zip 2.3 Info-Zip Zip 2.3 are excluded components. Notices for Info-Zip Zip 2.3 This is version 1999-Oct-05 of the Info-ZIP copyright and license. The definitive version of this document should be available at ftp://ftp.cdrom.com/pub/infozip/license.html indefinitely. Copyright (c) 1990-1999 Info-ZIP. All rights reserved. For the purposes of this copyright and license, "Info-ZIP" is defined as the following set of individuals: Mark Adler, John Bush, Karl Davis, Harald Denker, Jean-Michel Dubois, Jean-loup Gailly, Hunter Goatley, Ian Gorman, Chris Herborth, Dirk Haase, Greg Hartwig, Robert Heath, Jonathan Hudson, Paul Kienitz, David Kirschbaum, Johnny Lee, Onno van der Linden, Igor Mandrichenko, Steve P. Miller, Sergio Monesi, Keith Owens, George Petrov, Greg Roelofs, Kai Uwe Rommel, Steve Salisbury, Dave Smith, Christian Spieler, Antoine Verheijen, Paul von Behren, Rich Wales, Mike White This software is provided "as is," without warranty of any kind, express or implied. In no event shall Info-ZIP or its contributors be held liable for any direct, indirect, incidental, special or consequential damages arising out of the use of or inability to use this software. Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely, subject to the following restrictions: 1. Redistributions of source code must retain the above copyright notice, definition, disclaimer, and this list of conditions. 2. Redistributions in binary form must reproduce the above copyright notice, definition, disclaimer, and this list of conditions in documentation and/or other materials provided with the distribution. 3. Altered versions--including, but not limited to, ports to new operating systems, existing ports with new graphical interfaces, and dynamic, shared, or static library versions--must be plainly marked as such and must not be misrepresented as being the original source. Such altered versions also must not be misrepresented as being Info-ZIP releases--including, but not limited to, labeling of the altered versions with the names "Info-ZIP" (or any variation thereof, including, but not limited to, different capitalizations), "Pocket UnZip," "WiZ" or "MacZip" without the explicit permission of Info-ZIP. Such altered versions are further prohibited from misrepresentative use of the Zip-Bugs or Info-ZIP e-mail addresses or of the Info-ZIP URL(s). 4. Info-ZIP retains the right to use the names "Info-ZIP," "Zip," "UnZip," "WiZ," "Pocket UnZip," "Pocket Zip," and "MacZip" for its own source and binary release 8.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: DB2 IBM 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 2002, 2006. Copyright InfoTel 2002, 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.