DBMS_APPLICATION_INFO module
The DBMS_APPLICATION_INFO module provides procedures that set custom client information. This client information is exported through some of the table functions in the database. The included procedures also help to identify the targeted sessions.
The READ procedures return the current values of the sessions, while the SET procedures
register the value of the current sessions. The ACTION, MODULE and CLIENT_INFO attributes used with
the procedures set and read the information on the action, module, and client info defined from the
user actions.
The schema for this module is SYSIBMADM.
The DBMS_APPLICATION_INFO module includes the following built-in routines.
| Routine name | Description |
|---|---|
| READ_CLIENT_INFO procedure | Reads and returns a value from the current session for the client information field. |
| READ_MODULE procedure | Reads and returns the name of the module that is currently being executed. |
| SET_CLIENT_INFO procedure | Sets and registers the client information field for the current session. |
| SET_MODULE procedure | Sets and registers the name of the module that is currently being executed. |
| SET_ACTION procedure | Sets and registers the action name within the current module. |
| SET_SESSION_LONGOPS procedure | Sets and registers a row in the SYSTOOLS.SESSON_LONGOPS table for storing progress information of long operations |