|
|
| Author |
Message |
ubm_ak19
New User
Joined: 07 May 2007 Posts: 10 Location: Pune
|
|
|
|
Friends,
Could anyone of you tell me how to calculate the maximum size of a LDS including with its extents information |
|
| Back to top |
|
 |
References
|
|
 |
Terry Heinze
Active User
Joined: 14 Jul 2008 Posts: 176 Location: Richfield, MN, USA
|
|
|
|
| What is an LDS? |
|
| Back to top |
|
 |
Moved: Tue Jul 22, 2008 9:29 pm by superk From SMS & VSAM to DB2 |
dick scherrer
Global Moderator
Joined: 23 Nov 2006 Posts: 8731 Location: 221 B Baker St
|
|
|
|
Hello,
LDS - Linear Sata Set - the "vsam" file type used for db2 physical database files. |
|
| Back to top |
|
 |
premkrishnan
Active User
Joined: 07 Sep 2006 Posts: 63 Location: Mars
|
|
|
|
Hi,
You can find it from LISTCAT and from allocated space you can do that
This is a portion of LISTCAT OUTPUT
| Code: |
ALLOCATION
SPACE-TYPE------CYLINDER
SPACE-PRI-------------50
SPACE-SEC-------------10
|
|
|
| Back to top |
|
 |
ubm_ak19
New User
Joined: 07 May 2007 Posts: 10 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 |
|
| Back to top |
|
 |
dbzTHEdinosauer
Senior Member
Joined: 20 Oct 2006 Posts: 1639 Location: germany
|
|
|
|
ubm_ak19,
don't you ever read manuals? IBM Redbooks would be a good place to start. |
|
| Back to top |
|
 |
|
|