Priority Level:
-1
PDQPRIORITY is set to the default
0
PDQPRIORITY is turned OFF
1
PDQPRIORITY is LOW
100
PDQPRIORITY is HIGH
n
any other positive integer less than 100 that the user entered in the SET PDQPRIORITY statement
  • Operation Type:
    4
    Add a new fragment
    8
    Modify fragmentation
    16
    Drop a fragment
    32
    Initialize fragmentation
    64
    Attach table(s)
    128
    Detach fragment
  • Mode Flag:
    0
    Read/Write if operation is Set Access Mode; Dirty Read if operation is Set Isolation Level
    1
    Read-only if operation is Set Access Mode; Committed Read if operation is Set Isolation Level
    2
    Cursor Stability
    3
    Repeatable Read
  • Operation:
    0
    Set Access Mode
    1
    Set Isolation Level
  • Dropflags:
    0
    Cascade
    1
    Restrict
  • Command Mode Flag:
    1
    Disabled
    2
    Filtering without error
    4
    Filtering with error
    8
    Enabled
  • Object Type Flag:
    1
    Constraint
    2
    Index
    3
    Constraints and indexes
    4
    Trigger
    5
    Triggers and constraints
    6
    Triggers and indexes
    7
    All
  • Type: 0 singleton select; 1 cursor select. For singleton select: a successful event means one row is selected and returned; for cursor select, a successful event indicates a cursor has been opened successfully.
  • The flags field records the serial number for the current record within the multiple records created for one single event. These serial numbers range from 1 and up for each set of records and explicitly identify the order of the audit records that resulted from one single SELECT event. They are useful when you load the audit trail into a database for analysis. See Table 5 for an example.
  • The extra_2 field has a limited size of 160 bytes. The query content can be long, and continuous multiple audit records will be created in the audit trail to carry complete information when necessary.
    • Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]