Chapter 22 Unaudited Database File Operations

When batch-loading a database file or when generating ad hoc indexes, for example, there is significant auditing overhead. Until the index build is complete, the database file or partition is known to be building (application preserved state) and if the build is restarted, the file or partition is first dropped.

You can update database files and partitions with auditing disabled, to eliminate journal disk space use and I/O overhead when loading data. When auditing is re‑enabled for a file or partition, a copy of the file or partition is compressed by default, and inserted into the journal. During database roll‑forward or replay, the file at the database location is replaced by the file reconstructed from the journal. Subsequent audited updates therefore replay correctly.

Disable the auditing of database files and partitions only when restart recovery is not required.

Unaudited operations cannot be used when you have RPS secondaries, as this would result in SQL inconsistencies.

The following table summarizes the methods used to manage unaudited operations.

Class	Method	Description
DbFile	disableAuditing	Disables the auditing associated with object operations performed against the file
DbFile	drop	Removes the file and marks it as deleted
DbFile	enableAuditing	Re‑enables the auditing associated with object operations performed against the file
DbFile	isAuditing	Returns true if auditing associated with object operations performed against the file is enabled and returns false when auditing has been disabled
JadeDatabaseAdmin	doQuietpoint	Attempts to establish a database quiet point
JadeDbFilePartition	disableAuditing	Disables auditing associated with object operations performed against the partition
JadeDbFilePartition	drop	Removes the partition and marks it as deleted
JadeDbFilePartition	enableAuditing	Re‑enables the auditing associated with object operations performed against the partition
JadeDbFilePartition	isAuditing	Returns true if auditing associated with object operations performed against the partition is enabled and returns false when auditing has been disabled

In addition, the DbFile class provides the EnableAudit_NoCompress class constant. For details, see Volume 1 of the JADE Encyclopaedia of Classes.