Manualshelf

SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series
131132133134135136137138139140
HP NonStop SQL/MP Reference Manual—523352-013
B-12
Considerations—BUFFERED
single I/O operation. However, buffering can cause loss of data on nonaudited files
if a failure occurs while updated rows are stored in cache memory but not yet
written to disk.
Audited files should always be buffered, because auditing itself protects against
loss of data. (Specifying NO BUFFERED for an audited file would unnecessarily
reduce performance.)
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.