Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


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