DB2 Database Path Delete

Document ID : KB000054655
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

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.

Solution

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.