Previous Topic: Auxiliary Message LogsNext Topic: Log File Operations


Provide Auxiliary Logs

To provide auxiliary logs for the communications server and the SQL server:

Follow these steps:

  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 can 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 the type of messages CA-L-Serv 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.