IBM DB2 Universal Database Data Warehouse Edition, Version 8.2 Read Me First +---- Note ------------------------------------------------------------+ Before using this information and the product it supports, read the information in "Notices". +----------------------------------------------------------------------+ This edition applies to the DB2 Data Warehouse Enterprise Edition, Version 8.2 and the DB2 Data Warehouse Standard Edition, Version 8.2 products and to all subsequent releases and modifications until otherwise indicated in new editions. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in the United States or 1-800-IBM-4YOU in Canada. When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. Copyright International Business Machines Corporation 2003, 2004. All rights reserved. Contents Introduction Restrictions, problems, and workarounds Third Party Code Notices Introduction Welcome to IBM(R) DB2 Universal Database(TM) Data Warehouse Enterprise Edition, Version 8.2 and IBM DB2 Universal Database Data Warehouse Standard Edition, Version 8.2. This document provides updates and corrections to the DB2 Data Warehouse Edition Getting Started. You should read the appropriate sections of the Read Me First before you use the Getting Started book and install the products. After you read this document, you should read the Getting Started document. The Getting Started book provides an overview of the installation process for either the DB2 Data Warehouse Enterprise Edition or the DB2 Data Warehouse Standard Edition. The DB2 Data Warehouse Edition Getting Started is available in both PDF (portable document format) or HTML (hypertext markup language) in different languages. Note: For the latest version of this Readme, see the DWE Web site at: http://www.ibm.com/software/data/db2/udb/dwe/features.html Restrictions, problems, and workarounds This section describes restrictions and possible problems that you might encounter when you install the products in the DB2 Data Warehouse Enterprise Edition or the DB2 Data Warehouse Standard Edition. * On UNIX(R) operating systems, you must install Mozilla 1.x and specify its location in the PATH statement in order for the Readme and Getting Started links to work on the DWE Launchpad. * The DWE integrated installation program assumes that you defined the CD drive(s) as file systems on UNIX platforms. No arguments are used with the mount command except for the directory name that you want to mount. For example, on Linux the following command should work successfully: mount /mnt/cdrom * On Linux, you cannot mount a CD in the drive before you start the DWE integrated installation. If a CD is mounted when you lanuch the DWE installation, you cannot unmount the CD without quitting the DWE installation. If the DWE installation is on a CD, either follow the instructions in the topic "Starting the installation on UNIX and Linux" in Chapter 5 of the Getting Started guide, or copy the entire contents of the CD to a hard drive location and launch the installation program from that location. * On AIX(R) and Solaris, you could receive the following error message during the installation process: The extract of the install program failed. Return to the DWE install program after verifying that you have enough disk space available. If you receive this message, click OK to open another window where you can enter a new location for the temporary directory. Click Cancel to exit the DWE installation. * You can run the DB2 Warehouse Manager Standard Edition on a 64-bit operating system under a 32-bit DB2 instance. In addition, you can use the DB2 Warehouse Manager to move data on a 64-bit DB2 instance, but only if you run all of the warehouse components, such as the warehouse server, warehouse control database, and warehouse agent, on a 32-bit DB2 instance. To run the DB2 Warehouse Manager on the same workstation as a 64-bit warehouse source and a 64-bit warehouse target: 1) Define a 32-bit DB2 instance by entering the following command at a DB2 command line: db2icrt For more information, see "Creating an instance using db2icrt" in the DB2 Installation and Configuration Supplement. You can also find this topic in the DB2 Information Center. 2) Install the Warehouse Manager components that you want to use. For more information, refer to the DB2 Warehouse Manager Installation Guide, or the DB2 Information Center. 3) Verify that the IWH.environment file points to the 32-bit DB2 instance that you defined. Make sure that the warehouse server, warehouse agent, and warehouse control database reside on this 32-bit DB2 instance. 4) In the 32-bit instance that contains the warehouse components, catalog the 64-bit warehouse source database and the 64-bit warehouse target database by entering the following command from a DB2 command line: CATALOG TCPIP NODE node-name SERVER service-name REMOTE_INSTANCE instance-name CATALOG DB 64bitDB AT NODE node-name * If you want to host the DB2 Information Center from a remote system and access DB2 documentation from this remote system, then you must change the values for the DB2_DOCHOST and DB2_DOCPORT variables. You can find instructions for changing these variables in the topic "Setting the location for accessing the DB2 Information Center" at the following URL: http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic= /com.ibm.db2.udb.common.doc/common/settingdocloc.htm * On Windows, to display the mnemonics for the Install panel buttons, press the Alt key. * The correct text for error message DWE0012E is as follows: DWE0012E: No components were uninstalled because the processing to stop DB2 was not successful. Uninstall could not proceed because DB2 services did not stop running. The text for this message is incorrect in the Getting Started guide. * You can download DB2 FixPacks at the following Web site: http://www.ibm.com/software/data/db2/udb/support/downloadv8.html This Web site also contains instructions for installing DB2 FixPaks. THIRD PARTY LICENSE TERMS AND CONDITIONS, NOTICES AND INFORMATION The license agreement for this product refers you to this file for details concerning terms and conditions applicable to third party software code included in this product, and for certain notices and other information IBM must provide to you under its license to certain software code. The relevant terms and conditions, notices and other information are provided or referenced below. Please note that any non-English version of the licenses below is unofficial and is provided to you for your convenience only. The English version of the licenses below, provided as part of the English version of this file, is the official version. Notwithstanding the terms and conditions of any other agreement you may have with IBM or any of its related or affiliated entities (collectively "IBM"), the third party software code identified below are "Excluded Components" and are subject to the following terms and conditions: - the Excluded Components are provided on an "AS IS" basis; - IBM DISCLAIMS ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND CONDITIONS WITH RESPECT TO THE EXCLUDED COMPONENTS, 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; - IBM will not be liable to you or indemnify you for any claims related to the Excluded Components; and - IBM will not be liable for any direct, indirect, incidental, special, exemplary, punitive or consequential damages with respect to the Excluded Components. =============== UnZipSFX Stub file: The Program includes "UnZipSFX stub" software from the Info-Zip group which is Copyright (c) 1999-2002, Info-ZIP. All rights reserved. IBM did not modify the UnZipSFX software. There are no extra charges or costs due to the use of this code, and the original compression sources are freely available from http://www.cdrom.com/pub/infozip/ or ftp://ftp.cdrom.com/pub/infozip/ on the Internet. 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 10504-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. 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 which has been exchanged, should contact: IBM Corporation J46A/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. 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. 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. 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. If you are viewing this information softcopy, the photographs and color illustrations may not appear. Licensed Material - Program Property of IBM (c) Copyright IBM Corp. 2003. All Right Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. IBM, AIX, DB2, DB2 Universal Database, and Intelligent Miner are trademarks of International Business Machines 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. All rights reserved.