Welcome to DB2* for SCO OpenServer** V2.1.2 U458633 +--- NOTE! ----------------------------------------------------------+ | | Set the font to monospace for better viewing of this README. | | If you have received interim fixes from IBM support after 98/06/27, | then you must contact IBM support instead of installing this FixPak, to | request an updated version of the interim fixes. By doing this, you | are assured that your system is in a consistent state and no interim | fixes are lost. | +--------------------------------------------------------------------+ This README file contains information for the following products and components: IBM DB2 for SCO OpenServer (DB2 for SCO OpenServer) IBM DB2 Client Application Enabler for SCO OpenServer IBM DB2 Software Developer's Kit for SCO OpenServer IBM Distributed Database Connection Services Multi-User Gateway for SCO OpenServer (DDCS Multi-User Gateway for SCO OpenServer) ------------------------------------------------------------------ 1 Contents of FixPak 2 Before You Install 2.1 Patch for DB2 for SCO OpenServer 2.2 Kernel Configuration Parameters 2.3 Additional Kernel Parameter Tuning 2.4 Base Directory for DB2 for SCO OpenServer 2.5 APAR IX69806 Information 3 Migration Considerations 3.1 Rebinding bind files - IMPORTANT 3.1.1 Rebinding to DB2 common server databases 3.1.2 Rebinding to DB2 DRDA databases 3.1.3 Rebinding Specific Packages 4 Getting Help 5 Miscellaneous 5.1 DB2 Family Newsletter 5.2 Customer Support 5.3 Corrective Service ================================================================== 2 Before You Install 2.1 Patch for DB2 for SCO OpenServer When running DB2 for SCO OpenServer on SCO OpenServer 5.0.0 and SCO OpenServer Development System 5.0.0, you must install the following patches, which are available via anonymous FTP from the ftp.sco.com: Patch Path on internet site ftp.sco.com ===================== ================================== SCO OpenServer 5.0.0d /Supplements/rs500d/* DLLs for SCO OpenServer /TLS/tls597.* Advanced Hardware Supplement /AHS/5.0/sco/5.2/* (recommended) Before applying these patches, the OpenServer and the OpenServer Development System should be installed. 2.2 Kernel Configuration Parameters To run DB2 for SCO OpenServer, you may have to update some kernel configuration parameters. We recommend the following minimum values. The minimum kernel configuration parameters for a 128MB - 256MB system are as follows: MSGSSZ 64 SEMMAP 200 SEMMNI 600 SEMMNS 600 SEMMNU 200 MAXUP 200 SHMMAX 256000000 SHMMNI 512 The minimum kernel configuration parameters for a 32MB - 128MB system are as follows: MSGSSZ 64 SEMMAP 100 SEMMNI 100 SEMMNS 100 SEMMNU 100 MAXUP 200 SHMMAX 128000000 2.3 Additional Kernel Parameter Tuning The DB2 for SCO OpenServer and DDCS for SCO OpenServer installation manuals indicate several kernel parameters which need to be increased to accommodate the DB2 server. If the server will be running many simultaneous database connections, the following parameters should be increased. For example: SEMMAP 200 SEMMNI 600 SEMMNS 600 SEMMNU 200 SHMMNI 150 Such values may cause a warning to be displayed when the SCO OpenServer kernel is relinked, since the above semaphore values (SEMXXX) are beyond the maximum values listed in /etc/conf/cf.d/mtune. The Santa Cruz Corporation, Inc. has confirmed that the above values are acceptable. You can suppress the warning "mtune" and increasing the listed maximum values for these parameters. 2.4 Base Directory for DB2 for SCO OpenServer The base directory for all DB2 for SCO OpenServer products and packages must be the same. The default base directory is "/usr". 2.5 APAR IX69806 Information In order to use the fix for APAR IX69806, the keyword "PATCH2=7" (without the quotes) needs to be added to DB2CLI.INI under the data source section. Note that this APAR needs to be applied to handle graphic data type correctly in double byte environments when using certain applications. 3.0 Migration Considerations If you created instances using a previous version of DB2 for SCO OpenServer, you need to do the following : 1. Logon as root 2. For each instance: o Logon as sysadm for the instance o Stop all your DB2 applications o Stop the database manager (db2stop) o Stop all command line processor sessions (Issue a db2 terminate command for in each session that was running the command line processor. This step has to be performed by every user who has an active session that has used the command line processor). o Stop the DB2 license daemon (issue the db2licd end command) Logon as root and do the following: 1. Remove the previous version of all the DB2 products. 2. Install DB2 for SCO OpenServer Version 2.1.2 using the procedure described in the "Installation and Operation Guide". 3. For each instance on the machine run the command: /usr/IBMdb2/V2.1/instance/db2iupdt instance (where "instance" is the name of the instance. You can get a list of all the instances on the machine by issuing the /usr/IBMdb2/V2.1/instance/db2ilist command) Note: It is recommended that all instances using Beta version of the DB2 for SCO products be removed. New instances should be created using "db2icrt" command. 3.1 Rebinding bind files - IMPORTANT Due to the new bind (.bnd) files that have been shipped with this FixPak, you will need to rebind your DB2 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. 3.1.1 Rebinding to DB2 common server databases After applying fixes, you must do the following: - At a command prompt: db2 terminate db2 CONNECT TO db2 BIND /@db2ubind.lst BLOCKING ALL GRANT PUBLIC db2 BIND /@db2cli.lst BLOCKING ALL GRANT PUBLIC db2 terminate or, - At the DB2 command line: TERMINATE CONNECT TO BIND /@db2ubind.lst BLOCKING ALL GRANT PUBLIC BIND /@db2cli.lst BLOCKING ALL GRANT PUBLIC TERMINATE Where is the name of a database to which the utilities should be bound, and where is the full path name of the directory where the bind files are located, such as /sqllib/bnd. 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. If is a DB2 v1.x database, do not bind db2cli.lst. Instead, use the db2cliv1.lst or specifically bind db2clics.bnd, db2cliur.bnd, db2clirr.bnd, and db2cliv1.bnd individually. 3.1.2 Rebinding to DRDA databases If you are using DDCS to connect to host databases, you will also need to bind the new bind files to the host. As above, use the DB2 Command Line Processor to connect to the host database, and then bind the utilities as follows: HOST COMMAND ======= =================================================== MVS BIND /@ddcsmvs.lst BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE VM BIND /@ddcsvm.lst BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE VSE BIND /@ddcsvse.lst BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE OS400 BIND /@ddcs400.lst BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE Please refer to Chapter 4 "Binding Applications and Utilities" of the DDCS User's Guide for a list of what bind files are used for your specific client operating system. If a bind file changes but your clients do not use that bind file, you do not need to re-bind it. 3.1.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). - At a command prompt: db2 terminate db2 CONNECT TO db2 BIND / BLOCKING ALL GRANT PUBLIC db2 terminate or, - At the DB2 command line: TERMINATE CONNECT TO BIND / BLOCKING ALL GRANT PUBLIC TERMINATE 4.0 Getting Help Books for DB2 for SCO OpenServer are available on a separate directory on the CD-ROM. You can view these books using the "scohelp" command even without installing any of the SCO products. To view these books, use the following command: scohelp //doc//html/db2list.html where is the mount directory for the CD-ROM and represents the locale name For example, if the CD-ROM is mounted as /cdrom, you can view the English version of the books using the following command: scohelp /cdrom/doc/en_US/html/db2list.html 5 Miscellane