Print list of all Datacom SQL PLANS

Products

• Datacom
• DATACOM - AD

Issue/Introduction

How can I get a printed lists of all CA Datacom SQL PLANs?

CA Datacom online DDOL Interactive SQL Service Facility (ISQL) DISPLAY PLAN displays an index of all the PLANs but I would like a printed list in batch.

Environment

z/OS
z/VSE

Resolution

To get a list of all Datacom SQL Plans like in DDOL ISQL DISPLAY PLAN then run batch DDUTILTY report against the PLAN table. Use SYSIN cards:

-USR name,pwd
-RPT INDEX,PLAN,ALL(PROD) 
-END 



 

Additional Information

Also, CA Datacom Dynamic System Table (DST) SQL_STATUS_PLAN will show only the SQL plans that are currently active in the MUF and can provide additional information.

For example, run DBSQLPR batch utility with SYSIN selecting some of the columns:

SELECT                 

  MUF_NAME,            

  PLAN_AUTHID,         

  PLAN_NAME,           

FROM SQL_STATUS_PLAN ; 

Refer to CA Datacom Core - 15.1 documentation.
Find "SQL_STATUS_PLAN".
Find section "Display Index of SQL Plans" for DDOL ISQL.
Find section "Requested Reports" for DDUTILTY -RPT.