Fail to run Sysview report with 'To' option, no records selected
search cancel

Fail to run Sysview report with 'To' option, no records selected

book

Article ID: 242777

calendar_today

Updated On:

Products

SYSVIEW Performance Management

Issue/Introduction

When running a Sysview report by adding the TO statement, seems influencing SMF data extracted and then produces nothing.
For example, when running this report :

COPY GSVSMF28                                                    
FROM -1 DAYS AT 00:00:00                                         
TO   -1 DAYS AT 23:59:59                                         
EACH 1 DAY                                                       
TAB DATETIME,                                                    
    CICS_JOBNAME,                         HDR1( ) HDR2(JOBNAME ),
    CICS INTERVAL SYSTEM CICS_TRANGSVI    HDR1( ) HDR2(TRANSVOL) 
END                                                              
RUN                    

Without the TO statement, it gives report output on the CICS transaction counts..
When specifying the TO statement, the report does show no results:

ERPT231I NO ERRORS FOUND IN CONTROL CARDS                   
ERPT232I TAPSMF   OPENED                                    
ERPT233I TAPSMF   CLOSED                                    
ERPT278I            1 TAPSMF  RECORDS                       
ERPT221E NO MATCHING DATA                                   
ERPT258I RECORDS READ BY REPORT WRITER :                1   
ERPT259I RECORDS WITHIN TO/FROM RANGE :                 0   
ERPT230I RUN COMPLETED SUCCESSFULLY                         
ERPT200I XPFRRPT 16.0 COMPLETED 05/31/22 03.12.07                                                    

Environment

Release : 16.0

Component : SYSVIEW

Cause

The way the records are stored and read from the SMF dataset.

Resolution

Add the OPTION(MAXTO=NO) statement to the report statements:

OPTION(MAXTO=NO)
FROM -1 DAY AT 00:00:00
TO   -1 DAY AT 23:59:59

Additional Information

Please see MAXTO explanation on the OPTION Command - Define Report Options section of the Sysview documentation