AX (Row and Column Access Control) journal entries

This table provides the format of the AX (Row and Column Access Control) journal entries.

Table 1. AX (Row and Column Access Control) journal entries. QASYAXJ5 Field Description File
Offset Field Format Description
J5
1     Heading fields common to all entry types. See Standard heading fields for audit journal entries QJORDJE5 Record Format (*TYPE5) for field listing.
610 Entry Type Char(1) The type of entry.
M
Column mask
P
Row permission
T
Table
611 Operation Type Char(1) The type of operation.
A
Alter
B
Internal use
C
Create
D
Drop
612 Table Name Char(10) The name of the base table that the permission or mask is associated with or the table being altered.
622 Table Library Char(10) The name or the library where the table is stored.
632 Table ASP Name Char(10) The name of the table ASP device.
642 Table ASP Number Char(5) The number of the table ASP device.
647 Name Char(128) When entry type (J5 offset 610) is P this field contains the row permission name.

When entry type (J5 offset 610) is M this field contains the column mask name.
775 Column Name Char(10) The name of the column to which the mask applies. This field is only used when the entry type (J5 offset 610) is M and the operation type (J5 offset 611) is C.
785 Status 1 Char(1) This field is only used when the operation type (J5 offset 611) is A or C.
When entry type (J5 offset 610) is M or P this field contains the row permission status or the column mask status.
E
Enabled
D
Disabled
When entry type (J5 offset 610) is T this field contains the row access control status.
A
Activate
D
Deactivate
786 Status 2 Char(1) This field is only used when the operation type (J5 offset 611) is A.
When entry type (J5 offset 610) is T this field contains the column access control status.
A
Activate
D
Deactivate
787 Previous Status 1 Char(1) This field is only used when the operation type (J5 offset 611) is A.
When entry type (J5 offset 610) is M or P this field contains the previous row permission status or the previous column mask status.
E
Enabled
D
Disabled
When entry type (J5 offset 610) is T this field contains the previous row access control status.
A
Activate
D
Deactivate
788 Previous Status 2 Char(1) This field is only used when the operation type (J5 offset 611) is A.
When entry type (J5 offset 610) is T this field contains the previous column access control status.
A
Activate
D
Deactivate
789 (Reserved Area) Char(50)  
839 Truncated Indicator Char(1) Indicates if the SQL statement is truncated. This field is only used when the entry type (J5 offset 610) is M or P and the operation type (J5 offset 611) is C.
1
SQL statement truncated
840 SQL statement CCSID Binary(5) The coded character set identifier for the SQL statement. This field is only used when the entry type (J5 offset 610) is M or P and the operation type (J5 offset 611) is C.
844 SQL statement length Binary(4) The length of the SQL statement. This field is only used when the entry type (J5 offset 610) is M or P and the operation type (J5 offset 611) is C.
846 SQL statement1 Char(5002) The SQL statement. This field is only used when the entry type (J5 offset 610) is M or P and the operation type (J5 offset 611) is C.
1
This is a variable length field. The first two bytes contain the length of the SQL statement.