Set the database connection and the schema for the audit tables on the Human task properties of the Analyst Service in the Administrator tool. After you specify a connection and schema, use the

Actions

menu options in the Administrator tool to create the audit database contents. Or, use the infacmd as commands to set the database and schema and to create the audit database contents. To set the database and the schema, run infacmd as updateServiceOptions. To create the database contents, run infacmd as createExceptionAuditTables

If you do not specify a connection and schema, the Analyst Service creates audit tables for each task instance in the database that stores the task instance data.

For more information, see the

Informatica 10.1.1 Application Service Guide

and the

Informatica 10.1.1 Command Reference

.