Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How many records can be fit into a particular dataset

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

New User


Joined: 16 Nov 2005
Posts: 23

PostPosted: Thu Apr 27, 2006 6:03 pm    Post subject: How many records can be fit into a particular dataset
Reply with quote

Homwmany records can be fit into a particular dataset which has info like this Record format . . . : FB
Record length . . . : 80
Block size . . . . : 27920
1st extent blocks . : 2
Secondary blocks . : 1
Thanks in advance
Back to top
View user's profile Send private message

mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Fri Apr 28, 2006 8:02 am    Post subject:
Reply with quote

I calc 5933 recs total max:

1 blk = 27920/80 bytes = 349 recs

1st ext = 2 blks = 349 recs * 2 = 698 recs
2ndary ext = 1 blk = 349 recs * 15 2ndary exts = 5235 recs
Total alloc = 1st ext + 15 2ndary = 698 + 5235 recs = 5933 recs total max depending on space available on the volume.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Fri Apr 28, 2006 8:31 am    Post subject: Re: JCL Doubt
Reply with quote

I have always been told the same as you Frank, 1 primary and up to 15 secondary extents, depending upon availability of space.

However, when I tested it at my site, I allocated 50 blocks for a total of 17450 records. At extent 10, the system started to increase the extent size for each additional extent. There must be an available site controlled algorithm for this!

Dave
Back to top
View user's profile Send private message
Bharanidharan

New User


Joined: 20 Jun 2005
Posts: 86
Location: Chennai, India

PostPosted: Fri Apr 28, 2006 9:21 am    Post subject: Re: JCL Doubt
Reply with quote

Dave,
Do you have any space controller/supervisor installed in your system? Two years earlier, we were having serious space issues due to the huge volume of records added in the files and we were getting frequent space abends because of the py and sy extents having been exceeded. Owing to that, my mainframe admins have installed something called "SPACE-X" around 2 years earlier (not sure who supports it). This would do the same thing you described. So I guess system does not automatically increase the extents.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Fri Apr 28, 2006 9:52 am    Post subject: Re: JCL Doubt
Reply with quote

Bharani,

I do believe you are correct; we have a package that was installed several years ago to help with space abends. It must have it's hooks in supplied 'exits' or replaced some of the system allocation routines.

I was just surprised at the result. I was fully expecting the number of records Frank came up with, I try to allocate the max records within 3 extents, so unless I?ve grossly miscalculated the number of records output I rarely see space abends.


Dave,
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 Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Merge 2 records sancraig16 SYNCSORT 19 Tue Mar 27, 2018 8:17 pm
No new posts How could i share my personal dataset... James Halley TSO/ISPF 1 Fri Mar 23, 2018 9:41 pm
This topic is locked: you cannot edit posts or make replies. How could i share my personal dataset... samenxia163 TSO/ISPF 1 Fri Mar 09, 2018 12:18 pm
No new posts Copy set of records based on condition krish.deepu SYNCSORT 2 Thu Mar 08, 2018 11:39 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us