Start of change

DSNA687I   csect-name ADMIN_INFO_SQL OUTPUT IS INCOMPLETE DUE TO THE FOLLOWING MISSING EXPLAIN TABLES: table-list

Explanation

Stored procedure SYSPROC.ADMIN_INFO_SQL was issued to collect EXPLAIN output. One or more of the tables from which ADMIN_INFO_SQL gathers EXPLAIN output were missing. This might result in insufficient information for problem analysis.

csect-name
The name of the control section that issued the message.
table-list
A comma-separated list of the missing EXPLAIN tables.

System action

Processing continues. The EXPLAIN output that ADMIN_INFO_SQL collects is incomplete.

User response

Define the missing tables, run EXPLAIN on the query, and call ADMIN_INFO_SQL to collect complete EXPLAIN output. See member DSNTESC in the prefix.SDSNSAMP data set for data definition statements for the EXPLAIN tables.
End of change