-9000 resource-type not found: resource-name or -9000 resource-type for the following database not found: resource-name or -9000 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. Valid resource names can additionally be generic, such as DATABASE and TABLE.
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. Ensure that RESTRICT is being used with DROP statements. Resubmit the DDL.
SQLIMSSTATE
57006