User exit parameters

The user authorization exit receives the following parameters from the calling program.

Function
The following user exit functions are always passed to the user exit to indicate which processing phase is currently active:
  • INITIALIZE
  • DECIDE
  • CLEAN_UP
Pointer
The user exit can set and use this pointer. It is always passed to the user exit. It can be used to point to the user-maintained storage area.
Request type
The request type indicates which data is to be authorized. The following request types are possible:
STAT
For statistics data (IFCIDs 1, 2, and 254)
SYSP
For system parameters data (IFCIDs 106, 202, and 230)
THSU
For thread data (IFCID 147 and 148)
SQL
For SQL statement text (IFCID 124)
The request type is passed to the exit only during the decision phase. Note that the SQL statement text is only requested for threads for which the user has been authorized.
User ID
The user ID that issued the request. The user ID is passed to the exit only during the decision phase.
Additional pointer
For request type THSU, an additional pointer is passed to the exit routine during the decision phase. This pointer points to a copy of the Db2 correlation header. The correlation header provides information about the thread being requested. Use the Db2 data mapping macro DSNDQWHC in SDSNMACS to interpret the data.