IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Max size of a LDS dataset


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Jul 19, 2013 9:55 pm
Reply with quote

Hi,

What is the max LDS data set size which can be created in MVS? I thought the limit was 4GB? but I see a LDS data set having 12GB.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA

PostPosted: Fri Jul 19, 2013 11:04 pm
Reply with quote

The VSAM Demystified Redbook states on page 33 that a linear data set may be extended, so the 4 GB limit would not apply to an extended format LDS.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Sat Jul 20, 2013 12:12 am
Reply with quote

And did you mean zOS? MVS is older than my age ... icon_smile.gif
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Jul 22, 2013 3:39 pm
Reply with quote

Thanks Bob.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK

PostPosted: Mon Jul 22, 2013 5:17 pm
Reply with quote

No "Bob" has entered this discussion!
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Mon Jul 22, 2013 8:24 pm
Reply with quote

Hello,

Quote:
Thanks Bob.

Please address Mr Sample as Robert rather than Bob.

d
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Jul 23, 2013 1:59 pm
Reply with quote

Sure.
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 590
Location: London

PostPosted: Mon Jul 29, 2013 6:58 pm
Reply with quote

And LDS can be much larger than 4GB if you have assigned a Dataclas that has the Extended Addressability attribute. The 4GB is actually a VSAM size limit that applies unless you have the Dataclas that has the Extended Addressability attribute (and Extended Format). The only limit then is the number of allowable extents for VSAM (251) which another Dataclas attribute called Extent Constraint Removal deals with, and if Extent Constraint Removal is in effect the limit 7257 extents.

With a Dataclas that provides both the Extended Format and Extended Addressability and Extent Constraint Removal attributes the dataset can potentially be primary size+(secondary times 122 per volume), times 59 volumes. So depending on the size of the volumes it can be a vast amount.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Jul 30, 2013 2:33 pm
Reply with quote

Thanks Pete for the detailed information.

I have a question, if the LDS datasets are DB2 managed then how/where we can define the dataclass attribute? Is there any Zparm for that?
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 590
Location: London

PostPosted: Tue Jul 30, 2013 2:51 pm
Reply with quote

I'm not sure if it's in ZPARMS or if it's an option when defining an individual Table.

You can ask your Storage team if they would set it up in the SMS Dataclas ACS routines to automatically assign the appropriate Dataclas to your dataset (or a generic dataset mask), and also create the Dataclas if
there isn't already one with the required attributes available.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Tue Jul 30, 2013 3:59 pm
Reply with quote

Gylbharat,

For non-partition tablespaces max size is 64GB, so you will have 32 datasets of 2GB size.
For partition tablespace, each dataset size is limited by DSSIZE parameter. Options available are 1G 2G 4G 8G 16G 32G 64G

Max Size of table DB2 currently supports is 128TB(2048 Partition x 64GB datasets)
More information in SQL Reference in CREATE TABLESPACE

If you want to mention dataclas, check CREATE STOGROUP in SQL Reference

Thanks,
Sushanth
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 590
Location: London

PostPosted: Tue Jul 30, 2013 6:26 pm
Reply with quote

Thanks Sushant, I'll crib that bit of info!

The other issue is TIOT limitations if the tables are spread over too many volumes I believe. (i.e. about 4k of TIOT used for every volume). May not be such an issue now with XTIOT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts batch SFTP job using AOPBATCH unable ... All Other Mainframe Topics 7
No new posts Reading Empty Dataset DFSORT/ICETOOL 5
No new posts Mainframe Dataset Binary or ASCII Mainframe Interview Questions 4
No new posts SPOOL to Mainframe dataset in batch mode JCL & VSAM 7
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
Search our Forums:

Back to Top