IBM(R) DB2 High Performance Unload for HP-UX, Version 2 Release 1, FixPak 3 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 CORRECTED KNOWN PROBLEMS 3.0 PRODUCT RESTRICTIONS FOR THIS LEVEL OF CODE 4.0 INSTALLATION INSTRUCTIONS 4.1 UNINSTALL INSTRUCTIONS 5.0 CORRECTIONS TO DOCUMENTATION 6.0 SERVICE 7.0 NOTICES 7.1 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 High Performance Unload for HP-UX, Version 2 Release 1, FixPak 3 README file that contains the latest fixes for DB2 High Performance Unload for HP-UX V2.1. 2.0 CORRECTED KNOWN PROBLEMS This FixPak corrects the following problems: -Now supports DB2 Version 8 as well as DB2 Version 7 -In previous revisions of the User's Guide, there was a note in Chapter 2 - Section, "HPU configuration file". The note indicated that if the db2hpu.cfg file is modified, then you must run the command $TOPHPU/bin/db2hpu -configuration in order for changes to take affect. This is no longer required and the -configuration parameter is no longer needed. -On EEE systems, you may now unload into a combined, single file as well as into separate output files per partition. Obviously you get maximum parallel performance if they are seperate files per partition. -Fix: fully qualified uname not parsed properly -Changed: Suppression of shared memory -Changed: suppression of memory based configuration, -c is now obsolete -Changed: completely reworked the conversion engine -Changed: use ICU instead of iconv -Fix: issues with mixed code page and ICF -Fix: lifted the 2Gb file limit on all plateform -Changed: reworked the run engine -Added: support of column level selection in SELECT clause -Added: support of SMS and DMS backup. EE and EEE (except for LOB and LF columns) -Fix: better locale support -Fix: ON REMOTE HOST not functional -Added: Message and Trace services. -Added: support of FILEMAXSIZE, split output file in chunk of given size -Fix: LOB Compact not properly supported -Fix: problem with LF and LOB remote -Fix: STRIPED containers handling -Fix: discard View from table liste -Fix: some time/date/timestamps formats are incorrect -Added: new parameter in the config file to override factory defaults -Added: control over the TOPHPU variable -Added: consistency of PART() clause -Fix: support of Quiesce and Lock -Fix: problem with SKIP keyword To obtain a list of fixes that were included in previous FixPaks refer to APARs PQ66202 and PQ66960. 3.0 PRODUCT RESTRICTIONS FOR THIS LEVEL OF CODE -Maximum performance will be achieved when unloading all rows from a table. DB2 EXPORT will be invoked automatically if on the SELECT statement, you specify a WHERE clause. This is a temporary restriction. -Unload from backup is supported provided no LOB or Long columns are being unloaded. This is a temporary restriction. -For DB2 Version 8, this FixPak may not install properly and files may be missing from some of the subdirectories under $TOPHPU. Before applying this FixPak in a DB2 version 8 environment It is suggested that you copy or tar up the $TOPHPU directory and its contents prior to installing this FixFak. You can create the tar file with the following command : tar -cvf savehpu.tar $TOPHPU The resulting tar file (savehpu.tar) will take about 58 Meg. This problem will be fixed in a future FixPak. -If specifying column names in the SELECT statement, just list the column names and do not enclose them in double quotes. It will be fixed in a future FixPak. -In some cases, HPU leaves the table space in a QUIESCE SHARE state. You need to issue a QUIESCE RESET if this happens. If using db2hpu in a script, just include this DB2 command at the end of the script. This will be fixed in a future FixPak. 4.0 INSTALLATION INSTRUCTIONS DB2 High Performance Unload for HP-UX uses a GUI installation tool. It must be installed in an X Windows(TM) environment. If your HP-UX 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 run InstallShield using Console Mode. Exceptions or changes to the install tasks if you are using Console Mode are noted within the following directions. To install DB2 High Performance Unload (HPU) for HP-UX, complete the following tasks: 1. Log in to the HP-UX 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 running Console 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 (db2hpu212-hpux.tar.gz) 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 db2hpu212-hpux.tar.gz | tar -xvf - 6. Change into the subdirectory containing the setuphpux file. cd db2hpu/default/disk1 7. Launch the HPU install by running the setuphpux program. ./setuphpux If you are using Console Mode, add the following parameter: ./setuphpux -is:javaconsole -console 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, be sure to also choose the DB2 Network Support option. 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/environment. 4.1 UNINSTALL INSTRUCTIONS As root, stop the daemon, change into the $TOPHPU/_uninst directory, and launch the uninstaller. db2hpud stop cd $TOPHPU/_uninst ./uninstaller.bin For Console Mode, the command is : ./uninstaller.bin -is:javaconsole -console 5 .0 CORRECTIONS TO DOCUMENTATION To obtain the latest documentation updates refer to the Support Flashes category: http://www.ibm.com/software/data/db2imstools/support.html 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 websites: DB2 High Performance Unload Product: http://www.ibm.com/software/data/db2imstools/index.html DB2 High Performance Unload Publications: http://www.ibm.com/software/data/db2imstools/library.html 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 URLs, call 1-800-237-5511 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. 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. 7.1 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 or 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, 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.