DSNT092I DSNTXTA DID NOT COMPLETE PROCESSING OF schema-name.table-name BECAUSE reason-text.
Explanation
The EXPLAIN table could not be updated to the required format for this version of DB2® for the indicated reason.
- schema-name
- The name of the table schema or creator.
- table-name
- The name of the table.
- reason-text
- The reason for that the table could not be updated:
- ONE OR MORE COLUMN NAMES CONTAINS A VARIANT EBCDIC CHARACTER
- The name of one or more of columns in the table DSN_PTASK_TABLE for the indicated schema contains a variant EBCDIC character. A variant character is one that does not reside at the same code point in all EBCDIC code pages. Support for DSN_PTASK_TABLEs with such column names has been deprecated.
- IT CANNOT BE ALTERED TO A 10-COLUMN TABLE
- A 9-column DSN_QUERY_TABLE exists in the indicated schema. A 9-column DSN_QUERY_TABLE cannot be altered to a 10-column DSN_QUERY_TABLE because the new column, GROUP_MEMBER, must reside at position 8.
- OF AN UNEXPECTED NAME OR TYPE FOR COLUMN NUMBER column-number. EXPECTED: expected-format. FOUND: actual-format.
- While analyzing a table, DSNTXTA encountered a column that has an unexpected name or attribute
- column-number
- The location of the unexpected name or attribute.
- expected-format
- The format that is required for the name or attribute.
- actual-format
- The format that is used for the name or attribute.
- COLUMN column-name CANNOT BE ADDED PRIOR TO NEW-FUNCTION MODE
-
DB2 is in a mode
prior to new-function-mode. The column cannot be added until DB2 enters new-function-mode
- column-name
- The name of the column.
System action
Processing of the table that is identified by schema-name.table-name is discontinued. Processing continues with the next candidate table, if one exists.
User response
Take the action that is indicated for the reason-text value:
- ONE OR MORE COLUMN NAMES CONTAINS A VARIANT EBCDIC CHARACTER
- Use REXX exec DSNTXTB to generate statements for migrating the old DSN_PTASK_TABLE to a new one. See job DSNTIJXB for an example of how to execute DSNTXTB, and job DSNTIJXC for an example of how to process the generated statements after you have reviewed them and made any required adjustments.
- IT CANNOT BE ALTERED TO A 10-COLUMN TABLE
- Use REXX exec DSNTXTB to generate statements for migrating the 9-column DSN_QUERY_TABLE to a 10-column DSN_QUERY_TABLE. See job DSNTIJXB for an example of how to execute DSNTXTB, and job DSNTIJXC for an example of how to process the generated statements after you have reviewed them and made any required adjustments.
- OF AN UNEXPECTED NAME OR TYPE FOR COLUMN NUMBER column-number. EXPECTED: expected-format. FOUND: actual-format.
- Either the table is not an EXPLAIN table or it is not in the expected format.
- Query SYSIBM.SYSCOLUMNS, and inspect the column names and attributes of the table. For example,
use the following
query:
SELECT NAME, COLNO, CASE COLTYPE WHEN 'TIMESTMP' THEN 'TIMESTAMP' ELSE COLTYPE END, LENGTH ,LENGTH2 FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'schema-name' AND TBNAME = 'table-name' ORDER BY COLNO;
Use the information about SYSIBM.SYSCOLUMNS to help you locate the structural problem.
- If you suspect that the table might not be an EXPLAIN table, review the list of EXPLAIN tables. Compare your table to the expected table of the same name. If the table is not an EXPLAIN table, consider renaming it.
- If the table is an EXPLAIN table, it is not in the expected format and you must correct the
discrepancy. You can either:
- Alter the table to conform to the format described for the table.
- Rename the existing table, create a replacement table with the appropriate name in the expected format, and copy the data from the original table to the replacement. When you have confirmed the contents of the replacement table, drop the original table.
- Query SYSIBM.SYSCOLUMNS, and inspect the column names and attributes of the table. For example,
use the following
query:
- COLUMN column-name CANNOT BE ADDED PRIOR TO NEW-FUNCTION MODE
- Rerun this job when DB2 enters new-function mode.
Severity
4 (warning)