Explain return codes

 

Related topics

Customizing-expert-rules

SQL Explorer Return codes

 The following table lists the return codes for the Explain function and provides information about the events that cause Explain to issue a particular return code.

 Return codes for the Explain function

Condition

Return code

Only informational messages are issued.

0

This return code is displayed when the following events occur:

  • At least one severe or warning message is issued.
  • The ADMIN_EXPLAIN_MAINT Db2 stored procedure discovers that one or more explain tables are not of the UNICODE format.

4

This return code is displayed when the ADMIN_EXPLAIN_MAINT Db2 stored procedure discovers the following about one or more of the existing explain tables:

  • The tables are of a format that cannot be altered.
  • The tables are of an unknown format.

8

A connection error, unexpected SQL errors, or memory errors occur.

12

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*