[Default] On 30 Aug 2020 15:12:07 -0700, in bit.listserv.ibm-main
stars...@mindspring.com (Lizette Koehler) wrote:

>List -
>
> 
>
>I have a VSAM Dataset that has grown over the years.  When it was set up -
>the INDEX space was left to default
>
One other thing to check for in addition to the other recommendations
given is whether or not the file should have grown this large.  I ran
into a case in one shop I was at where records were getting on the
file but because of a coding error only certain ones were getting
updated and removed.  I was a systems programmer who went back into
applications and was actually tracking down why a run time had
increased.

Clark Morris
>
>I am wondering if it makes sense to override the Track Allocation and put it
>in Cylinders.
>
> 
>
>We are noticing a little bit of an increase in run time during reorg.  I was
>wondering if this might be due to the data set having 3.4GB now.  This file
>is EA/EF so it can grow
>
> 
>
>Over 4500 Cylinders on the Data 
>
>And the index is using tracks 2 pri and 11 sec - size is now 2.4 MB
>
> 
>
> 
>
>During reorg we offload records to an archive then reload the current data
>back in.
>
> 
>
>This may be something I cannot improve on, just thought I would see if there
>are any insights I am missing.
>
> 
>
>Process:
>Offload the data to a temp file
>
>Archive records older than 2 weeks
>
>Del/Def VSAM dataset
>
>Reload current records to VSAM dataset
>
> 
>
>This runs daily
>
>
>Thank you 
>
> 
>
>Lizette
>
>
>----------------------------------------------------------------------
>For IBM-MAIN subscribe / signoff / archive access instructions,
>send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to