SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-75
AUDITCOMPRESS File Attribute
The value stored in the VIEWS table is Y (for AUDIT), N (for NO AUDIT), or M
(for mixed).

For a given table, all partitions are audited, or all partitions are nonaudited.

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):

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 the TMF audit records are
compressed. AUDITCOMPRESS applies to audited key-sequenced, relative, and
entry-sequenced tables and to indexes.
Compressed audit records omit unchanged columns from the before and after images
of updated rows. Uncompressed audit records allow you to read complete rows in the
audit trail but require more space.
Considerations—AUDITCOMPRESS

AUDITCOMPRESS can save system resources, so you should allow tables and
indexes to default to AUDITCOMPRESS, unless you have a specific requirement
to read audit trail files with complete before and after images.

Audit records of uncompressed files contain entire before and after images of
changed rows. Audit records of compressed files generally contain only changed
columns and columns of the primary key. Other columns are occasionally included
to improve performance, such as when a single unchanged column physically
occurs between several changed columns.

Programs can read audit trails written with or without audit compression by using
TMF audit-reading procedures.

If AUDITCOMPRESS is on at the start of a CREATE INDEX operation that uses
the WITH SHARED ACCESS option, NonStop SQL/MP turns AUDITCOMPRESS
off. When finished with the CREATE INDEX operation, SQL turns
AUDITCOMPRESS back on. If the CREATE INDEX operation fails, however, SQL
{ AUDITCOMPRESS | NO AUDITCOMPRESS }
The table default is AUDITCOMPRESS.
The index default is the table value at index creation.