Print list of all Datacom SQL PLANS

Document ID : KB000098939
Last Modified Date : 31/05/2018
Show Technical Document Details
Question:
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
Answer:
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.