DB2 Database Path Delete

Products

• Repository

Issue/Introduction

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.

 

Environment

Component: XTR

Resolution

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.