AUDIT_JOURNAL_RZ (Primary Group Change for Restored Object) table function

The AUDIT_JOURNAL_RZ table function returns rows from the audit journal that contain information from the RZ (Primary Group Change for Restored Object) 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_RZ 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 RZ audit journal entry.
ENTRY_TYPE	CHAR(1)	The type of entry. A Changes to the primary group for a restored object
ENTRY_TYPE_DETAIL	VARCHAR(200)	Descriptive text that corresponds to the entry type.
OBJECT_LIBRARY	VARCHAR(10)	The name of the library containing the restored object. Contains the null value if there is no library name.
OBJECT_NAME	VARCHAR(10)	The name of the restored object. Contains the null value if there is no restored object name.
OBJECT_TYPE	VARCHAR(7)	The type of the restored object. Contains the null value if there is no restored object type.
OBJECT_ASP_NAME	VARCHAR(10)	The name of the auxiliary storage pool (ASP) in which OBJECT_NAME resides. A value of *SYSBAS indicates the system ASP and all basic user ASPs.
OBJECT_ASP_NUMBER	INTEGER	The number of the auxiliary storage pool to which storage for OBJECT_NAME is allocated. 1 indicates the system ASP.
SAVE_PRIMARY_GROUP	VARCHAR(10)	The primary group for the object on the save media. Contains the null value if there is no primary group for the object on the save media.
RESTORE_PRIMARY_GROUP	VARCHAR(10)	The primary group for the object after the restore has completed. Contains the null value if there is no primary group for the object on the save media.
PATH_NAME	VARGRAPHIC(5000) CCSID 1200	The path name of the restored object. Contains the null value if the restored object name is not available 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 restored 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 restored object. Contains the null value if the restored 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 restored object identified in the PATH_NAME column. Contains the null value when PATH_NAME_INDICATOR is YES, or if the file ID is not available or the restored object is not in the "root" (/), QOpenSys, or user-defined file systems.
IFS_OBJECT_NAME	VARGRAPHIC(512) CCSID 1200	The name of the restored object. Contains the null value if the restored object name is not available or the restored object is not in the "root" (/), QOpenSys, or user-defined file systems.
OBJECT_FILE_ID	BINARY(16)	The file ID of the restored object. Contains the null value if the restored 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 the file ID is not available or the restored object is not in the "root" (/), QOpenSys, or user-defined file systems.
DLO_NAME	VARCHAR(12)	The name of the document library object. Contains the null value if there is no document library object.
FOLDER_PATH	VARCHAR(63)	The path of the folder. Contains the null value if there is no folder path.

Example

List any objects in APPLIB1 that have the primary group DEVS as a result of restores done in the last day.


SELECT OBJECT_NAME, RESTORE_PRIMARY_GROUP FROM TABLE(
   SYSTOOLS.AUDIT_JOURNAL_RZ(
     STARTING_TIMESTAMP => CURRENT TIMESTAMP - 1 DAY)
  )
  WHERE OBJECT_LIBRARY = 'APPLIB1' AND
  RESTORE_PRIMARY_GROUP = 'DEVS';