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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

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.

Environment

Release:
Component: DB