Running Batch report ARCISTD to output the data in CSV format
search cancel

Running Batch report ARCISTD to output the data in CSV format

book

Article ID: 369730

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In the CSV file, the first column appears to contain the report name (i.e. ARCISTD), the second column contains "SubrequestID" and it seems to write line 1 with Db2 statistics data, and line 2 with blank, similar to the snippet below:

How to stop the report containing the Blank line 2?

Environment

z/os DB2

Cause

Record Formatting

Resolution

Modify the ARCISTD request to only write out the "subrequestid" 1 or 2, but not both. To do that, just create a copy of the request in a seperate  library and delete all the lines from here: 

<< SUBSYS-HWM                                      
X'0002'    (OF=A2)

to here: 

#IFEND  
>>