Listing, deleting, outdated logical CA-7 databases

book

Article ID: 132097

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition

Issue/Introduction



Our logical database for CA-7 R12 under CA-Datacom/AD names. How can we list all logical (CA-7) databases?  Additionally, how can we delete the outdated ones?

Environment

Release:
Component: 7

Resolution

Execute the following SQL job to get a list of the logical databases in a MUF. Then you can use the CAL2DBEI program (the same one that was used in AL2DCC50 during installation) to delete each logical database that you no longer want. Instead of IMPORT=, you'll use DELETE=. 

//STEP1 EXEC PGM=DBSQLPR 
//STEPLIB DD to your MUF (same 2 libs used in CA7ONL) 
//SYSPRINT DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//OPTIONS DD * 
PRTWIDTH=255 
INPUTWIDTH=70 
ROWLIMIT=5000 
AUTHID=MFWA 
NOTYPE 
//SYSIN DD * 
SELECT DISTINCT DB 
FROM MFWA.CA7_JOB 
ORDER BY DB; 
//