View - Discrepancy in database statistics

book

Article ID: 221869

calendar_today

Updated On:

Products

CA View

Issue/Introduction

I am seeing a discrepancy in the number of sysouts in View.

If I do a 'STATUS' command, I see a much larger number of Total Sysouts than if I remove all filters and, sort the output by a column, and see the number of lines displayed. The number of lines displayed is usually 25%-30% of what the Total Sysout shows.

Why is the difference so large? Is it because the STATUS command includes the different DD sysout and the number of lines shown does not?

Environment

Release : 14.0

Component : CA View

Resolution

It is possible that the View STATUS command can show database statistics that are out of synch with what is actually happening with the database. 

The way to get them back in synch would be to:

 . . Bring down the View SARSTC task (with "/P sarstc"). 
 . . Run SARDBASE SET STATS:

//XXXXXXXX JOB ...                                                
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW_HLQ'  <=== MODIFY DB NAME 
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD     <=== MODIFY, IF USED
//SYSPRINT DD  SYSOUT=*                                           
//SYSIN    DD *                                                   
SET STATS                                                         
/*
//
                                                                
 . . Start the View SARSTC task (/S sarstc). 

After performing the above, log on to View, and issue command "STATUS" at the Primary panel, to see the synchronized statistics.