Running Reports

You can submit batch jobs through the ChangeMan ZMF client to run reports that help you manage components, packages, and applications.

About Reports

ChangeMan ZMF reports display information about global and application administration, change packages, and components managed by ChangeMan ZMF. Information for reports comes from the package master and from component history file.

Batch report jobs are initiated online, or jobs can be submitted manually. Batch reporting jobs communicate with a running ZMF instance to access package and component data, but report jobs can also use copies of the online data.

Rules for Running Reports

These rules and restrictions apply to the ChangeMan ZMF reporting function:

Global and Application administrators determine what ChangeMan ZMF reports appear on user panels in the ISPF interface.
A report requestor must have READ access to an application in your security system to collect information for a ZMF report from that application.
If you request a report for multiple applications and you do not have READ access to one of those applications, the data for that application is omitted from the report.

Accessing Reports

Reports are requested from the Report Selection List panel (CMNREPT6).

Use one of these methods to access ZMF report functions:
- Using the Menu Hierarchy:
  
  On the Primary Option Menu, select 6 Reports.
- Using Direct Panel Access:
  
  On a ChangeMan ZMF panel, type =6 in the Command or Option line and press Enter.
If you license the ChangeMan ZMF Db2 Option, the Submit Batch Reports menu (CMNREPTD) is displayed.
- Select 1 General and press Enter.
- Option 2 Db2 is only functional if you license the ChangeMan ZMF Db2 Option. See the ChangeMan ZMF Db2 Getting Started Guide for instructions.
On the Generate Batch Reports panel (CMNREPT5), type your Job Statement Information and press Enter to display the Report Selection List panel (CMNREPTA).

Generating ChangeMan ZMF Batch Reports

This section provides instructions for requesting ChangeMan ZMF general batch reports online and manually submitting batch reporting jobs.

Submitting Batch Report Jobs Online

You request one or more ChangeMan ZMF Reports using the Report Selection List panel (CMNREPTA).

Type report filter criteria and variables in the fields at the top of the panel. Select the reports you want to run from the list at the bottom of the panel.

...

CMNREPTA                           Report Selection List                              Row 1 to 3 of 3
Command ===>                                                                        Scroll ===> CSR

Application mnemonic . . . . GENL
Package number . . . . . . .
Report variable . . . . . . __________________________________________________________________ +
Date range: from . . . . .  (yyyymmdd)
            to . . . . . .  (yyyymmdd)
Enter "/" to select option
  __ Extended Report
  __ Mixed Case

Id Report description
__ 080 Package Component Content
__ 400 Package Promotion Component
__ 500 Package Information Report
******************************* Bottom of data ********************************

Scroll up and down in the report list to select and deselect reports before you submit the request. You can press Enter to see what reports you have selected and deselected, as shown on the example above.

Note

The global and application administrators determine the reports that you are authorized to run. Only the reports that you are authorized to run are shown on the Report Selection List panel (CMNREPTA).

The following table describes the fields on the Report Selection List panel (CMNREPT6).

Field	Description
	ChangeMan ZMF will submit a batch job to produce the reports selected from this list. This panel is scrollable. Enter S to select one or more reports; Enter D to "de-select" a report that you have selected in error.
Application mnemonic	The full 4-character application mnemonic or a pattern that consists of one or more characters of the application mnemonic followed by an asterisk. If you specify a pattern, all applications that match the pattern are included in the report. Note: The following reports cannot be filtered by application: CMN900, CMN980, CMN990, CMN992 *GEN``: Identifies application names beginning with GEN GENL: Identifies an application named GENL. Blank:** Assumes `’*’`s
Package number	The 6-character package number or a pattern that consists of one or more characters of the package number followed by an asterisk. If you specify a pattern, all packages that match the pattern are included in the report. A blank assumes ``. The value of the Application Mnemonic and the Package Number field together determine the package or packages to include in the report. The Package Number is ignored if you specify a pattern for the Application Mnemonic. For example: - If Application Mnemonic is GENL and Package Number is 000022, the report only contains information about package GENL000022. - If Application Mnemonic is GEN``, all packages in all applications whose names begin with the characters GEN are included in the report. - If Application Mnemonic is GENL and Package Number is 00002``, all packages whose names match the pattern GENL00002`x*` are included in the report.
Report variable	A variable (other than the Application Mnemonic or the Package Number) or a pattern that consists of one or more characters of the variable value followed by an asterisk. If you specify a pattern, all items that match the pattern are included in the report. Blank assumes `*`.
Date range from	Optionally type a From date in the format yyyymmdd. If you omit this field, the date 19600101 (January 1, 1960) is used by default
Date range to	Optionally type a To date in the format yyyymmdd. If you omit this field, today’s date is used by default.
Extended Report	Select to append an 'E' to the selected report ID to execute a version of the REXX report program that expands component names to 256 bytes, and dataset names to 1024 bytes. Use this option when managing zFS components. If not selected it will execute the standard REXX report program that assumes 8 character component names and 44 character dataset names.
Mixed Case	Select to process Name input exactly as you type it, upper and lower case. If not selected, by default, all fields will input to upper case regardless of the case that you type.
Report selection field	Enter one of the following values in the selection field to the left of the Report ID: - S: Select this report. - D: Deselect a report that you have selected by mistake.
Report Id	The 3-character report identification number.
Report description	Description of report content.

The following table lists all of the reports that are shipped with ChangeMan ZMF. It identifies the input fields and date range that applies to each report.

Rpt #	Report Title	Input Fields	Date Range
010	Summary of Planned and Unplanned Packages	Appl Mnemonic	N/A
050	Installed Package History Report	Appl Mnemonic Package Number	Package Install Date
060	Installed Simple Package History Report	Appl Mnemonic Package Number	Package Install Date
070	Package Staging Versions (see note 1)	Appl Mnemonic Package Number	Package Create Date
080	Package Component Content	Appl Mnemonic Package Number	Package Create Date
090	Super/Complex Packages Report	Appl Mnemonic Package Number	Package Create Date
100	Application Configuration Report	Appl Mnemonic	N/A
110	Work Request Number Report	Appl Mnemonic Package Number Work Chg Req Nbrb (see note 2)	Package Create Date
120	Unplanned Packages Pending Post Approval	Appl Mnemonic Package Number	Package Install Date
130	Report of Backed Out Packages	Appl Mnemonic Package Number	Package Backout Date
140	Report of Rejected Packages	Appl Mnemonic Package Number	Approver Reject Date
160	Trend Analysis of Planned Packages	Appl Mnemonic Package Number	Package Install Date
180	Component History Report	Appl Mnemonic Package Number Component Name(see note 2)	Changed Date
185	Component Build Report	Appl Mnemonic Package Number Component Name(see note 2)	Changed Date
190	Trend Analysis of Unplanned Packages	Appl Mnemonic Package Number	Package Install Date
200	Copies, Source and Load Component Report	Appl Mnemonic Package Number	Changed Date
210	Utility (Scratch/Rename) Report	Appl Mnemonic Package Number	Package Create Date
240	Activity Summary by Application	Appl Mnemonic	N/A
260	Implementation Schedule	Appl Mnemonic Package Number	Package Install Date
400	Package Promotion Component Report	Appl Mnemonic Package Number	Package Create Date
500	Package Information Report	Appl Mnemonic Package Number	Package Create Date
900	Designated Procedures Report	Component Name(see note 2)	N/A
910	Packages Using the CMN Scheduler	Appl Mnemonic Package Number	Package Install Date
920	Staging Library Aging Report	Appl Mnemonic	(see Note 3)
930	Package Aging Report	Appl Mnemonic	(see note 4)
940	Component Aging Report	Appl Mnemonic	(see note 5)
950	Report of Delinquent Packages	Appl Mnemonic Package Number	Package Install Date
960	Component Level Security Report	Appl Mnemonic Component Name (see note 2)	N/A
970	Packages Pending Approval by Application	Appl Mnemonic Package Number (see note 6)	Package Install Date
980	Implementation Calendar Report	Site Name (see note 2)	N/A
985	Implementation Calendar Summary Report	Site Name (see note 2)	N/A
990	Global Administration Configuration Report	none	N/A
992	Global Environment Report	none	N/A

Notes

The Package Staging Versions Report (CMN070) dynamically allocates the staging libraries. The report may take a long time to run if staging libraries have been migrated.
Specify this value in the Report Variable field.
Date parameters are set by the AGING - STAGING DATASETS field on the appl Parameters Part 3 of 3 panel (CMNGLP03) in application administra- tion.
Date parameters are set by the AGING - INSTALLED PACKAGES field on the appl Parameters Part 3 of 3 panel (CMNGLP03) in application adminis- tration.
Date parameters are set by the AGING - COMPONENT HISTORY field on the appl Parameters Part 3 of 3 panel (CMNGLP03) in application administra- tion.
Displays all package approver entities and their associated approval status.

Press PF3 to run the selected reports, or type End on the Command line and press Enter.

Note

If you specify a filter field or variable that does not apply to a selected report, the field is ignored when the report data is collected.

Viewing Report Output

Report output is written to DDname SYSTSPRT.

//SYSTSPRT DD SYSOUT=*,DCB=(RECFM=VBA,LRECL=2044,BLKSIZE=2048)

This is defined with attributes RECFM=VBA and LRECL=2044. (The LRECL=2044 value allows scrolling left and right in sdsf when reports contain long filenames or dataset names.) The first character of each report record is a print control character.

If you request multiple reports in the same job, each report is executed in a separate job step that is named REPnnn, where nnn is the report number.

Use a facility such as the System Display and Search Facility (SDSF) to view report output online.

Manually Submitting a Batch Report Job

Instead of submitting report jobs online through the ISPF user interface, you may be able to submit your own batch jobs outside of ChangeMan ZMF to generate reports.

Ask your ChangeMan ZMF administrator about:

Custom ZMF report JCL configured for manual submission
Whether the ZMF instance must be running or if separate VSAM package master and component history files have been populated for offline batch reporting.

Writing Custom Reports

Reports CMNU00-99 are reserved numbers for user written reports. All parameters are passed to these reports and you must validate or ignore used and unused parameters.

Parameters passed in order are:

release name
release area
optional variable
application
package number (appended to application with no space)
subsys
tso id
from date
to date
sort option
test option

You must handle unused variables even though they will not be validated because they are positional for subsequent variables.

So for example, a report which does not make use of release variables could have the following parse statement:

parse var parmargs null1 null2 optionalvar appl ... srtopt tst

where null1 and null2 are just not used.

This statement must match the parse statement in the actual report.

Use Case Scenario

The following Report Selection List (CMNREPTA) panel requests the 070 Package Staging Versions Report and the 080 Package Component Content report.

...

CMNREPTA                           Report Selection List                        Row 1 to 4 of 4
Command ===>                                                                   Scroll ===> CSR

Application mnemonic . . . . ACTP
Package number . . . . . . . 00001*
Report variable . . . . . .                                                                  +
Date range: from . . . . .            (yyyymmdd)
            to . . . . . .            (yyyymmdd)
Enter "/" to select option
  __ Extended Report
 __ Mixed Case

  Id Report description
s 070 Package Staging Versions Report                         *SELECT
s 080 Package Component Content
  400 Package Promotion Component
  500 Package Information Report
******************************* Bottom of data ********************************

All packages with names in the range from ACTP000010 through ACTP000019 are requested for the reports.

This is the first online page of the 070 Package Staging Versions Report displayed in SDSF in job USER016 J0556970 at DDNAME SYSTSPRT and StepName REP070.

...

SDSF OUTPUT DISPLAY USER016    J0556970  DSID     102 LINE 0             COLUMNS 01- 80
COMMAND INPUT ===>                                                      SCROLL ===> CSR
********************************* TOP OF DATA ********************************
1Report CMN070 generated from subsystem:  6 on:  3 Feb 2015 at: 14:48:56 Page: 1
0Date Range: 1 Jan 1960 to 3 Feb 2015
  ------------------------
  Package Staging Versions
  ------------------------
  Package    Component  Component Version Update   Lock     Date Last   Time Last
  Name       Name       Type      Level   Userid   Userid   Modified    Modified
  ---------- ---------  --------- ------- -------- -------- ---------   ---------
  ACTP000013 ACPSRCCC   SRC       STG     USER016  USER015  20150105    145644
  ACTP000013 ACPSRCCC   SRC       BAS     USER016           20150105    145603
  ACTP000013 ACPSRCCE   SRC       STG     USER016  USER015  20150105    145741
  ACTP000013 ACPSRCCE   SRC       BAS     USER016           20150105    145610
  ACTP000013 ACPSRCSA   SRC       STG     USER016  USER015  20150105    145815
  ACTP000013 ACPSRCSA   SRC       BAS     USER016           20150105    145631
  ACTP000013 ACPSRC2A   SRC       STG     USER016  USER015  20150105    145916
  ACTP000013 ACPSRC2A   SRC       BAS     USER016           20150105    145643
  ACTP000013 ACPSRC4A   SRC       STG     USER016  USER015  20150105    145941
  ACTP000013 ACPSRC4A   SRC       BAS     USER016           20150105    145735
  ACTP000013 ACPSRC6A   SRC       STG     USER016  USER015  20150105    145957

This is the first online page of the 080 Package Component Content report displayed in SDSF in job USER016 J0556975 at DDNAME SYSTSPRT and StepName REP080.

...

SDSF OUTPUT DISPLAY USER016    J0556975   DSID   102   LINE 0         COLUMNS 02- 81
COMMAND INPUT ===>                                                   SCROLL ===> CSR
********************************* TOP OF DATA *********************************
Report CMN080 generated from subsystem: 6 on: 3 Feb 2015 at: 14:57:38 Page: 1
Date Range: 1 Jan 1960 to 3 Feb 2015
--------------------------
Package Component Contents
--------------------------
Package    Component  Component         Component   Lock     Recompile/
Name       Name       Type     Language Status      Status   Relink
---------- ---------  --------- ------- ---------   ------   ----------
ACTP000020 ACPCPY2B   CPY                Frozen     N
ACTP000020 ACPCPYCA   CPY                Frozen     N
ACTP000020 ACPCPYCB   CPY                Frozen     N
ACTP000020 ACPCPYCC   CPY                Frozen     N
ACTP000020 ACPCPYCD   CPY                Frozen     N
ACTP000020 ACPCPYCE   CPY                Frozen     N
ACTP000020 ACPCPYCF   CPY                Frozen     N
ACTP000020 ACPCPYSA   CPY                Frozen     N
ACTP000020 ACPCPYSB   CPY                Frozen     N
ACTP000020 ACPCPY00   CPY                Frozen     N
ACTP000020 ACPCPY01   CPY                Frozen     N