DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.AUDITPOLICIES catalog view

Each row represents an audit policy.

Table 1. SYSCAT.AUDITPOLICIES Catalog View
Column Name Data Type Nullable Description
AUDITPOLICYNAME VARCHAR (128)   Name of the audit policy.
AUDITPOLICYID INTEGER   Identifier for the audit policy.
CREATE_TIME TIMESTAMP   Time at which the audit policy was created.
ALTER_TIME TIMESTAMP   Time at which the audit policy was last altered.
AUDITSTATUS CHAR (1)   Status for the AUDIT category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
CONTEXTSTATUS CHAR (1)   Status for the CONTEXT category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
VALIDATESTATUS CHAR (1)   Status for the VALIDATE category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
CHECKINGSTATUS CHAR (1)   Status for the CHECKING category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
SECMAINTSTATUS CHAR (1)   Status for the SECMAINT category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
OBJMAINTSTATUS CHAR (1)   Status for the OBJMAINT category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
SYSADMINSTATUS CHAR (1)   Status for the SYSADMIN category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
EXECUTESTATUS CHAR (1)   Status for the EXECUTE category.
  • B = Both
  • F = Failure
  • N = None
  • S = Success
EXECUTEWITHDATA CHAR (1)   Host variables and parameter markers logged with EXECUTE category.
  • N = No
  • Y = Yes
ERRORTYPE CHAR (1)   The audit error type.
  • A = Audit
  • N = Normal
REMARKS VARCHAR (254) Y User-provided comments, or the null value.