8
Administering the Gateway

Read this chapter to understand how to administer your gateway either by using the Oracle Gateway Monitor or by entering commands at the command line prompt. It contains the following sections:

Overview of the Oracle Gateway Monitor

The Oracle Gateway Monitor is a facility provided with the Oracle Transparent Gateway for DB2/400 that allows a single interface to perform these functions:

start and stop an Oracle gateway instance
work with Oracle gateway jobs
start the TCP/IP listener job
display the gateway call stack
work with the gateway job locks
display the open files of the gateway

Starting the Oracle Gateway Monitor

In order to execute the Oracle gateway monitor, you must log on to the gateway instance user ID and have the gateway instance library included in your library list. To start the Oracle gateway monitor, enter this command:

ORAMON

The main menu for the Oracle Gateway Monitor is displayed as shown in Figure 8-1.

Figure 8-1 Monitor Oracle Subsystems

________________________________________________________________________________
 Monitor Oracle Subsystems
                                                            System:  AS400A

 Position to _____________  Update frequency  *OFF
                                              ----

   Type Options, press Enter.
      2=Start   4=End   5=Work with   7=Listen   10=Display call stack
      11=Work with locks   14=Display open files

                                                  Job      Aux   Aux    CPU
   Option   Name               Type      Status   Number   I/O    KB    Secs
   -        ORACLE             SBS       ACTV                0     0      .0
   -        LISTENER           LIS       SELW     015826   564  3386     2.8
   -        RUNORAGTP           PJ       PSRW     015823   124  3725     1.6
   -        RUNORAGTTP          PJ       PSRW     015822   138  3737     1.5


 F1=Help   F2=Change list   F3=Exit   F5=Refresh   F8=Start auto update
________________________________________________________________________________

The columns in the panel of Figure 8-1 represent the following:

Option	is used to perform various functions on subsystems and jobs. Enter an option number next to the subsystem or job name and then press ENTER. You can select options for more than one subsystem or job at a time. The option numbers are listed in Figure 8-1.
Name	displays the name(s) of Oracle subsystems and jobs.
Type	is the type of entry for this line: ASJ- automatically started job LIS- listener PJ- pre-started job waiting for start request SBS- subsystem SRV- server job UNK- unknown
Status	is the status of the subsystem or job associated with the line. For subsystems (type SBS): ACTV - active subsystem ERROR- error while determining subsystem status INACTV- inactive subsystem NOAUTH- user has no authorization to start or stop subsystem For jobs, refer to the help information for the Status column of the WRKACTJOB panel.
Job Number	is the OS/400 job number for job related lines; it is blank for subsystem lines.
Aux I/O	is the total number of auxiliary storage I/O operations performed.
Aux KB	is the current amount of auxiliary storage occupied by the job in kilobytes (units of 1024 bytes).
CPU Secs	is the total CPU time used, in seconds.

To display specific gateway subsystems and jobs, you must enter the subsystem into the Oracle gateway monitor subsystem by pressing [PF2]. This displays a panel that allows you to enter the name of the Oracle gateway subsystems. The panel in Figure 8-1 shows a single gateway subsystem with a single listener and two prestarted gateway jobs.

To work with a specific gateway subsystem or job, you must enter an option in the Option field next to the subsystem or job displayed on the main panel.

In Figure 8-1 the Update frequency field is turned off. This means that no updates of the information are displayed until you press [PF5]. If you want the screen to be updated periodically, you need to press [PF8]. The default update refresh is 30 seconds, but you can set the value between 30 and 600 seconds.

If help is needed at any time, pressing [PF1] on any of the panels displays more information about a specific panel.

Starting and Stopping the Gateway

Entering a 2 in the Option field on the main panel allows you to start a gateway subsystem or job. ACTV displays in the STATUS field when the gateway subsystem is started. In order to start the gateway subsystem, you must be authorized to use the STRSBS command.

To stop the gateway subsystem, use the Option field next to the subsystem or job you want to shut down and enter a 4. This ends the gateway subsystem or job specified. When the gateway subsystem has shut down, INACTV displays in the field next to the subsystem or job that ended. You must be authorized to use the ENDSBS command to shut down the gateway.

Working with Oracle Gateway Jobs

To work with gateway jobs, specify option 5 next to the job. This displays the AS/400 Work with Jobs menu to work with a specific gateway job.

Starting and Stopping the Gateway Using the Command Line

An instance of the Oracle Transparent Gateway for DB2/400 runs within an OS/400 subsystem. All jobs relating to that instance run within the subsystem. You use the STRSBS command to start a subsystem. For example, to start an instance of a gateway called ORACLE, you enter the following command:

STRSBS ORACLE/ORACLE

where the first ORACLE is a library name and the second ORACLE is a subsystem description.

To stop a gateway you must end the subsystem using the ENDSBS command. For example, to stop a gateway called ORACLE and immediately end all jobs within the ORACLE subsystem, and stop the subsystem itself, you enter the following command:

ENDSBS ORACLE OPTION(*IMMED)

Starting the TCP/IP Listener

Specify option 7 in the Option field next to the gateway subsystem name if you want to start the gateway listener. The gateway listener is identified by LIS in the TYPE field displayed on the main menu.

Displaying the Gateway Call Stack

Displaying the gateway call stack is not needed for most installations, but might be requested by Oracle Support Services during problem isolation and determination. Entering option 10 in the Option field displays a call stack for a specific job.

Working with Gateway Job Locks

Specify option 11 in the Option field next to a specific job to display and work with object locks held by the gateway. This option displays the AS/400 Work with Job Locks panel.

Displaying Open Files

Specify option 14 in the Option field next to a specific job to show the files open for that specific job. This option displays the AS/400 Display Open Files panel.

Gateway Security

The Oracle user ID and password are passed over the database link to the gateway to authorize gateway users to DB2/400 objects. If the CONNECT TO clause is specified when creating the database link, then the user ID and password that are sent to the gateway are those specified in this clause. If the CONNECT TO clause is omitted from the database link specification, then the Oracle user ID and password that are using the database link are passed to the gateway for authorization.

Caution:

You must keep the gateway recovery password synchronized with the AS/400. The gateway recovery user ID & password must be valid to the AS/400 at all times. If the recovery password is not valid (if it expires, for example), then an in-doubt transaction occurs, and the Oracle database alert log receives error-1017 (invalid user ID or password). The CHGRECOPRF command is used to change the recovery profile parameters (including recovery user ID and password).

For more information about using CHGRECOPRF, refer to "CHGRECOPRF, Change Recovery Profile Parameters"

8 Administering the Gateway