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: