Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in


Incorrect Statistics in Listcat

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message

New User

Joined: 22 Jul 2006
Posts: 9

PostPosted: Mon Sep 03, 2007 11:32 pm    Post subject: Incorrect Statistics in Listcat
Reply with quote

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.


REC-TOTAL--------------1* SPLITS-CI--------------0* EXCPS---------------3246*

REC-DELETED------------8* SPLITS-CA--------------0* EXTENTS-------------1


REC-UPDATED-----------42* FREESPACE-%CA----------0 X'C10261C2C43AD1C9'

REC-RETRIEVED------13286* FREESPC-----------505856*
Back to top
View user's profile Send private message


Global Moderator

Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Sep 04, 2007 3:06 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts listcat jcl GDG with relative genrati... sumitmalik29 JCL & VSAM 3 Sat Jul 11, 2015 6:27 pm
No new posts Alternatives to LISTCAT jerryte CLIST & REXX 3 Thu Feb 26, 2015 9:47 pm
No new posts Multiple LMCOPY resulting incorrect copy k.junaid83 CLIST & REXX 1 Tue Sep 02, 2014 7:22 pm
No new posts IEF210I - Unit field specifies incorr... Kamil Tluczek JCL & VSAM 8 Mon Apr 07, 2014 1:19 pm
No new posts Select query in cobol db2 pgm returni... faizm DB2 8 Mon Mar 31, 2014 4:03 pm

Back to Top
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us