Can I produce a statistics report like the one from the CA Datacom MUF shutdown, but while the MUF is still running?

book

Article ID: 40242

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

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:

  1. From the operating system console, using MODIFY
  2. Through SQL, using the SQL_CONSOLE (SQX) Dynamic System Table
  3. 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 “IntroductionMaintenance using Console Commands 

CA Datacom/DB Version 15.0 Database and System Administration Guide, in the section “IntroductionMaintenance using Console Commands

As always, please contact CA Technologies support for CA Datacom if you have further questions.

Environment

Release:
Component: DB