How to delete a CA 7 logical database?

Document ID : KB000125008
Last Modified Date : 21/01/2019
Show Technical Document Details
Question:
How do I delete a specific logical database from my CA Workload Automation CA 7 Edition Datacom database?
Answer:
Use the JCL from CAL2JCL library member AL2DBEI to delete a specific logical database from your CA 7 Datacom database.

//RUN      EXEC PGM=CAL2DBEI                          
//STEPLIB  DD DISP=SHR,DSN=prodhlq.CAL2LOAD                                     
//         DD DISP=SHR,DSN=datacomhlq.CUSLIB                                   
//         DD DISP=SHR,DSN=datacomhlq.CAAXLOAD                                 
//SYSPRINT DD SYSOUT=*                                  
//SYSUDUMP DD SYSOUT=*       
//AL2EXIM  DD DUMMY
//SYSIN    DD * 
DELETE=LOGICAL_DATABASE_NAME
//


NOTE:  
It is recommended that you verify that the logical database exist by running the SQL JCL which displays logical database names in the CA & Datacom database DBI=770.
Refer to knowledge document,  How do I find the logical database names that are in the CA 7 r12 DBID=770?