How to calculate the size of an LDS

ubm_ak19 · New User Joined: 07 May 2007 Posts: 8 Location: Pune

Friends,

Could anyone of you tell me how to calculate the maximum size of a LDS including with its extents information

Terry Heinze · Posted: Tue Jul 22, 2008 9:16 pm

What is an LDS?

dick scherrer · Posted: Tue Jul 22, 2008 10:12 pm

Hello,

LDS - Linear Sata Set - the "vsam" file type used for db2 physical database files.

Pandora-Box · Posted: Wed Jul 23, 2008 8:22 am

Hi,

You can find it from LISTCAT and from allocated space you can do that

This is a portion of LISTCAT OUTPUT

ubm_ak19 · New User Joined: 07 May 2007 Posts: 8 Location: Pune

Hi Premkrishnan,

Thanks for your help.
One more thing which strikes my mind is whenever for a Dataset primary space gets full , the dataset takes into account of secondary space and i want to know how any DBMS (for example:DB2) will take the extents concept here.

In the example told by you , you have mentioned the LDS primary alloc is 50 cyl and secondary alloc is 10 cyl , so what can be the maximum size of this LDS taking into account with its secondary allocation with extents.

Could you please help me out here.

Thanks in advance

regards

dbzTHEdinosauer · Posted: Wed Jul 23, 2008 11:38 am

ubm_ak19,

don't you ever read manuals? IBM Redbooks would be a good place to start.