Datacom list SQL PLANs using DDUTILTY

Products

• Datacom
• Datacom/DB
• Datacom/AD
• COMMON SERVICES FOR Z/OS

Issue/Introduction

To see what Datacom SQL PLANs exist in the Multi-user (MUF), batch DDUTILTY can be used.

Environment

Release :  Any

Component : CA Datacom/DB

                        CA Datacom/AD

Resolution

Run the following report using DDUTILTY to list all if the PLANs which are in production status.

//DDRPT EXEC PGM=DDUTILTY

//STEPLIB  DD DISP=SHR,DSN=your.MUF.steplib

//SYSPUNCH DD SYSOUT=* 

//SYSPRINT DD SYSOUT=*

//AUXOUT   DD SYSOUT=*

//SNAPER   DD SYSOUT=*

//DDSNAP   DD SYSOUT=*

//SYSOUT   DD SYSOUT=*

//SYSIN    DD *

-USR DATACOM-INSTALL,NEWUSER

-RPT INDEX,PLAN,ALL(PROD)

-END

/*                 

Additional Information

A CA Common Services customer used this report to determine which of the ENF plans existed in preparation for ENF upgrade.  Here is an example report showing one plan: 

User: DATACOM-INSTALL                *********************************************************     DD Base:     2

ENTITY-TYPE..................... OCCURRENCE...................... VRSN STS LK PSWD DESCRIPTION..........................

    RECORD..........................     ELEMENT.........................

PLAN                             CAS9ENFS-TRAN$ENF#14@1B          0001  P   0