DSNU276I PENDING DEFINITION CHANGES CANNOT BE MATERIALIZED DUE TO ERROR ENCOUNTERED FOR object-type OBJECT object-schema.object-name REASON reason
Explanation
During REORG processing or materialization of pending definition changes on the target table space, an error prevented REORG from continuing execution. The utility either terminates with RC8 or abnormally terminates with ABEND04E RC00E400AF, depending on when the error is encountered.
- csect-name
- The name of the control section that issued the message.
- object-type
- The type of object that encountered the error.
- object-schema
- The schema name of the object that encountered an error.
- object-name
- The name of the object that encountered an error.
- reason
- The following reasons can be returned:
- REGENERATION OR REBIND FAILURE OF A DEPENDENT TRIGGER
- Materialization of a pending definition change failed due to an error when regenerating a dependent trigger or rebinding the package for the dependent trigger. The SQLCA contents for the failure are returned in a prior DSNU283I message.
- SEMANTIC VALIDATION FAILURE OF A MOVED TABLE
- FL 508 Materialization of a pending definition change failed due to an error during semantic validation when moving a table. The SQLCA contents for the failure are returned in a prior DSNU283I message.
System action
Utility processing terminated.
User response
Correct the user object based on the reported reason. Run the REORG TABLESPACE utility again with SHRLEVEL REFERENCE or CHANGE to materialize the pending definition changes.
- REGENERATION OR REBIND FAILURE OF A DEPENDENT TRIGGER
- Examine the SQLCA that is returned by the prior DSNU283I message and correct the problem based on the reported error. In some cases, an ALTER TRIGGER statement with REGENERATE option may be used to validate that the trigger can be regenerated successfully prior to re-executing the REORG.
- SEMANTIC VALIDATION FAILURE OF A MOVED TABLE
- FL 508 Examine the SQLCA that is returned by the prior DSNU283I message and correct the problem based on the reported error. In the case where the target table space is not defined correctly for the moved table, correct the table space definition by either altering the table space or dropping and recreating the table space. To drop the target table space, all pending definition changes must first be dropped for the reorganized table space.
Severity
8 (error)
