Print list of all Datacom SQL PLANS
Article ID: 98939
DATACOM - AD
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.
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:
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:
FROM SQL_STATUS_PLAN ;
Refer to CA Datacom Core - 15.1
Find section "Display Index of SQL Plans" for DDOL ISQL.
Find section "Requested Reports" for DDUTILTY -RPT.