*********************************************************************** ** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1996. ** ** ALL RIGHTS RESERVED. ** ** ** *********************************************************************** Welcome to DB2* for SCO OpenServer** Version 2.1.2 1.0 Before You Install ------------------------ This README file contains information for the following products and components: o IBM DB2 for SCO OpenServer (DB2 for SCO OpenServer) o IBM DB2 Client Application Enabler for SCO OpenServer o IBM DB2 Software Developer's Kit for SCO OpenServer o IBM Distributed Database Connection Services Multi-User Gateway for SCO OpenServer (DDCS Multi-User Gateway for SCO OpenServer) 1.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. 1.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 1.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. 1.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.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.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 4.0 Late Breaking News ------------------------ After DB2 is installed, you can view the "Late Breaking News" README for information on DB2 for SCO OpenServer products. Use the "scohelp" command. 5.0 Trademarks ---------------- * are trademarks or registered trademarks of IBM Corporation. ** are trademarks or registered trademarks of their respective owners. ------------------------------------------------------------------- *********************************************************************** ** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1996. ** ** ALL RIGHTS RESERVED. ** ** ** ***********************************************************************