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.
  1. 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.

  2. 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.
  3. 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.
COLUMN column-name CANNOT BE ADDED PRIOR TO NEW-FUNCTION MODE
Rerun this job when DB2 enters new-function mode.

Severity

4 (warning)