Can I produce a statistics report like the one from the CA Datacom MUF shutdown, but while the MUF is still running?
Article ID: 40242
Updated On:
Products
Issue/Introduction
Introduction:
When a CA Datacom MUF shuts down, a comprehensive report of activity and statistics for databases is produced. When a MUF runs for weeks or months at a time, the one-time summary information may not be useful to identify trends or predict future growth needs.
Question:
Can I produce a statistics report like the one from the CA Datacom MUF shutdown, but while the MUF is still running?
Answer:
There is a console/console-like command that can be issued to produce most of this information. The report is called the “All Info Report” and as noted in the CA Datacom/DB Database and System Administration Guide, “generates a concisely formatted report containing comprehensive information. Except for a few differences because the MUF has not ended, the information in the report is the same as that provided in EOJ reports when the MUF has ended. For example, the report does not provide the task information page showing the status of tasks.”
As with most console and console-like commands, there are three ways of issuing this command:
- From the operating system console, using MODIFY
- Through SQL, using the SQL_CONSOLE (SQX) Dynamic System Table
- With the DBUTLTY program, using the function COMM OPTION=CONSOLE,OPTION2=
The general syntax of the command is
ALL_INFO_REPORT xxxxx, where xxxxx is any of the following data sets in z/OS: PXX, PXXDD, PXXDST, PXXCBS, or PXXSQL.
Below are examples of the command being issued, with the results being sent to the PXXDST file.
Example #1 – From the operating system console
/F mymuf,ALL_INFO_REPORT PXXDST
Example #2 – Using the SQL_CONSOLE Dynamic System Table
For example, using the DBSQLPR program:
//SYSIN DD *
INSERT INTO SYSADM.SQL_CONSOLE
VALUES('mymuf ',’ALL_INFO_REPORT PXXDST');
/*
Example #3 – Using the DBUTLTY function COMM OPTION=CONSOLE
//SYSIN DD *
COMM OPTION=CONSOLE,OPTION2=’ALL_INFO_REPORT PXXDST'
/*
Additional Information:
For more information about producing the All Info Report, please refer to the following Guides:
CA Datacom/DB Version 14.02 Database and System Administration Guide, in the section “Introduction › Maintenance using Console Commands”
CA Datacom/DB Version 15.0 Database and System Administration Guide, in the section “Introduction › Maintenance using Console Commands”
As always, please contact CA Technologies support for CA Datacom if you have further questions.
Environment
Component: DB
Feedback
