This chapter provides instructions for installing preventive service and corrective service for DB2 RXSQL. It also contains instructions for reloading packages and HELP text.
Preventive service, the most common form of service, is shipped on a VM-PUT tape. If you receive a VM-PUT tape that contains DB2 RXSQL preventive service, "Installing Preventive Service".
Corrective service is provided only in special situations. If you receive an DB2 RXSQL corrective service tape, instructions for its use are available from your IBM Support Center. Refer to "Installing Corrective Service" for specific instructions.
If DB2 RXSQL requires service, the MAINT machine, or its equivalent, must have read/write access to a minidisk with free space equivalent to at least 5 cylinders of an IBM 3380 storage device. Figure 18 shows the minimum free space required for the work minidisk when the block size is 4096 bytes.
Figure 18. Database Tables Used for DB2 RXSQL HELP Text
| Minidisk | Virtual Address | Access Mode | 3350 Cylinders | 3375 Cylinders | 3380 Cylinders | 3390 Cylinders | 9345 Cylinders | FB-512 Blocks |
|---|---|---|---|---|---|---|---|---|
| MAINT machine: Work minidisk for service | 194 or 191 | A or C | 7 | 8 | 5 | 4 | 5 | 6000 |
To apply DB2 RXSQL preventive service from a VM-PUT tape, use the VM VMSERV EXEC
and the DB2 RXSQL preventive service EXEC. The name of the preventive service EXEC is listed in the Program Service section of the Program Directory. The DB2 RXSQL files on a VM-PUT tape are described in the VM-PUT document that comes with the tape.
To install preventive service, you must do the following:
If you installed DB2 RXSQL on DB2 Server for VM disks, the defaults are:
If you installed DB2 RXSQL on separate disks, the defaults are:
The DB2 RXSQL preventive service EXEC performs the following functions:
After installing preventive service, you should verify that DB2 RXSQL is correctly installed by following the procedure outlined in "Installation Verification".
If you receive a corrective service tape, you also receive instructions for its use from your IBM Support Center. You must follow these instructions to copy the contents of the tape to the MAINT machine's A-disk, and then use the ELOSCOR EXEC to install the corrective service.
You will be using the MAINT machine to apply corrective service. Access the MAINT work minidisk as file mode A. Type the following statements to load the service files supplied by IBM to this minidisk:
ACCESS cuu A
The cuu is normally specified as 194 or 191.
ATTACH rdev TO MAINT AS 181
The distribution tape must be mounted on the device defined as virtual address 181.
VMFPLC2 REW
VMFPLC2 LOAD * * A (EOF 1
Before proceeding and as instructed by your IBM Support Center, you must rename the file types of the corrective service files that you just loaded from the tape.
You are now ready to use the ELOSCOR EXEC to install corrective service.
This EXEC is supplied with DB2 RXSQL and resides on the service disk. It applies the service based on the contents of the corrective service tape. It does not use service files for other IBM products. These extra files remain on the MAINT work minidisk.
The ELOSCOR EXEC also determines whether or not a link-edit is necessary. If it is, the ELOSCOR EXEC calls the ELOLKED EXEC. For information on the prerequisites for running the ELOLKED EXEC, refer to "The ELOLKED EXEC".
If the package has been serviced, the ELOSCOR EXEC issues a message indicating that the DB2 RXSQL package must be reloaded. You must reload this package into each application server on which DB2 RXSQL was installed. Follow the instructions in "Reloading the DB2 RXSQL Package".
If the HELP text has been serviced, the ELOSCOR EXEC issues a message indicating that the HELP text must be reinstalled. You must reinstall this HELP text in each application server in which DB2 RXSQL was installed. Follow the instructions in "Reloading HELP Text".
To apply service to DB2 RXSQL, you must have write access to the DB2 RXSQL production and service disks and read access to the DB2 production and service disks. The procedure you must follow to access the appropriate disks depends on whether DB2 RXSQL is installed on minidisks or in SFS directories. The procedure to follow in each case is described in the following sections.
If DB2 RXSQL is installed on minidisks, the disks that you must access before applying corrective service depends on whether or not DB2 RXSQL was installed on the same disks as DB2, as shown in Figure 19.
Figure 19. Accessing DB2 RXSQL and DB2 Disks To Apply Corrective Service
| Disks to Access | DB2 RXSQL Installed on DB2 Minidisks | DB2 RXSQL Installed on Separate Minidisks | |
|---|---|---|---|
| DB2 Product is on Minidisk | DB2 Product is in SFS Directories | ||
| DB2 production minidisk | X | X | |
| DB2 service minidisk | X | X | |
| DB2 RXSQL production minidisk | | X | X |
| DB2 RXSQL service minidisk | | X | X |
| DB2 production SFS directory | | | X |
| DB2 service SFS directory | | | X |
If DB2 RXSQL was installed on DB2 minidisks, specify the following commands to link and access the DB2 production and service minidisks:
LINK SQLMACH 195 195 W writepw ACCESS 195 P
LINK SQLMACH 193 193 W writepw ACCESS 193 V
If DB2 RXSQL was not installed on DB2 minidisks, specify the following commands to link and access the DB2 RXSQL production and service minidisks and the DB2 production and service disks:
LINK SQLMACH 198 198 W writepw ACCESS 198 P
LINK SQLMACH 199 199 W writepw ACCESS 199 V
LINK SQLMACH 195 195 RR LINK SQLMACH 193 193 RR ACCESS 195 Q ACCESS 193 W
ACCESS VMSYS:SQLMACH.SQL.PRODUCTION Q ACCESS VMSYS:SQLMACH.SQL.SERVICE W
If DB2 RXSQL is installed in SFS directories, the disks that you must access before applying corrective service depends on whether or not DB2 RXSQL and the DB2 product are installed on the same disks, as shown in Figure 20:
Figure 20. Accessing DB2 RXSQL and DB2 Disks To Apply Corrective Service
| Disks to Access | DB2 RXSQL Installed in DB2 SFS Directories | DB2 RXSQL Installed in Separate SFS Directories | |
|---|---|---|---|
| DB2 Product is on Minidisk | DB2 Product is in SFS Directories | ||
| DB2 production SFS directory | X | | X |
| DB2 service SFS directory | X | | X |
| DB2 RXSQL production SFS directory | | X | X |
| DB2 RXSQL service SFS directory | | X | X |
| DB2 production minidisk | | X | |
| DB2 service minidisk | | X | |
If DB2 RXSQL was installed on DB2 SFS directories, specify the following commands to access the DB2 production and service SFS directories:
ACCESS VMSYS:SQLMACH.SQL.PRODUCTION P (FORCERW
ACCESS VMSYS:SQLMACH.SQL.SERVICE V (FORCERW
If DB2 RXSQL was installed on separate SFS directories, specify the following commands to access the DB2 RXSQL production and service SFS directories and the DB2 production and service disks:
ACCESS VMSYS:SQLMACH.DB2 RXSQL.PRODUCTION P (FORCERW
ACCESS VMSYS:SQLMACH.DB2 RXSQL.SERVICE V (FORCERW
ACCESS VMSYS:SQLMACH.SQL.PRODUCTION Q ACCESS VMSYS:SQLMACH.SQL.SERVICE W
LINK SQLMACH 195 195 RR LINK SQLMACH 193 193 RR ACCESS 195 Q ACCESS 193 W
To call the ELOSCOR EXEC to apply the DB2 RXSQL corrective service, type:
ELOSCOR
For information on running the ELOSCOR EXEC, refer to "The ELOSCOR EXEC".
Release any SFS directories to which you are linked and release and detach any minidisks to which you are linked.
For a description of the CP commands described in this section, refer to the VM/ESA: CP Command and Utility Reference manual for your VM operating system. For a description of the CMS commands described in this section, refer to the VM/ESA: CMS Command Reference manual for your VM operating system.
When you are installing preventive service or corrective service, the preventive service EXEC or the ELOSCOR EXEC may issue a request to reinstall the HELP text in each DB2 application server in which DB2 RXSQL was installed. As instructed, invoke the ELOSHLP EXEC for each DB2 application server into which DB2 RXSQL was installed. Refer to "The ELOSHLP EXEC" for instructions on running this EXEC before using it.
The ELOSHLP EXEC is supplied with DB2 RXSQL and resides on the DB2 RXSQL service disk. The ELOSHLP EXEC services the DB2 RXSQL secondary-level HELP tables. It will service the AMENG HELP text as well as any national language support language that has been installed.
When you are installing preventive service or corrective service, the preventive service EXEC or the ELOSCOR EXEC may issue a request to reload the DB2 RXSQL package into each application server in which DB2 RXSQL was installed.
Use the ELOAMOD EXEC supplied with DB2 RXSQL to load DB2 RXSQL packages into an DB2 application server. For more information about the use of the ELOAMOD EXEC, refer to "The ELOAMOD EXEC".