How do I delete a CA Datacom database (that does not have any SQL entities such as Plans or Constraints, etc)?

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

Question:

How do I delete a CA Datacom database (that does not have any SQL entities such as Plans or Constraints, etc)?

Answer:

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

Follow these steps:

1. Run batch DBUTLTY and produce a full CXX report for the database dbid using the following SYSIN:

REPORT AREA=CXX,DBID=dbid

In the CXX report, note the OCCURRENCE name of the database shown in the DATA BASE INFORMATION section.

In the CXX report, also note all of the "DATA SET NAME" entries. These are the physical data set names (DSNs) which are the index and data areas.

2. Run batch DBUTLTY to delete the database from the CXX using the following SYSIN:

CXXMAINT OPTION=DELETE,DBID=dbid

3. 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  
 
4.  Now the database has been deleted from the Datacom CXX and Datadictionary, delete the physical data sets noted the CXX report. 
 
Additional Information:
 
For more information on DBUTLTY, CXX reports, CXX report, and DDUPDATE, refer to the CA Datacom documentation found in docops.ca.com.