Quick Beginnings for DB2 Universal Database for UNIX

Installing DB2 Version 5 Clients

To install the DB2 Client Application Enabler on AIX, HP-UX, SCO UnixWare 7, Silicon Graphics IRIX, and Solaris systems, perform the following steps:

Step 1. Update Kernel Configuration Parameters

To run DB2 Client Application Enabler for UNIX systems, you may have to update some kernel configuration parameters.

This step is not required on AIX. If you are installing an AIX client, skip this step and go to Step 2. Mount the DB2 Client Application Enablers CD-ROM.

Recommended Values for HP-UX Version 10 and Version 11

Table 13 lists the recommended values for the specified HP-UX kernel configuration parameters. These values are valid for HP-UX 10 and HP-UX 11.

Table 13. HP-UX Kernel Configuration Parameters (Recommended Values)

Kernel Parameter	Recommended Value
msgseg msgmnb msgmax msgssz	8192 65535 (1) 65535 (1) 16

Notes:

1. Parameters msgmnb and msgmax must be set to 65535.

2. To maintain the interdependency among kernel parameters, change parameters in the same sequence in which they appear in Table 13.

To change a value:

1. Enter the sam command to start the System Administration Manager (SAM) program.

2. Double-click on the Kernel Configuration icon.

3. Double-click on the Configurable Parameters icon.

4. Double-click on the parameter that you want to change and enter the new value in the Formula/Value field.

5. Click on OK.

   The HP-UX operating system automatically reboots after you change the values for the kernel configuration parameters.

Go to Step 2. Mount the DB2 Client Application Enablers CD-ROM to continue with the installation.

Recommended Values for SCO UnixWare 7

Table 14 lists the recommended values for the specified SCO UnixWare 7 kernel configuration parameters.

Table 14. SCO UnixWare 7 Kernel Configuration Parameters (Recommended Values)

Kernel Parameter	Recommended Value
msgmax msgmnb msgssz msgmni	65535 (1) 65535 (1) 524288 256

Notes:

1. Parameters msgmax and msgmnb should be set at least to 65535.

2. To maintain the interdependency among kernel parameters, change parameters in the same sequence in which they appear in the preceding table.

To change a value, do the following:

1. Enter the scoadmin command to start the System Administration tool.

2. Double-click on the System folder.

3. Double-click on the System Tuner icon.

4. Click on the drop down box and select the Inter-Process Communication (IPC) Parameters.

5. Select the parameter to be changed and enter the new value.

6. Click on OK when you have finished changing all the parameters.

7. Click on the Yes push button to rebuild the kernel.

8. Reboot the system so that the changes can take effect.

Go to Step 2. Mount the DB2 Client Application Enablers CD-ROM to continue with the installation.

Recommended Values for Solaris

Table 15 lists the recommended values for the specified Solaris kernel configuration parameters.

Table 15. Solaris Kernel Configuration Parameters (Recommended Values)

Kernel Parameter	Recommended Value
msgsys:msginfo_msgmax msgsys:msginfo_msgmnb msgsys:msginfo_msgseg msgsys:msginfo_msgssz	65535 (1) 65535 (1) 8192 16

Notes:

1. Parameters msgsys:msginfo_msgmnb and msgsys:msginfo_msgmax must be set to 65535.

To set a kernel parameter, add a line at the end of the /etc/system file as follows:

   set parameter_name = value

where parameter_name represents the parameter you want to change.

For example, to set the value of parameter msgsys:msginfo_msgmax, add the following line to the end of the /etc/system file:

   set msgsys:msginfo_msgmax = 65535

After changing the kernel parameters, reboot the system so that the changes can take effect.

Go to Step 2. Mount the DB2 Client Application Enablers CD-ROM to continue with the installation.

Step 2. Mount the DB2 Client Application Enablers CD-ROM

To install DB2 Client Application Enabler using the DB2 Installer, you must first mount the CD-ROM. Once you have mounted the CD-ROM, you can start installing the DB2 products.

Mounting on AIX Systems

Perform the following steps to mount the CD-ROM on AIX operating systems:

1. Log in as user with root authority.

2. Insert the DB2 Client Application Enablers CD-ROM in the drive.

3. Create a directory to mount the CD-ROM by entering the following command:

      mkdir -p /cdrom
   

   where cdrom is the CD-ROM mount directory.

4. Allocate a CD-ROM file system by entering the following command:

      smitty storage
   

5. Select File Systems.

6. Select Add / Change / Show / Delete File Systems.

7. Select CDROM File Systems.

8. Select Add CDROM File System.

9. Select Device Name.
   

   Device names for CD-ROM file systems must be unique. If there is a duplicate device name, you may need to delete a previously-defined CD-ROM file system or use another name for your directory.

10. In the pop-up window, enter /cdrom as the mount point.

11. Mount the CD-ROM file system by entering the following command:

       smit mountfs
    

12. Select the FileSystem name. For example, the name could be /dev/cd0.

13. Select the Directory name, /cdrom.

14. Select the Type of filesystem, cdrfs.

15. Set the Mount as READ-ONLY system to Yes.

16. Log off.

Go to Step 3. Perform the Installation to continue with the installation.

Mounting on HP-UX Systems

Perform the following steps to mount the CD-ROM on HP-UX operating systems:

1. Log in as user with root authority.

2. Insert the CD-ROM in the drive and mount it as in the following example:

       mkdir /cdrom
       /usr/sbin/mount /dev/dsk/c0t2d0 /cdrom
   

   where /cdrom is the CD-ROM mount directory.

3. Log out.

The CD-ROM may also be mounted using the System Administration (SAM) tool. Consult your HP-UX documentation for more information about SAM.

Go to Step 3. Perform the Installation to continue with the installation.

Mounting on SCO UnixWare 7

Perform the following steps to mount the CD-ROM on SCO UnixWare 7 operating systems:

1. Log in as user with root authority.

2. Insert the DB2 Client Application Enablers CD-ROM into the drive and mount it. For example, to mount the CD-ROM as /cdrom, type:

        mount -F cdfs -o ro /dev/cdrom/c0b0t5l0 /cdrom
   

   where c0b0t5l0 is the device name found under /dev/cdrom directory and varies with the particular hardware on the system.

3. Log out.

Go to Step 3. Perform the Installation to continue with the installation.

Mounting on Silicon Graphics IRIX

Perform the following steps to mount the CD-ROM on Silicon Graphics IRIX operating systems:

1. Log in as user with root authority.

2. Insert the DB2 Client Application Enablers CD-ROM into the drive and mount it using the mount command as follows:

      mount -t iso9660 device mount_point
   

   For example, to mount the CD-ROM as /cdrom, enter the following commands:

      mkdir /cdrom
      mount -t iso9660  /dev/scsi/sc0d7l0 /cdrom
   

3. Log out.

Go to Step 3. Perform the Installation to continue with the installation.

Mounting on Solaris Systems

Perform the following steps to mount the CD-ROM on Solaris operating systems:

1. Log in as user with root authority.

2. If the Volume Manager is not running on your system, enter the following commands to mount the CD-ROM:

      mkdir -p /cdrom/unnamed_cdrom
      mount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom/unnamed_cdrom
   

   where /cdrom/unnamed_cdrom is the CD-ROM mount directory.
   

   If you are mounting the CD-ROM drive from a remote system using NFS, the CD-ROM file system on the remote machine must be exported with root access. You must also mount that file system with root access on the local machine.

   If the Volume Manager (vold) is running on your system, the CD-ROM is automatically mounted as:

      /cdrom/unnamed_cdrom
   

3. Log out.

Go to Step 3. Perform the Installation to continue with the installation.

Step 3. Perform the Installation

After you mount the CD-ROM file system, use the DB2 Installer program to install the DB2 products.

If you are installing the DB2 Client Application Enabler from a remote server, it is better to use the telnet command to open a telnet session instead of using the rlogin command to connect to your remote server.

1. Log in as user with root authority.

2. Insert the DB2 Client Application Enablers CD-ROM in the drive and if required, mount the CD-ROM. Refer to Step 2. Mount the DB2 Client Application Enablers CD-ROM if you need to mount the CD-ROM.

3. Change to the directory where the DB2 install CD-ROM is mounted and run the following command:

      ./db2setup
   

4. DB2 install images are available in the following directories (assuming that the mount point for the CD-ROM is /cdrom):
   • On AIX:

        cd /cdrom/db2/aix
     

   • On HP-UX:

        cd /cdrom/db2/hpux10 (for HP-UX Version 10)
        cd /cdrom/db2/hpux11 (for HP-UX Version 11)
     

   • On SCO UnixWare 7:

        cd /cdrom/db2/scouw
     

   • On SGI:

        cd /cdrom/db2/sgi
     

   • On Solaris:

        cd /cdrom/unnamed_cdrom/db2/solaris
     

5. To install the client, enter the following commands:

      cd /cdrom
      ./db2setup
   

   The installation program will proceed to install the appropriate client on your workstation.
   

   It will take some time for the DB2 Installer program to start up, as it is scanning your system for information.

   
   
   

   Note:

   Your screen will be different if you have already installed DB2 Version 5 products on your system. See Chapter 4. Installing Additional Products and Creating Additional Instances for more information.

6. From the product list on the Install DB2 V5 window, select the DB2 products that you want to install.

   To display the required and optional components for a product that you want to install, select Customize. The optional components that are most typically used are pre-selected for you.
   

   To refresh the current screen, press the F5 key or Ctrl+L.

   When you have finished your selection, select OK. To undo any selections you made, select Default. The Create DB2 Services window opens.
   

   Go to step 9 if you do not want to create a DB2 Instance at this time.

7. At the Create DB2 Services window, select the Create a DB2 Instance option. The DB2 Instance window opens:
   
   

   You can use the default values displayed at the DB2 Instance window or change them. To change the default User ID for the instance, deselect Use default UID and enter a new value for the User ID.

8. Complete the fields and select OK.

9. Select OK and the Summary Report window opens. The report lists the installable items as well as the location of the installation log file.

10. Select the Summary Report field and use the Up or Down arrow keys to review the Summary Report. If the selections are not correct, press the ESC or F3 key, to return to the previous screen. Otherwise select Continue to start the installation.

11. When the installation is complete, use the Up or Down arrow keys to review the Status Report. Select View Log to view the installation log file. Select OK to close the Status Report screen.

12. Select Close from the DB2 Installer screen to terminate the DB2 Installer program.

After the installation is complete, the software is installed in the DB2DIR directory,

	where DB2DIR	= /usr/lpp/db2_05_00	on AIX
		= /opt/IBMdb2/V5.0	on HP-UX, SCO UnixWare 7, SGI IRIX, or Solaris

Proceed to Chapter 14. Configuring Client-to-Server Communications Using the Command Line Processor.

[ DB2 List of Books | Search the DB2 Books ]