View previous topic :: View next topic
|
Author |
Message |
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
And did you mean zOS? MVS is older than my age ... |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Thanks Bob. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
No "Bob" has entered this discussion! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Please address Mr Sample as Robert rather than Bob.
d |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Sure. |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 590 Location: London
|
|
|
|
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 |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
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 |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 590 Location: London
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 590 Location: London
|
|
|
|
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 |
|
|
|