If you use the Path Delete facility and are using the 'DB2ALL' sample path, you may be asking if there a way to run a path delete on a DB2 database that will delete the tbspace, table, columns, elements, key, part, space, key col, etc . Running the 'DB2ALL' sample path only results in the root object 'DATABASE' being deleted from the Repository leaving all remaining connections.
Component: XTR
The following statement can be run to update the DELETE_RULE flag on the DBX_PATH_TBL for the 'DB2ALL' path so that the entire database is deleted from the Repository.
- UPDATE REPOWNER.DBX_PATH_TBL SET DELETE_RULE = 'A' WHERE PATHNAME = 'DB2ALL'; -
Note:
Change REPOWNER to your Repository creator
A Delete Type of A indicates that the TO type should always be deleted.