SPD Server Parameter File Configurations for Auditing

[NO]WHEREAUDIT

Enables audit logs for WHERE clauses that are submitted to SPD Server. The SPD Server administrator specifies the WHEREAUDIT option in the spdsserv.parm file. Unless this option is specified in the spdsserv.parm file, WHEREAUDIT is not enabled. 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 will contain WHERE statement information.
Usage:
WHEREAUDIT;

NOWHEREAUDIT;
The -WHEREAUDIT option enables audit logging for the server, and automatic audit log file creation by spdsaud. filespec specifies a partial pathname or filename specification that is used to generate the complete audit filename. For example, if you specified filespec as /audit/spds, the generated filename would appear as follows:
/audit/spds_mmddyyyy.spdsaudit
where mmddyyyy is taken from the system date when the audit log file is created.

WHAUDLEN=

Specifies the maximum size of the WHERE clause in the audit log when proxy auditing is enabled in SPD Server, and when 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 for WHAUDLEN is 4,096 characters.

SQLAUDLEN=

Specifies the maximum size of the SQL statement in the audit log when proxy auditing is enabled in SPD Server, and when 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 for SQLAUDLEN is 4,096 characters.