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; //