How to delete a CA 7 logical database?

book

Article ID: 125008

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition CA-7 JOB MGMT CA 7 Workload Automation

Issue/Introduction



How do I delete a specific logical database from my CA Workload Automation CA 7 Edition Datacom database?

Environment

Release: SEVDT.99000-12.0-Workload Automation-CA 7 Edition
Component:

Resolution

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?