How do I delete a CA Datacom database (that does not have any SQL entities such as Plans or Constraints, etc)?
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:
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:
3. Run batch DDUPDATE to delete (obsolete) the database from the Datadictionary using the following SYSIN:
4. Now the database has been deleted from the Datacom CXX and Datadictionary, delete the physical data sets noted the CXX report.
For more information on DBUTLTY, CXX reports, CXX report, and DDUPDATE, refer to the CA Datacom documentation found in docops.ca.com.