How to delete a Datacom database without SQL entities

Products

• Datacom
• Datacom/DB

Issue/Introduction

What is to process to delete (obsolete) a Datacom database that does not have any SQL entities such as Plans or Constraints, etc?

Resolution

A Datacom database that does not have any SQL entities such as Plans or Constraints, needs to be deleted from both the CXX catalog and the Datacom Datadictionary.

Follow the steps below:

1. Run batch DBUTLTY and produce a full CXX report for the database dbid planned on being deleted using the following SYSIN:
   REPORT AREA=CXX,DBID=dbid
2. In the CXX report, note the OCCURRENCE NAME of the database shown in the DATA BASE INFORMATION section.
3. In the CXX report, note all of the "DATA SET NAME" entries. These are the physical data set names (DSNs) which are the index and data areas.
4. Run batch DBUTLTY to delete the database from the CXX using the following SYSIN:
   CXXMAINT OPTION=DELETE,DBID=dbid
5. Run batch DDUPDATE to delete (obsolete) the database from the Datadictionary using the following SYSIN:
   -USR DATACOM-INSTALL,NEWUSER             
   -DEL DATABASE,database             
   1000 OBSOLETE                           
   -END 
6. Delete the physical data sets noted the CXX report.