SPD Server Parameter File Configurations for Auditing

[NO]WHEREAUDIT

Enables audit logs for WHERE clauses that are submitted to SPD Server. Specify the WHEREAUDIT option in the spdsserv.parm file to enable the audit logs. The spdslog message logger logs messages, and the spdsaud audit logger logs audits. If you use the WHEREAUDIT option, both the spdslog log file and the spdsaud log file contain WHERE statement information.
Usage:
WHEREAUDIT;

NOWHEREAUDIT;
The WHEREAUDIT option enables audit logging for the server. It also enables automatic audit log file creation by spdsaud. The file specification is a partial pathname or filename that is used to generate the complete audit filename. For example, if your file specification is /audit/spds, the generated filename is /audit/spds_mmddyyyy.spdsaudit. In the output, mmddyyyy is the system date when the audit log file was created.

SQLAUDLEN=

Specifies the maximum size of the SQL statement in the audit log when the following conditions are both true: proxy auditing is enabled in SPD Server, and the WHEREAUDIT option is specified.
Usage:
SQLAUDLEN=<maximum-number-of-characters-in-SQL-statement>
The default value for SQLAUDLEN is 1,024 characters. The maximum value is 4,096 characters.

WHAUDLEN=

Specifies the maximum size of the WHERE clause in the audit log when the following conditions are both true: proxy auditing is enabled in SPD Server and the WHEREAUDIT option is specified.
Usage:
WHAUDLEN=<maximum-number-of-characters-in-WHERE-clause>
The default value for WHAUDLEN is 512 characters. The maximum value is 4,096 characters.