DB2 Version 8.1.4 Documentation Readme Contents 1) Readme for IBM(R) DB2 Universal Database(TM) Version 8.1.4 HTML documentation 1a) Checking the level of the documentation currently installed on your system 1b) Downloading from the IBM FTP server 1c) Installing the DB2 Version 8.1.4 HTML documentation 1c.i) Checking the installation of the DB2 HTML documentation (Linux or UNIX) 1c.ii) Installing the DB2 Version 8.1.4 HTML documentation (Linux or UNIX) 1c.iii) Installing the DB2 Version 8.1.4 HTML documentation (Windows) 2) Notices 1) Readme for IBM(R) DB2 Universal Database(TM) Version 8.1.4 HTML documentation This version of the HTML documentation is comprised of all the changes and updates since DB2(R) Version 8. If you install the HTML documentation and do not install Version 8.1.4, some of the information may not be applicable. 1a) Checking the level of the documentation currently installed on your system You can check the level of the documentation currently installed on your system when you view the documentation from the HTML Information Center. Procedure To check the level of the the HTML documentation: 1. Log on to a DB2 instance ID. 2. At a UNIX shell prompt or a Windows command prompt enter the db2help command. The update level is listed in the toolbar window. The update level that appears in the Information Center for DB2 Version 8.1.4 is "Update 4". 1b) Downloading from the IBM FTP server DB2 Documentation can also be downloaded from the IBM anonymous FTP server at ftp.software.ibm.com. Go to ps/products/db2/fixes/%L/%P/ where: * %L represents the appropriate locale, for example, english-us, spanish, german. * %P represents the supported platform name/version. The directory names are as follows: +----------------------------------+----------------------------------+ | Operating System | Directory | +----------------------------------+----------------------------------+ | Linux or UNIX | db2docv8/UNIX/FP4_U488489 | +----------------------------------+----------------------------------+ | Windows | db2docv8/Windows/FP4_U488489 | +----------------------------------+----------------------------------+ 1c) Installing the DB2 Version 8.1.4 HTML documentation The following table shows the supported languages on each CD volume: +----------------------------------+----------------------------------+ | CD volume | Supported languages | +----------------------------------+----------------------------------+ | 01 of 5 | English, French, German, | | | Spanish, Italian, and Brazilian | | | Portuguese. | +----------------------------------+----------------------------------+ | 02 of 5 | English, Danish, Finnish, | | | Norwegian, Swedish, Russian, and | | | Polish. | +----------------------------------+----------------------------------+ | 03 of 5 | English, Bulgarian, Slovenian, | | | Slovak, Croatian, Czech, | | | Hungarian, Dutch, Portuguese, | | | Turkish, and Arabic. | +----------------------------------+----------------------------------+ | 04 of 5 | English, Japanese, and Korean. | +----------------------------------+----------------------------------+ | 05 of 5 | English, Simplified Chinese, and | | | Traditional Chinese. | +----------------------------------+----------------------------------+ 1c.i) Checking the installation of the DB2 HTML documentation (Linux or UNIX) You can only install the DB2 Version 8.1.4 HTML documentation on Linux or UNIX if an earlier level of DB2 HTML documentation has been previously installed. For example, DB2 Version 8 FixPak 1 HTML documentation. The doc_install script allows you to query your system to find which HTML documentation topics are currently installed and in what languages they are installed. The doc_install --q --i script that you use to check this information is found on your CD-ROM, or inside the image that you downloaded. Procedure To check which HTML documentation topics are installed on your system: 1. Run the doc_install --q --i script. 2. Check to see if you get the following sample output: core-en_US admin-en_US start-en_US core-fr_FR admin-fr_FR start-fr_FR If you do not receive any output, there are no HTML documentation topics installed on your system. Refer to the readme.txt file on the CD for instructions on how to install the documentation for the first time. 1c.ii) Installing the DB2 Version 8.1.4 HTML documentation (Linux or UNIX) Prerequisites * Ensure that your system meets installation, memory, and disk requirements. * You must have an earlier level of DB2 HTML documentation already installed. * You must have root authority to install the documentation. Restrictions * When you install the DB2 HTML documentation in an environment that already has DB2 installed, the documentation is installed on the same partition that DB2 is installed. Procedure To install the DB2 HTML documentation on a Linux or UNIX(R) operating system: Note: If you are installing the DB2 HTML documentation from the CD media, skip steps 1 and 2 and start the installation at step 3. 1. Download the appropriate documentation file for the set of languages you require. FP#_$PTF_DOC_UNIX_SBCS1.tar(.Z) English, French, German, Spanish, Italian, and Brazilian Portuguese. FP#_$PTF_DOC_UNIX_SBCS2.tar(.Z) English, Bulgarian, Slovenian, Slovak, Croatian, Czech, Hungarian, Dutch, Portuguese, Turkish, and Arabic. FP#_$PTF_DOC_UNIX_NORDIC_RU_PL.tar(.Z) English, Danish, Finnish, Norwegian, Swedish, Russian, and Polish. FP#_$PTF_DOC_UNIX_JP_KR.tar(.Z) English, Japanese, and Korean. FP#_$PTF_DOC_UNIX_SC_TC.tar(.Z) English, Simplified Chinese, and Traditional Chinese. where # represents the FixPak or modification level number and $PTF represents the related PTF number for the documentation. 2. Untar the file, or decompress and then untar the file. 3. Run the installFixPak command. The installFixPak command does not install any additional topics, it only updates the topics in the existing documentation installed on your computer. 1c.iii) Installing the DB2 Version 8.1.4 HTML documentation (Windows) Prerequisites * Your system must meet installation, memory, and disk requirements. * You must have a local Administrator user account with the recommended user rights to install the documentation. * You must use WinZip to unzip the files. Restrictions * When you install the DB2 HTML documentation in an environment that already has a DB2 product installed, the documentation is installed on the same partition that DB2 is installed. Procedure To install the DB2 HTML documentation on Windows: Note: If you are installing the DB2 HTML documentation from the CD media, skip the download steps and the CD burning steps. 1. Download the appropriate Windows documentation file for the set of languages you require. FP#_$PTF_DOC_WIN_SBCS1.zip English, French, German, Spanish, Italian, and Brazilian Portuguese. This product download contains the set up program required on Windows for installing any other language versions of the DB2 HTML documentation. FP#_$PTF_DOC_WIN_NORDIC_RU_PL.zip English, Danish, Finnish, Norwegian, Swedish, Russian, and Polish. FP#_$PTF_DOC_WIN_SBCS2.zip English, Bulgarian, Slovenian, Slovak, Croatian, Czech, Hungarian, Dutch, Portuguese, Turkish, and Arabic. FP#_$PTF_DOC_WIN_JA_KO.zip English, Japanese, and Korean. FP#_$PTF_DOC_WIN_SC_TC.zip English, Simplified Chinese, and Traditional Chinese. FP#_$PTF_DOC_WIN_NLV.exe Complete language version: English, French, German, Spanish, Italian, Brazilian Portuguese, Danish, Finnish, Norwegian, Swedish, Russian, Polish, Bulgarian, Slovenian, Slovak, Croatian, Czech, Hungarian, Dutch, Portuguese, Turkish, Arabic, Japanese, Korean, Simplified Chinese, and Traditional Chinese. This file also contains the set up program required to install the HTML documentation. You do not need to download FP4_U488489_DOC_WIN_SBCS1.zip. For English, French, German, Spanish, Italian, and Brazilian Portuguese languages a. Download the FP#_$PTF_DOC_WIN_SBCS1.zip file. b. After the file has been downloaded, unzip its contents using WinZip. This zip file's contents will be placed in a folder called DISK1. c. From the DISK1 folder, click setup.exe to bring up the DB2 Launchpad. Click Install Products and then click Next to launch the DB2 Setup wizard. For documentation in any other languages, you have two options: a. Download the complete set of the DB2 HTML documentation in all available languages. Note: The file size is approximately 600 MB. 1) FP#_$PTF_DOC_WIN_NLV.exe file which contains the DB2 HTML documentation in all available languages. 2) After the file has been downloaded, unzip its contents by running the FP#_$PTF_DOC_WIN_NLV.exe file. 3) From the folder where you extracted the contents of FP#_$PTF_DOC_WIN_NLV.exe file, click setup.exe to bring up the DB2 Launchpad. Click Install Products and then click Next to launch the DB2 Setup wizard. b. Download the appropriate CD-ROM installation images and burn them onto CD-ROMs. You can also order the CD media. 1) Regardless of which languages you wish to install, you must download the FP#_$PTF_DOC_WIN_SBCS1.zip file, or have CD volume 1 ready. This file, or CD volume 1, contains the set up program required for any installation. 2) Download any other zip files, or any other CD volumes, that you require. 3) Unzip the files using WinZip, and burn the contents of FP#_$PTF_DOC_WIN_SBCS1.zip and any other zip files you downloaded onto CD-ROMs. Note: When you burn these images from downloaded files, you must label the CD-ROM volume exactly as follows: FP#_$PTF_DOC_WIN_SBCS1.zip DISK 1 FP#_$PTF_DOC_WIN_NORDIC_RU_PL.zip DISK 2 FP#_$PTF_DOC_WIN_SBCS2.zip DISK 3 FP#_$PTF_DOC_WIN_JA_KO.zip DISK 4 FP#_#PTF_DOC_WIN_SC_TC.zip DISK 5 4) Insert the DISK 1 or CD volume 1 CD-ROM and enter the setup command to bring up the DB2 Launchpad. Click Install Products to launch the DB2 Setup wizard. 5) Insert the appropriate installation image CD-ROM when prompted. 2) Notices IBM may not offer the products, services, or features discussed in this document in all 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 10504-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country/region 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/region 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 information 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 at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Licensees of this program who wish 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 that has been exchanged, should contact: IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA 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 document 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 measurements 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. This information may contain 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 may contain sample application programs, in source language, which illustrate 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. Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows: (C) (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_. All rights reserved. IBM, DB2, Universal Database, and S/390 are trademarks of International Business Machines Corporation in the United States, other countries, or both. Windows is a registered trademark 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, or service names may be trademarks or service marks of others. ------------------------------------------------------------------------------- * are trademarks or registered trademarks of IBM Corporation. ** are trademarks or registered trademarks of their respective owners. ------------------------------------------------------------------------------- ******************************************************************************* ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1999-2003. ** ALL RIGHTS RESERVED. ** *******************************************************************************