Reloading Db2 user exits


Select the Reload user exits option from the Operational Assist Menu to display the Reload Subsystem Exits panel, which allows you to reload Db2 user exits without cycling the Db2 subsystem. You can also use the RELOAD command. The RELOAD command loads a new copy of that exit into storage and activates it for immediate use by that Db2 subsystem. The previous copy of the load module (although deactivated) is not removed from storage until the Db2 subsystem terminates.

Reload Subsystem Exits panel

DDTG DBI1 Reload Subsystem Exits     Row 1 of 4
Command ===> ________________________________________________ Scroll ===> PAGE

Select the subsystem exit(s) to be reloaded. Then press Enter.
S =Select

Act Exit Description
 .. DSNJL004 LOG CAPTURE USER EXIT
 .. DSNX@XAC ACCESS CONTROL AUTHORIZATION EXIT
 .. DSNXVDTX LOCAL DATE EXIT
 .. DSNXVTMX LOCAL TIME EXIT
 .. DSN3@ATH CONNECTION USER EXIT
 .. DSN3@SGN SIGN-ON USER EXIT
******************************* Bottom of data *******************************

The following exits are supported by OPERTUNE:

  • DSN3@ATH—the identify authorization connection exit
  • DSN3@SGN—the signon connection exit
  • DSNJL004—the log capture exit
  • DSNX@XAC—the access control authorization exit
  • DSNXVDTX—the local date exit
  • DSNXVTMX—the local time exit

To reload user exits

To reload the user exits, follow these steps:

  1. On the Reload Subsystem Exits panel, select an entry with the S action code to build a RELOAD command for the selected exit.
  2. Press Enter.
  3. Issue the command from the Command Confirmation panel by typing 1 in the selection field and pressing Enter. To cancel the command, type 2 in the selection field and press Enter.

To reload user exits using the RELOAD command

The syntax for the RELOAD command is as follows:

IN(<DB2ssid@opertuneID>) RELOAD

Command syntax and parameters

image2018-12-26_14-2-27.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job)

DSN3@ATH

The identify authorization connection exit

DSN3@SGN

The signon connection exit

DSNJL004

The log capture exit

DSNX@XAC

The access control authorization exit

DSNXVDTX

The local date exit

DSNXVTMX

The local time exit

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*