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
 

 

Max size of a LDS dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Max size of a LDS dataset
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: 7909
Location: Bellevue, IA

PostPosted: Fri Jul 19, 2013 11:04 pm    Post subject:
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

Senior Member


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

PostPosted: Sat Jul 20, 2013 12:12 am    Post subject:
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    Post subject:
Reply with quote

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

Global Moderator


Joined: 10 May 2007
Posts: 1714
Location: UK

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

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

Site Director


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

PostPosted: Mon Jul 22, 2013 8:24 pm    Post subject:
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    Post subject:
Reply with quote

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

Active User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Mon Jul 29, 2013 6:58 pm    Post subject:
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    Post subject:
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 User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Tue Jul 30, 2013 2:51 pm    Post subject:
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: 1013
Location: India

PostPosted: Tue Jul 30, 2013 3:59 pm    Post subject:
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 User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Tue Jul 30, 2013 6:26 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts Allocate dataset withour BLKSIZE Susanta CLIST & REXX 2 Thu Sep 22, 2016 11:51 am
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm


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