-9000 resource-type not found:
resource-name
or
resource-type
for the following database not found:
resource-name
or
resource-type
resource-name not found.
Explanation
Unable to drop (delete), alter, create, or comment on a resource with the name specified in
resource-name. Resource was not found in the catalog or the act of dropping or
altering the resource would result in a nonviable resource.
- resource-type
- Valid resource|object types are DBD, PSB, tablespace, table, column, schema, segment, senseg, senfld, lchild and xdfld.
- resource-name
- Resource name to process.
System action
The statement cannot be processed. All prior uncommitted work is backed out.
Programmer response
Verify that the resource exists and that the DDL action performed results in a viable final resource. Resubmit the DDL.
SQLIMSSTATE
57006
