10.11.9 Corrective action to take if SQL trace information was not output due to an error

The SQL trace information output processing stops if any of the following errors occurs:

• Shortage of disk space (KFAA51010-W message is output)

• Lack of privilege to access SQL trace files (KFAA51010-W message is output)

• Insufficient file descriptors (KFAA51010-W message is output)

• Memory shortage (KFAA51011-W message is output)

The following procedure explains how to restart output of SQL trace information.

Procedure

1. Check the SQL trace information output status.

   Execute the adbchgsqltrc command:

   adbchgsqltrc -d
    
   sqltrace param    accesspath level
   INACTIVE ACTIVE   ACTIVE     CALL

   If the SQL trace information output processing has stopped, INACTIVE is displayed in the sqltrace column.

2. Eliminate the cause of the error.

   Check the error message that has been output to the message log file and eliminate the cause of the error.

3. Restart the SQL trace information output processing.

   Execute the adbchgsqltrc command:

   adbchgsqltrc -s

Note

If the disk storing the SQL trace files has become full, a warning message is output to the message log file and SQL trace information output processing stops. Even when SQL trace information output processing has stopped, SQL statement processing continues.

To Page Top