DB2 REXX SQL for VM/ESA(R): Installation and Reference


Appendix B. Installation and Service EXECs

This appendix provides instructions for running the installation and service EXECs listed below.

The installation EXECs are:

|I5697ELO
Calls ELOLANG EXEC to load the DB2 RXSQL message repository.

Installs DB2 RXSQL on minidisks or in SFS directories.

Calls ELOLKED EXEC to link-edit DB2 RXSQL.

ELOAMOD
Calls ELOLANG EXEC to load the DB2 RXSQL message repository.

Loads the DB2 RXSQL package into a DB2 Server for VM or non-DB2 Server for VM application server.

ELOHLPLD
Calls ELOLANG EXEC to load the DB2 RXSQL message repository.

Installs DB2 RXSQL secondary-level HELP tables in a DB2 Server for VM application server.

ELOLKED
Calls ELOLANG EXEC to load the DB2 RXSQL message repository.

Link-edits DB2 RXSQL.

The service EXECs are:

ELOSCOR
Applies service depending on the contents of the corrective service tape.

ELOSHLP
Services the secondary level HELP tables.


|The I5697ELO EXEC

The |I5697ELO EXEC installs DB2 RXSQL on minidisks or in SFS directories. It does not format the minidisks on which it is installing DB2 RXSQL. You must ensure that the minidisks can be written to.

Prerequisites

Before running the |I5697ELO EXEC, ensure that:

Authorization

Before running the |I5697ELO EXEC, ensure that you have access to the following disks:

Syntax



>>-I5697ELO----------------------------------------------------><
 

Description

When you run the |I5697ELO EXEC, you must decide whether DB2 RXSQL is to be installed on separate disks or on DB2 Server for VM disks. If you are installing DB2 RXSQL on DB2 Server for VM disks, refer to "Installing DB2 RXSQL on DB2 Server for VM Minidisks or SFS Directories". If not, refer to "Installing DB2 RXSQL on Separate Minidisks or SFS Directories".

Installing DB2 RXSQL on DB2 Server for VM Minidisks or SFS Directories

If you are installing DB2 RXSQL on DB2 Server for VM disks, you are prompted to specify whether the DB2 Server for VM files reside on minidisks or in SFS directories.

The EXEC then displays the following defaults for the DB2 Server for VM production minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 Server for VM production minidisk

 195 
Virtual address of the DB2 Server for VM production minidisk

 WSQL 
Write access password for the DB2 Server for VM production minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 Server for VM files

 SQL.PRODUCTION 
SFS directory name of the DB2 Server for VM production directory.

You must either accept these default values or supply different values.

The EXEC then displays the following defaults for the DB2 Server for VM service minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 Server for VM service minidisk

 193 
Virtual address of the DB2 Server for VM service minidisk

 WSQL 
Write access password for the DB2 Server for VM service minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 Server for VM files

 SQL.SERVICE 
SFS directory name of the DB2 Server for VM service directory.

You must either accept the default values or supply different values.

The DB2 Server for VM production and service disks are then accessed with write access, and the DB2 RXSQL files loaded on the DB2 Server for VM disks.

The |I5697ELO EXEC calls ELOLKED EXEC to do the system link-edit.

A message with a return code of 888 displays when processing is completed. The DB2 RXSQL distribution tape is positioned at the tape mark following the end of the last DB2 RXSQL file on the tape (file 4).

Installing DB2 RXSQL on Separate Minidisks or SFS Directories

If you are installing DB2 RXSQL on separate disks, you are prompted to specify whether the installation is on minidisks or in SFS directories, and whether the DB2 Server for VM system is installed on minidisks or in SFS directories.

The EXEC then displays the following defaults for the DB2 RXSQL production minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 RXSQL production minidisk

 198 
Virtual address of the DB2 RXSQL production minidisk

 WSQL 
Write access password for the DB2 RXSQL production minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 RXSQL files

 RXSQL.PRODUCTION 
SFS directory name of the DB2 RXSQL production directory.

You must either accept the default values or supply different values.

The EXEC then displays the following defaults for the DB2 RXSQL service minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 RXSQL service minidisk

 199 
Virtual address of the service minidisk

 WSQL 
Write access password for the DB2 RXSQL service minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 RXSQL files

 RXSQL.SERVICE 
SFS directory name of the DB2 RXSQL service directory.

You must either accept the default values or supply different values.

The EXEC then displays the following defaults for the DB2 Server for VM production minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 Server for VM production minidisk

 195 
Virtual address of the DB2 Server for VM production minidisk

 RSQL 
Read access password for the DB2 Server for VM production minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 Server for VM files

 SQL.PRODUCTION 
SFS directory name of the DB2 Server for VM production directory.

You must either accept the default values or supply different values.

The EXEC then displays the following defaults for the DB2 Server for VM service minidisk or SFS directory.

For minidisks the defaults are:

 SQLMACH 
User ID of the virtual machine that owns the DB2 Server for VM service minidisk

 193 
Virtual address of the service minidisk

 RSQL 
Read access password for the DB2 Server for VM service minidisk.

For SFS directories the defaults are:

 VMSYS 
File pool ID

 SQLMACH 
SFS directory owner for DB2 Server for VM files

 SQL.SERVICE 
SFS directory name of the DB2 Server for VM service directory.

You must either accept the default values or supply different values.

The DB2 RXSQL production and service minidisks or SFS directories are then accessed with write access, and the DB2 Server for VM production and service minidisks or SFS directories are accessed with read-only access. The DB2 RXSQL files are also loaded on the DB2 RXSQL production and service disks.

The |I5697ELO EXEC calls the ELOLKED EXEC to do the system link-edit.

A message with a return code of 888 displays when processing is completed. The DB2 RXSQL distribution tape is positioned at the tape mark following the end of the last DB2 RXSQL file on the tape (file 4).

|If the I5697ELO EXEC is not successful:

An error message identifies the problem. Correct the error and rerun the |I5697ELO EXEC.
Note:The error message output is spooled to the printer.


The ELOAMOD EXEC

The ELOAMOD EXEC loads the DB2 RXSQL package into a DB2 Server for VM or non-DB2 Server for VM application server. The DB2 RXSQL package has been preprocessed with the blocking option.

Prerequisites

To run the ELOAMOD EXEC, you must have:

Authorization

To run the ELOAMOD EXEC, you must have:

Syntax



>>-EXEC ELOAMOD----+--------------------------+----------------->
                   '-CONnect(SQLDBA/password)-'
 
>-----+-------------------+------------------------------------><
      '-SQLDS(-+-Yes-+--)-'
               '-No--'
 

CONnect
Use the CONnect option if you do not want to be prompted to enter the password for the SQLDBA authorization ID.

This option is valid only when you are loading the DB2 RXSQL package into a DB2 Server for VM application server and are not using the DRDA protocol.

SQLDS
Use the SQLDS option if you do not want to be prompted about whether you are loading the DB2 RXSQL package into a DB2 Server for VM or non-DB2 Server for VM application server.

This option is useful when you are including several ELOAMOD invocations in an EXEC.
Note:SQLDS(YES) should be specified if loading the RXSQL package into a DB2 Server for VSE application server. The DRDA protocol must still be used even when loading RXSQL into a DB2 Server for VSE application server.

Description

If you are loading the DB2 RXSQL package into a non-DB2 application server, you must have DBA authority and the ability to use the DRDA protocol.

If you are loading the DB2 RXSQL package into a DB2 application server, and DRDA protocol is being used, you are prompted to specify whether or not you want to continue. If you want to continue the installation using the DRDA protocol, you must have DBA authority.

ELOAMOD does the following:

The following message is displayed when the package is successfully loaded into the application server.

+--------------------------------------------------------------------------------+
|PORTABLE PACKAGE RELOAD completed successfully.                                 |
+--------------------------------------------------------------------------------+

If the ELOAMOD EXEC is not successful:

An error message identifies the problem. Correct the error and rerun the ELOAMOD EXEC.
Note:The error message output is spooled to the printer.


The ELOHLPLD EXEC

The ELOHLPLD EXEC installs DB2 RXSQL secondary-level HELP tables into the DB2 application server. Secondary-level HELP is not supported on non-DB2 application servers, or when using the DRDA protocol.

Prerequisites

Before running the ELOHLPLD EXEC, ensure that you have the following:

Authorization

To run the ELOHLPLD EXEC, you must have:

Syntax



>>-EXEC ELOHLPLD----+--------------------------+---------------><
                    '-CONnect(SQLDBA/password)-'
 

CONnect
Use the CONnect option if you do not want to be prompted to enter the password for the SQLDBA authorization ID.

Description

ELOHLPLD does the following:

The ELOHELPI EXEC does the following:

The following message is displayed when the HELP tables are successfully installed in the application server:

+--------------------------------------------------------------------------------+
|SECONDARY LEVEL TABLES installed successfully.                                  |
+--------------------------------------------------------------------------------+

If the ELOHLPLD EXEC is not successful:

An error message identifies the problem. Correct the error and rerun the ELOHLPLD EXEC.
Note:The error message output is spooled to the printer.


The ELOLKED EXEC

The ELOLKED EXEC link-edits DB2 RXSQL and creates the following files on the DB2 RXSQL production disk:

You can invoke this EXEC directly from CMS. It is also called from the I5688ELO EXEC, the ELOSCOR EXEC, and the preventive service EXECs.

Prerequisites

To run the ELOLKED EXEC, you must have:

Authorization

To run the ELOLKED EXEC, you must have:

Syntax

This syntax is valid if used from CMS.



>>-ELOLKED----+--------------------------------+---------------><
              '-file_mode_1--+--------------+--'
                             '-file_mode_2--'
 

file_mode_1.
Is the file mode for the DB2 RXSQL production disk. The default file mode is P.

file_mode_2
Is the file mode for the DB2 RXSQL service disk. The default file mode

is V.

Description

The ELOLKED EXEC link-edits DB2 RXSQL.

Performing an RXSQL System Link-Edit

If DB2 RXSQL was installed separately from the DB2 Server for VM files, you must link and access the DB2 RXSQL disks. If DB2 RXSQL was installed with the DB2 Server for VM files, it is unnecessary to link and access the DB2 RXSQL disks. You only have to link and access the DB2 Server for VM disks in write mode.

To perform a DB2 RXSQL system link-edit, do the following:

  1. Access the DB2 RXSQL production disk in write mode.
  2. Access the DB2 RXSQL service disk in read mode.
  3. Access the DB2 production and service disks in read mode.
  4. Type the following to call the ELOLKED EXEC to link-edit DB2 RXSQL:
       ELOLKED file_mode_1 file_mode_2
    
  5. Release and detach the minidisks to which you are linked and release any SFS directories to which you are linked.

    The following message is displayed when the link-edit is successfully completed:

    +--------------------------------------------------------------------------------+
    |DB2 RXSQL link-edit has been performed successfully.                            |
    +--------------------------------------------------------------------------------+

Note:The RXSQL MODULE, EXECSQL MODULE, and RXSQL LOADLIB files are created by this EXEC.

If the ELOLKED EXEC is not successful:

An error message identifies the problem. Correct the error and rerun the ELOLKED EXEC.
Note:The error message output is spooled to the printer.


The ELOSCOR EXEC

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, but leaves them on the MAINT work minidisk.

Authorization

To run the ELOSCOR EXEC, you must have:

Syntax



>>-ELOSCOR-----------------------------------------------------><
 

Description

The ELOSCOR EXEC determines whether a link-edit is necessary. If it is, the ELOSCOR EXEC calls the ELOLKED EXEC. The appropriate link-edits are done and the MODULE and LOADLIB files on the DB2 RXSQL production disk are replaced. For information on the prerequisites and authorization required to run 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 into which DB2 RXSQL was installed. For information on loading the DB2 RXSQL package, refer to "The ELOAMOD EXEC".


The ELOSHLP EXEC

The ELOSHLP EXEC services the DB2 RXSQL secondary-level HELP tables. It services the AMENG HELP text as well as any national language support language that was installed. It is not supported for non-DB2 application servers, or when using the DRDA protocol.

Prerequisites

To run the ELOSHLP EXEC, you must have:

Authorization

To run the ELOSHLP EXEC, you must have:

Syntax



>>-EXEC ELOSHLP----+------------------+------------------------->
                   '-LANGkey(langkey)-'
 
>-----+--------------------------+-----------------------------><
      '-CONnect(SQLDBA/password)-'
 

LANGkey
Use the LANGkey option if you do not want to be prompted to enter the language key for the language being serviced.

CONnect
Use the CONnect option if you do not want to be prompted to enter the password for the SQLDBA authorization ID.

Description

ELOSHLP does the following:

  1. Connects to the application server
  2. Uses the DBS Utility to:

The following message is displayed when the HELP tables are serviced successfully:

+--------------------------------------------------------------------------------+
|SECONDARY LEVEL HELP TABLES serviced successfully.                              |
+--------------------------------------------------------------------------------+

If the ELOSHLP EXEC is not successful:

An error message identifies the problem. If the error occurred during DBS Utility processing, check the console listing for more details. Correct the error and rerun the ELOSHLP EXEC. The LASTING GLOBALV file contains the point at which the service EXEC had an error. Do not modify or delete this file. The temporary files ELO$TXT1 MACRO A and ELO$TXT2 MACRO A may have been created on your A disk. Do not modify or delete them. They will be used when you invoke the ELOSHLP EXEC again to complete the service.
Note:The error message output is spooled to the printer.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]