View - The View database shows no report is on disk or perm but still shows 1 report on the database.
Article ID: 227231
Updated On:
Products
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
/*
//
Feedback
