15.5.3 If the command terminated abnormally while collecting cost information for all tables
To troubleshoot if the command with the -t option omitted terminated abnormally while collecting cost information for all the tables in a schema:
-
Check if the KFAA80285-I message was issued.
If the KFAA80285-I message (indicating that cost information for a table was collected) was issued, the cost information has been collected. No action is needed.
The KFAA80285-I message is issued for each table processed. Therefore, you must check whether the KFAA80285-I message was issued for every table in the schema. If the KFAA80285-I message was not issued for a table, go to the next step.
-
Check the date and time cost information was collected.
Retrieve the system tables to check the dates and times cost information was collected for all the tables in the schema and for the indexes defined for those tables.
The following SELECT statement checks the names of all tables for which cost information was collected and the dates and times the cost information was collected:
SELECT "TABLE_SCHEMA","TABLE_NAME","COLLECT_TIME" FROM "MASTER"."STATUS_TABLES"The following SELECT statement checks the names of all indexes for which cost information was collected and the dates and times the cost information was collected:
SELECT "TABLE_SCHEMA","INDEX_NAME","COLLECT_TIME" FROM "MASTER"."STATUS_INDEXES"- Important
-
Issue the COMMIT statement immediately after you retrieve the system tables. However, if you terminate the adbsql command after you retrieve the system tables, there is no need to execute the COMMIT statement.
If the dates and times the cost information was collected for the tables and indexes are after the date and time the adbgetcst command was executed, the cost information has been collected. In this case, no action is needed.
If the dates and times the cost information was collected for the tables and indexes are before the date and time the adbgetcst command was executed or no cost information is stored in the system table (base table), go to the next step.
-
Check the message that was issued.
Eliminate the cause of the error according to the information provided in the message.
-
Re-execute the adbgetcst command.
Re-execute the adbgetcst command with the -t option specifying the table name of a table for which cost information was not collected. This also applies to a table with an index defined for which cost information was not collected. Only one table name can be specified by the -t option. Therefore, if cost information was not collected for more than one table, you must execute the adbgetcst command as many times as there are tables for which cost information needs to be collected.
If cost information was not collected for any of the tables in the schema, re-execute the adbgetcst command with the -t option omitted.