-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