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.
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.
SET DELETE_RULE = 'A' WHERE PATHNAME = 'DB2ALL';
Change REPOWNER to your Repository creator
A Delete Type of A indicates that the TO type should always be deleted.