NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-69
Considerations—AUDIT
See TMF Transactions on page T-5 for more information.
Considerations—AUDIT
•
Indexes
An index always has the same AUDIT attribute as its underlying table. If you
change the AUDIT attribute for a table, SQL automatically changes the AUDIT
attribute for its indexes.
•
Views
A protection view has the same AUDIT value as the underlying table.
For a shorthand view, the AUDIT value is as follows:
•
AUDIT if all referenced tables and views are audited.
•
NO AUDIT if all referenced tables and views are nonaudited.
•
Mixed if any of the referenced views are mixed or if at least one of the
referenced tables or views is audited and at least one is nonaudited.
The value stored in the VIEWS table is Y (for AUDIT), N (for NO AUDIT), or M
(for mixed).
•
Partitioned tables
For a given table, all partitions are audited, or all partitions are nonaudited.
•
AUDIT/BUFFERED relationship for tables
If you alter the AUDIT file attribute for a table, SQL automatically sets the
BUFFERED file attribute for that table (but not for its dependent indexes) as
follows:
°
If you specify AUDIT, SQL also sets BUFFERED.
°
If you specify NO AUDIT, SQL also sets NO BUFFERED.
To override the automatic setting, explicitly specify the BUFFERED file attribute in
the ALTER TABLE statement that changes the AUDIT attribute.
Altering the BUFFERED attribute does not affect the AUDIT attribute.
AUDITCOMPRESS File Attribute
AUDITCOMPRESS is a Guardian file attribute that controls whether TMF audit records
are compressed. AUDITCOMPRESS applies to audited key-sequenced, relative, and
entry-sequenced tables and to indexes.
{ AUDIT | NO AUDIT }
The table default is AUDIT.