Start of change

AUDIT_JOURNAL_ZC (Change to Object) table function

Edit online

The AUDIT_JOURNAL_ZC table function returns rows from the audit journal that contain information from the ZC (Change to 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_ZC 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 ZC audit journal entry.
ENTRY_TYPE CHAR(1) The type of entry.
C
Change of an object
U
Upgrade of open access to an object
ENTRY_TYPE_DETAIL VARCHAR(200) Descriptive text that corresponds to the entry type.
ACCESS_TYPE INTEGER Type of access. See Numeric codes for access types for a list of the codes for access types.
ACCESS_TYPE_DETAIL VARCHAR(50) Descriptive text that corresponds to ACCESS_TYPE.
LIBRARY_NAME VARCHAR(10) The name of the library.

Contains the null value if there is no library name.
OBJECT_NAME VARCHAR(10) The name of the object.

Contains the null value if there is no object name.
OBJECT_TYPE VARCHAR(7) The type of object.

Contains the null value if there is no object type.
MEMBER_NAME VARCHAR(10) The member name for a *FILE object.

Contains the null value if OBJECT_TYPE is not *FILE or if there is no member name.
PREV_MEMBER_NAME VARCHAR(10) The previous member name for a *FILE object.

Contains the null value if OBJECT_TYPE is not *FILE or if ACCESS_TYPE is not 39 (Rename).
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 there is no ASP information.
OBJECT_ASP_NUMBER INTEGER The number of the ASP device. 1 indicates the system ASP.

Contains the null value if there is no ASP information.
IFS_ACCESS_TYPE VARCHAR(50) Integrated file system access type. See QP0LJRNL in QSYSINC/H for the list of values.

Contains the null value if the operation was not for an integrated file system object.
IFS_ACCESS_TYPE_DETAIL VARCHAR(2000) CCSID 1208 Descriptive text that corresponds to IFS_ACCESS_TYPE. The value is returned as an array within a JSON object. It is formatted as:{"IFS_ACCESS_LIST":["first-string", "second-string", ...]}
PATH_NAME VARGRAPHIC(5000) CCSID 1200 The path name of the object.

Contains the null value if the path 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 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 the absolute path name for the object.

Contains the null value if 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 when PATH_NAME_INDICATOR is YES, or if the file ID is not available or 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 the object name is not available 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 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 the file ID is not available or the object is not in the "root" (/), QOpenSys, or user-defined file systems.
IMGCLGE_ACCESS_TYPE VARCHAR(10) Access type for the image catalog entry.
READ
The file containing the image catalog entry is read-only.
READ WRITE
The file containing the image catalog entry is read/write capable.

Contains the null value if the operation was against an image catalog or the object type is not *IMGCLG.
IMGCLGE_INDEX_NUMBER INTEGER Index number of the image catalog entry.

Contains the null value if the operation was against an image catalog or the object type is not *IMGCLG.
IMGCLGE_VOLUME_ID VARCHAR(32) Volume ID of the image catalog entry. Can contain the special value *GEN.

Contains the null value if the operation was against an image catalog or the object type is not *IMGCLG.
IMGCLGE_WRITE_PROTECTION VARCHAR(3) The write protection for the image catalog entry.
NO
The file containing the image catalog entry is not write protected.
YES
The file containing the image catalog entry is write protected..

Contains the null value if the operation was against an image catalog or the object type is not *IMGCLG.
IMGCLGE_VIRTUAL_DEVICE VARCHAR(10) The name of the virtual device for the image catalog entry.

Contains the null value if the operation was against an image catalog, the image catalog is not in Ready status, or the object type is not *IMGCLG.

Example

  • List objects in the integrated file system that start with the letters 'data' that were modified in the last week. 
    
SELECT IFS_OBJECT_NAME, PATH_NAME, ACCESS_TYPE FROM TABLE(
  SYSTOOLS.AUDIT_JOURNAL_ZC(  
      STARTING_TIMESTAMP => CURRENT TIMESTAMP - 7 DAYS
  )
)
WHERE ENTRY_TYPE = 'C' AND
   IFS_OBJECT_NAME LIKE 'data%'
ORDER BY PATH_NAME, IFS_OBJECT_NAME;
End of change