Drop Obsolete PTDB Objects task failed -672

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The Drop Obsolete PTDB Objects task, ssid0005, failed with SQL error -672 when dropping one of the obsolete Tablespaces.

DROP TABLESPACE PTDB.tsname;

DSNT408I SQLCODE = -672, ERROR: OPERATION DROP NOT ALLOWED ON TABLE PTI.tbname
DSNT418I SQLSTATE = 55035 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIDTB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 25 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000019' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

 

Cause

The -672 indicates that the table space (tsname) being dropped contains the specified table (PTI.tbname), which has the RESTRICT ON DROP attribute.

Resolution

The PTDB Db2 tables are delivered without the RESTRICT ON DROP clause.

The presence of this clause indicates that this is a site specific change, perhaps to protect the table from accidental drop.

Alter the specified table to drop the RESTRICT ON DROP clause.

ALTER PTI.tbname DROP RESTRICT ON DROP;
COMMIT;

The DROP TABLESPACE statement that failed can then be re-executed.

Additional Information

The following SQL can be used to identify any additional PTDB tables that have the RESTRICT ON DROP clause defined.

SELECT CREATOR, NAME
FROM SYSIBM.SYSTABLES  
WHERE TYPE = 'T'       
AND CLUSTERTYPE = 'Y'  
AND DBNAME = 'PTDB'   

If not certain about how to proceed, please contact Broadcom Support before executing any further drops of the PTDB objects.