IBM DB2 Universal Database* Version 7.1 for Windows NT/2000 PTF No: WR21198 (NLV: WR21200) VRMF: 07.01.0000.0001 +-- Note: ----------------------------------------------------------------+ | | To read this file more easily, set your font to monospace. | | If you have received interim fixes from IBM support after 07/27/2000, | then you must contact IBM support to request an updated version of the | interim fixes instead of installing this FixPak. By doing this, you are | assured that your system is in a consistent state and no interim fixes | are lost. Interim fixpaks are identified by followed by a letter. | For example, WR21198a or WR21198b etc. | | Throughout this document X: is used to refer to the CD-ROM drive into | which the FixPak CD is placed and C:\SQLLIB is where the DB2 products | are installed. | +-------------------------------------------------------------------------+ This README file contains information for the following products and components: NT/2000 Specific -------------- DB2 Connect Personal Edition, V7.1 DB2 Connect Enterprise Edition, V7.1 DB2 UDB Enterprise Edition, V7.1 DB2 UDB Workgroup Edition, V7.1 DB2 UDB Personal Edition, V7.1 DB2 UDB Enterprise-Extended Edition, V7.1 DB2 Application Development Client, V7.1 DB2 Data Links Manager, V7.1 DB2 Warehouse Manager , V7.1 DB2 Administration Client, V7.1 DB2 Run-Time Client, V7.1 DB2 Relational Connect, V7.1 DB2 Query Patroller, V7.1 DB2 OLAP Starter Kit , V7.1 --------------------------------------------------------------------------- 1. Contents of FixPak 2. Installation Notes 2.1 Pre-requisites 2.2 Prior to Installation 2.3 Installation Instructions 2.3.1 Applying Fixpak for Data Links Manager 2.4 Unattended Install Instructions 2.5 After Installation 2.5.1 Rebinding to non-DRDA DB2 databases 2.5.2 Rebinding to DRDA databases 2.5.3 Rebinding Specific Packages 2.5.4 DataJoiner Replication Administration Tool 2.5.5 DB2 OLAP Starter Kit for Universal Database 7.1 Fixpak 1 2.6 Uninstallation Notes 3. Service 3.1 Product and Service Technical Library 3.2 Customer Support 3.3 Corrective Service For additional information please see the following files: C:\SQLLIB\RELEASE.TXT X:\APARLIST.TXT =========================================================================== 2. Installation Notes 2.1 Prerequisites This Fixpak requires that at least one Version 7.1 DB2 UDB for NT/2000 product be already installed on your system. To determine the version and level of the currently installed DB2 product, type regedit from an MS-DOS prompt and check the following values under the registry key HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\\CurrentVersion. The values should be the following: Version "7" Release "1" Modification "0" Service Level "" 2.2 Prior to Installation It is recommended you stop all database activity before applying this FixPak. To do this, issue the commands: db2stop db2admin stop 2.3 Installation Instructions To start the FixPak, run X:\SETUP.EXE. NOTE: Once you have installed a fixpak, you cannot uninstall it. 2.3.1 Applying Fixpak for Data Links Manager 1. As the DB2 Data Links Manager Administrator (dlmadmin), bring down the DB2 Data Links Manager by stopping the DB2 Data Links Manager service: Start->Settings->Control Panel->services Stop DB2 Data Links Manager Ensure that there are no other DB2 processes remaining, by issuing a db2stop for each instance. 2. Install the Fixpak 3. As the DB2 Data Links Manager Administrator, run the following commands to bring up the DB2 Data Links Manager: dlfm bind dlfm start Check the db2diag.log to ensure that the Data Links Manager is started properly. 2.4 Unattended Install Instructions The version of SETUP.EXE shipped with this FixPak is capable of running via an "unattended install" option. The syntax for this feature is documented in the Quick Beginnings book. A sample response file (DB2FIXPK.RSP) is included in this FixPak: 2.5 After Installation Due to the new bind (.bnd) files that have been shipped with this FixPak, you will need to rebind your utilities against all your databases after the FixPak installation. This step is necessary for the fixes in this FixPak to become effective. The procedure of rebinding, outlined below, only needs to be performed once per database. 2.5.1 Rebinding to non-DRDA DB2 databases After applying fixes, you must do the following: db2 terminate db2 CONNECT TO db2 BIND C:\SQLLIB\BND\@db2ubind.lst GRANT PUBLIC db2 BIND C:\SQLLIB\BND\@db2cli.lst GRANT PUBLIC db2 terminate Where is the name of a database to which the utilities should be bound. Examine the DB2PATH environment variable to determine the correct path. DB2UBIND.LST and DB2CLI.LST contain lists of commonly required bind files used for DB2. 2.5.2 Rebinding to DRDA databases If you are using DB2 Connect to access host databases, you will also need to bind the new bind files. As above, connect to the host database, and then bind the utilities as follows: HOST COMMAND ===== =================================================================== MVS BIND C:\SQLLIB\BND\@ddcsmvs.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC VM BIND C:\SQLLIB\BND\@ddcsvm.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC VSE BIND C:\SQLLIB\BND\@ddcsvse.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC OS400 BIND C:\SQLLIB\BND\@ddcs400.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC 2.5.3 Rebinding Specific Packages If you wish to bind only the specific .bnd files to the database, issue the following command for each database (where is the name of the bind file, and is the name of your database). db2 terminate db2 CONNECT TO db2 BIND C:\SQLLIB\BND\ BLOCKING ALL GRANT PUBLIC db2 terminate 2.5.4 DataJoiner Replication Administration Tool The location of the DataJoiner Replication Administration (DJRA) tool (djra.exe) is now installed in the directory SQLLIB\DJRA. 2.5.5 DB2 OLAP Starter Kit for Universal Database 7.1 Fixpak 1 The DB2 OLAP Starter Kit license does not update automatically when you install Fixpak 1 for Universal Database. In order to update the license for OLAP Starter Kit, follow these instructions: 1. Install Fixpak 1. 2. After the Fixpak is installed ensure that any OLAP services or processes are NOT started. a. For UNIX - UNIX processes do not start automatically. Do not start the processes manually until after you execute the license program in Step 3. Refer to Chapter 4 of the OLAP Setup and User's Guide for information about starting and stopping OLAP Starter Kit on UNIX platforms. b. For Windows - Windows services start automatically. You must stop any OLAP services that have started automatically using the directions in Chapter 3 of the OLAP Setup and User's Guide. 3. Issue the following command: \bin\db2licm.exe -o 4. Start OLAP services or processes. 2.6 Uninstallation Notes When upgrading or uninstalling the DB2 product(s) on a Windows NT system, it is recommended that you manually shut down all DB2 services and processes on your machine. 3. Service 3.1 Product and Service Technical Library For a complete and up-to-date source of DB2 information, including information on issues discovered after this readme was published, please go to the following web site: DB2 Product and Service Technical Library: http://www.ibm.com/software/data/db2/library DB2 Universal Database and DB2 Connect Online Support: http://www.ibm.com/software/data/db2/udb/winos2unix/support DB2 Universal Database and DB2 Connect Online Support - Technical Library: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib.d2w/report 3.2 Customer Support To speak to an IBM representative regarding assistance with this product, please call 1-800-237-5511. Customer support is also provided via Electronic Question and Answer (Q&A) forums. These forums are accessible through CompuServe, IBMLink, and Usenet Newsgroup. (1) CompuServe - To access the forums on CompuServe, execute GO IBMDB2. - If you don't have access to CompuServe, call 1-800-848-8199 for membership information in Canada or the US. (2) Usenet Newsgroup: comp.databases.ibm-db2 - This Internet Newsgroup is a general forum for discussing questions and/or problems encountered using the DB2 family of products. (3) (IBMLink) Talklink OS/2 BBS - To access the forums on IBMLink, go to the OS2BBS section. - If you don't have access IBMLink, call 1-800-547-1283 for membership information in Canada or the US. 3.3 Corrective Service Corrective service can be downloaded electronically from by either: (1) FTP to anonymous server ftp.software.ibm.com. Go to ps/products/db2/fixes/%L/%P/ where %L is the appropriate locale (e.g. english-us, spanish, german, etc.), and %P is the product name/version (eg. db2ntv71, etc.). (2) Use a Web browser to connect to the DB2 UDB and DB2 Connect Online Support Page at: http://www.ibm.com/software/data/db2/udb/winos2unix/support (3) On CompuServe, execute GO IBMDB2. Then go to the appropriate library to find the FixPak. (4) On IBM PCC BBS (in US), call (919) 517-0001 (in Raleigh, North Carolina) and then type "db2" on the main menu to find the FixPaks. If you do not have access to any of the above locations, please call 1-800-992-4777 to request these FixPaks be sent to you in the mail. For countries other than US and Canada, please contact your local DB2 Customer Service number for assistance in obtaining them. --------------------------------------------------------------------------- * are trademarks or registered trademarks of IBM Corporation. ** are trademarks or registered trademarks of their respective owners. --------------------------------------------------------------------------- *************************************************************************** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 2000. ** ALL RIGHTS RESERVED. ** ***************************************************************************