View - The View database shows no report is on disk or perm but still shows 1 report on the database.

book

Article ID: 227231

calendar_today

Updated On:

Products

View

Issue/Introduction

My database shows that no report is on disk or perm, but still shows 1 report on the database.  

When I use the online "status" command, I get the following:

    Total                                  
 Sysouts              --->          38,529 
                                           
    On Disk                                
 Sysouts              --->               1 
 Lines                --->      31,549,646 
 Percentage Usage     --->              37 
                                           
    Index                                  
 Percentage Usage     --->              28 

I don't believe I have any reports on database. 

All retention values are set to 0 days for disk.  

How can I determine what report it thinks is really there?

Environment

Release : 14.0

Component : CA View

Resolution

If in your Sysout Selection List you show no reports with a Location of DISK, PDSK, PERM, PTMP, or TEMP, then there are no reports on the disk layer. 

It is possible that the statistics shown by the STATUS command, especially over time, can start to be inaccurate. 

To reset the statistics, you would do the following:

 . Stop the View tasks. 
 . Run SARDBASE SET STATS. 
 . Start the View tasks. 

If after checking the above locations, you see no reports in those locations, then you can be confident that no reports are on the disk layer. 

The View panels, banners, and SARINIT parameters are stored in the database DATA space. 

With that, even with no sysouts, there will still be some DATA usage showing for those elements. 

To definitively see how much space is being used on the database, you can run a SARDBASE STATUS FULL:

//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 *                                                   
STATUS FULL                                                       
/*                                                                
//