AUDIT_JOURNAL_PS (Profile Swap) table function

The AUDIT_JOURNAL_PS table function returns rows from the audit journal that contain information from the PS (Profile Swap) journal entries.

Every audit journal table function shares a common authorization requirement and a common set of parameters. These are described in AUDIT JOURNAL table function common information.

The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.

Table 1. AUDIT_JOURNAL_PS table function
Column Name Data Type Description
The first columns returned by this table function are from the common audit journal entry header. See Common columns returned from the audit journal entry header for the column definitions. After the common columns are the following columns that describe the entry specific data for the PS audit journal entry.
ENTRY_TYPE CHAR(1) The type of entry.
A
Profile swap during pass-through
E
End work on behalf of the relationship
H
Profile handle generated by the QSYGETPH API
I
All profile tokens were invalidated
M
Maximum number of profile tokens have been generated
P
Profile token generated for a user
R
All profile tokens for a user have been removed
S
Start work on behalf of the relationship
T
Exit program profile swap for the Telnet exit program QIBM_QTG_DEVINIT
U
Exit program profile override for the Telnet exit program QIBM_QTG_DEVINIT or for the FTP exit program QIBM_QTMF_SVR_LOGON
V
User profile authenticated
ENTRY_TYPE_DETAIL VARCHAR(200) Descriptive text that corresponds to the entry type.
USER_PROFILE_NAME VARCHAR(10) The name of the user profile.

Contains the null value if ENTRY_TYPE is T or U.
PROFILE_TOKEN_TYPE VARCHAR(12) The type of profile token that was generated.
MULTIPLE USE
Multiple-use profile token
REGENERATED
Multiple-use regenerated profile token
SINGLE USE
Single-use profile token

Contains the null value if no profile token was generated.
PROFILE_TOKEN_TIMEOUT INTEGER The number of seconds that the profile token is valid.

Contains the null value if no profile token was generated.
SOURCE_LOCATION VARCHAR(8) Pass-through source location.

Contains the null value if this entry is not for pass-through.
PASS_THROUGH_USER_PROFILE_NAME VARCHAR(10) The name of the user profile used for pass-through.

Contains the null value if ENTRY_TYPE is T or the name is not available.
ORIGINAL_PASS_THROUGH_USER_PROFILE_NAME VARCHAR(10) The original name of the user profile used for pass-through.

Contains the null value if ENTRY_TYPE is T or the name is not available.
EXIT_PROGRAM_USER_PROFILE_NAME VARCHAR(10) When ENTRY_TYPE is T, contains the name of the user profile returned by the exit program.

When ENTRY_TYPE is U, contains the name of the user profile used by the exit program.

Contains the null value if ENTRY_TYPE is not T or U or the name is not available.
NEGOTIATED_USER_PROFILE_NAME VARCHAR(10) The name of the user profile negotiated by the Telnet client.

Contains the null value if ENTRY_TYPE is not T or if no user was negotiated.
PORT_NUMBER INTEGER The port number of the Telnet or FTP client.

Contains the null value if ENTRY_TYPE is not T or U or the port number is not available.
IP_ADDRESS VARCHAR(45) The IP address of the Telnet or FTP client.

Contains the null value if ENTRY_TYPE is not T or U or the IP address is not available.
DEVICE_NAME VARCHAR(10) The name of the device that was requested or set by the exit point.

Contains the null value if ENTRY_TYPE is not T or U, or if no device was negotiated, or if FTP is used.
EXIT_POINT_NAME VARCHAR(30) The name of the exit point for which the exit program profile is overridden.

Contains the null value if ENTRY_TYPE is not T or U or the exit point name is not available.
EXIT_POINT_FORMAT VARCHAR(8) The exit point format.

Contains the null value if ENTRY_TYPE is not T or U or the exit point format is not available.
OFFICE_USER VARCHAR(10) The name of the office user.

Contains the null value if there is no office user.
OFFICE_ON_BEHALF_OF_USER VARCHAR(10) User working on behalf of the office user.

Contains the null value if the user name is not available.

Example

  • List the occurrences where a single user profile token was generated for the user QSYS in the last week.
    
SELECT * FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_PS(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 7 DAYS
  )
)
WHERE PROFILE_TOKEN_TYPE = 'SINGLE USE' AND USER_PROFILE_NAME = 'QSECOFR';