SYSVIEW Performance Management

 View Only

 Report Writer - how to display duplicate values on each row of data

Pat Gwinn's profile image
Pat Gwinn posted Apr 05, 2021 04:42 PM
​​We are trying to replace some of our current CICS statistical reporting with report writer. It is an hourly report showing the CICS transaction volume along with some other fields. We are using Tab and TAB2 to build the report. The issue we are having is that fields that have duplicate values like date,time, applid and lpar are not written to the next row of data. Is there a way to have the date, time, applid or any duplicate data written to the next row of data. We also want to convert this data to a CSV, but the duplicate values do not show there either, we just get the 4 ',' seperators.

The commands we use in the report are -
COPY GSVSMF27                                                
OPTION(MAXTO=NO,SUMMARY=NO,LEAPSEC=1)                        
LINECOUNT 999                                                
DEFINE ID MRO APPLID(5,4)                                    
SELECT TRANID(¬CD*,¬CF*,¬CSK*,¬CSS*,¬CW*)                                                                                  
TAB DATETIME MRO HDR1() HDR2(Applid),                        
    C_LPARNAME HDR1() HDR2(LPAR) SORT ALPHA                   
TAB2 TRANID HDR1() HDR2(Trans*Name) SORT ALPHA           AND,
  TRAN USE FORMAT(NNNNNNN) HDR1() HDR2(Trans*Volume)     AND,
  TRAN CPU HDR1() HDR2(Average*CPU)                      AND,
  TRAN LIFE HDR1() HDR2(Average*Response*(SEC))          AND,
  TRAN MAXLIFE HDR1() HDR2(Max*Response*(SEC))                
EACH HOUR                                                    
END                                                          
RUN          
The Report Writer output looks like this, with blank fields in each row for a duplicate value -

The CSV output looks like this -
William Keenan's profile image
Broadcom Employee William Keenan
Hello Pat,
If you specify OPTION(PRINT=DATETIME) Report Writer will fill in the date and time for each line, however, it will not populate the other fields.  In your case it looks like only the LPAR would not be completely populated.
 
Regards,
Bill