|
View previous topic :: View next topic
|
| Author |
Message |
neoconvoy
New User
Joined: 22 Jul 2006
Posts: 9
|
|
|
|
I did a LISTCAT on a few online VSAM files and they had this incorrect statistics. I had a problem with one of them when I tried to perform a DFSORT. The utility was trying to dynamically allocate SORTWK areas, but failed because apparently the statistics information made DFSORT think that that was a very large file, and required a lot of SORTWK.
My question is how does this incorrect statistics situation arise, and besides doing a delete and define of the file, is there any other way rectifiy the statistics.
STATISTICS (* - VALUE MAY BE INCORRECT)
REC-TOTAL--------------1* SPLITS-CI--------------0* EXCPS---------------3246*
REC-DELETED------------8* SPLITS-CA--------------0* EXTENTS-------------1
REC-INSERTED-----------4* FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED-----------42* FREESPACE-%CA----------0 X'C10261C2C43AD1C9'
REC-RETRIEVED------13286* FREESPC-----------505856* |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
To reset the stats will be a DEL/DEF.
VSAM files are tricky because the stats are only updated at close of file, so if you have a file that's online for weeks on end, then the stats are only valid at the point of last close of file. |
|
| Back to top |
|
|
|
|
