AUDIT_JOURNAL_PU (PTF Object Change) table function

The AUDIT_JOURNAL_PU table function returns rows from the audit journal that contain information from the PU (PTF Object Change) 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_PU 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 PU audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. D Directory PTF object L Library PTF object S LIC PTF object
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
ENTRY_ACTION	VARCHAR(7)	The type of action. CHANGED Changed PTF object NEW New PTF object
PTF_OPERATION	VARCHAR(6)	The PTF operation. APPLY The PTF is applied REMOVE The PTF is removed
PRODUCT_ID	VARCHAR(7)	Product ID.
PRODUCT_RELEASE_LEVEL	CHAR(6)	Product version, release, modification in format VvRrMm.
PTF_IDENTIFIER	VARCHAR(7)	PTF identifier.
PRODUCT_OPTION	VARCHAR(4)	Product option.
LOAD_ID	VARCHAR(4)	Product load identifier.
PRODUCT_MINIMUM_LEVEL	VARCHAR(2)	Product minimum level.
PRODUCT_MAXIMUM_LEVEL	VARCHAR(2)	Product maximum level.
PRODUCT_LIBRARY	VARCHAR(10)	Product library.
OBJECT_LIBRARY	VARCHAR(10)	Object library. Contains the null value if ENTRY_TYPE is not L.
OBJECT_NAME	VARCHAR(10)	Object name. Contains the null value if ENTRY_TYPE is not L.
OBJECT_TYPE	VARCHAR(7)	Object type. Contains the null value if ENTRY_TYPE is not L.
OBJECT_ASP_NAME	VARCHAR(10)	The name of the auxiliary storage pool (ASP) in which the object resides. A value of *SYSBAS indicates the system ASP and all basic user ASPs. Contains the null value if ENTRY_TYPE is not D or L.
OBJECT_ASP_NUMBER	INTEGER	The number of the ASP device. 1 indicates the system ASP. Contains the null value if ENTRY_TYPE is not D or L.
LIC_RU_NAME	VARCHAR(8)	The Licensed Internal Code replacement unit (Ru) name. Contains the null value if ENTRY_TYPE is not S.
PATH_NAME	VARGRAPHIC(5000) CCSID 1200	The path name of the object. Contains the null value if ENTRY_TYPE is not D or the object is not in the "root" (/), QOpenSys, or user-defined file systems.
PATH_NAME_INDICATOR	VARCHAR(3)	Path name indicator. NO The PATH_NAME column does not contain an absolute path name for the object, instead it contains a relative path name. The RELATIVE_DIRECTORY_FILE_ID can be used to form an absolute path name with this relative path name. YES The PATH_NAME column contains complete absolute path name for the object. Contains the null value if ENTRY_TYPE is not D or the object is not in the "root" (/), QOpenSys, or user-defined file systems.
RELATIVE_DIRECTORY_FILE_ID	BINARY(16)	When PATH_NAME_INDICATOR is NO, contains the file ID of the directory that contains the object identified in the PATH_NAME column. Contains the null value if ENTRY_TYPE is not D, when PATH_NAME_INDICATOR is YES, or if the object is not in the "root" (/), QOpenSys, or user-defined file systems.
IFS_OBJECT_NAME	VARGRAPHIC(512) CCSID 1200	The name of the object. Contains the null value if ENTRY_TYPE is not D or the object is not in the "root" (/), QOpenSys, or user-defined file systems.
OBJECT_FILE_ID	BINARY(16)	The file ID of the object. Contains the null value if ENTRY_TYPE is not D, or the object is not in the "root" (/), QOpenSys, or user-defined file systems.
PARENT_FILE_ID	BINARY(16)	The file ID of the parent directory. Contains the null value if ENTRY_TYPE is not D or the object is not in the "root" (/), QOpenSys, or user-defined file systems.

Example

List objects that were affected by PTFs that were applied to the system in the previous two days.

SELECT PTF_IDENTIFIER, OBJECT_LIBRARY, OBJECT_NAME, OBJECT_TYPE
  FROM TABLE (
      SYSTOOLS.AUDIT_JOURNAL_PU (STARTING_TIMESTAMP => CURRENT DATE - 2 DAYS)
    )
  WHERE ENTRY_TYPE = 'L' AND PTF_OPERATION = 'APPLY';