ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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