SSAUDITR

This Essbase configuration setting enables grid update logging, clearing the logs at the end of the archiving process.

This setting does not apply to aggregate storage cubes.

Syntax

SSAUDITR appname [dbname [log_path]]

appname—Application name.
dbname—Optional. Database (cube) name.
log_path— Optional. Full directory path where you want the information stored. Do not specify a log_path value unless you have also provided a value for dbname.

Default behavior:

If SSAUDITR (or SSAUDIT) is not specified, grid update logging is not enabled.
If SSAUDITR (or SSAUDIT) is issued with no arguments, Essbase activates grid update logging for all cubes in all applications on the Essbase Server, and puts the log in the default directory: <Application Directory>/app/appname/dbname.

See Environment Locations in the Essbase Platform for information about directory locations in Essbase.

Use the value xxxxx to indicate "all" for any argument.

You can issue up to ten (total) SSAUDITR and/or SSAUDIT statements per application.

Description

SSAUDITR enables Essbase to log successfully completed grid update transactions. The resulting logs can be used as a source of input data upon recovery after archive operations or other server interruptions.

Notes

SSAUDITR creates two logs for each cube:
- dbname.atx, which stores the update transaction records that can be used as the input source for data load
- dbname.alg, which stores history records from every update transaction, including user name, time stamp, and number of updated rows
Essbase ensures that if you enable grid update logging, updates do not take place without getting logged. If Essbase cannot write to the update logs for any reason, the update transaction failes and an error message is issued.

SSAUDITR may slow grid client data-update operations.
The update log file will not be cleared if the cube is shut down during archive mode. The cube is expected to remain running while in archive mode.

Example

SSAuditR demo

Enables logging with refresh (clear) for all cubes belonging to the Demo application. The log is stored in the default directory.