Using the DATA clause of the CSV Utility LIST ELEMENT function to obtain change statistics.

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL
• Endevor
• Endevor Natural Integration
• Endevor - ECLIPSE Plugin
• Endevor - Enterprise Workbench
• CA 2E

Issue/Introduction

Description:

The DATA clause of the LIST Element function of the CSV Utility offers the possibility to obtain Change statistics of levels of selected elements, as well

as their CCID's and COMMENT's.

Solution:

To obtain the change statistics of elements, one can use the CSV Utility with the DATA ELEMENT CHANGE LEVEL SUMMARY clause in the LIST ELEMENT.

For example:

//CSVIPT01 DD *       
 LIST ELEMENT * 
 FROM ENV ENV1 SYSTEM * SUB * TYPE * STAGE *
 DATA ELEMENT CHANGE LEVEL SUMMARY
 OPTION PATH PHYSICAL RETURN ALL SEARCH

The result (defaults to the APIEXTR DD), will be a comma separated file, that can then be input as such into a spreadsheet program.

A snip of how the spreadsheet results look as illustration:

<Please see attached file for image>

The #STMNTS, #INSERT and #DELETE reflect the changes to a particular change level of the elements.

The CCID and COMMENT columns reflect those of each change level of the element, including that of the Base element.

Note: Especially if a large number of elements will be selected, it can be useful to run the CSV Utility with OPTION NOCSV.

This also produces a record per element, however it is not comma separated, and the various data fields are present in fixed columns.

This makes it possible to process (eg. Sort) the file while still on the Mainframe.

Environment

Release:
Component: C21E