Previous Topic: Auxiliary Message Logs

Next Topic: Log File Operations

Provide Auxiliary Logs

To provide auxiliary logs for the communications server and the SQL server, take the following actions:

  1. Define log files through an ADDLOG command.
  2. Associate the log with the appropriate CA-L-Serv server through the LOGID parameter on the ATTACH command. For example, you can start the communications server and associate it with the auxiliary log LCOMLOG through this command:
    ATTACH COMMSERVER LOGID(LCOMLOG)
    
  3. When you provide an auxiliary log for the SQL server, indicate what type of messages CA-L-Serv should log. By default, CA-L-Serv logs only error messages about SQL statements that it has read. To log all SQL statement messages, including messages about every SQL statement that CA-L-Serv has read, specify AUDIT(STATEMENTS) on the ATTACH command.