View previous topic :: View next topic
|
Author |
Message |
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
I have created a segmented tablesspace with only One table in that that tablespace.
However I observed something strange, Tablespace has extents 5 even if the table is empty (Zero Rows).
Can any one explain this? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
probably an allocation <feature> ...
is the total space allocated equal to the initial space request
if yes then the volume has a fragmentation issue
generally , unless specifically requested, there is no guarantee that the initial allocation will be satisfied with a <single> extent |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Sorry... I didnot get you completely... Are you saying... say I request Primary Quantity as 100 Cyls , there was not enough space in any volume (STORAGE Group) which could allocate 100 Cyls in Single Extent?
Please let me know if this understanding is correct. In such cases how do I make sure it spans in 1 Extent? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Yes, I do not remember the exact sequence for the choice of eligible volumes
1) search for a volume with the total space requested available
2) search for a volume with the total space requested available in a single extent
at a certain point as many extents needed will be allocated
if <requested> and no contiguous space is available You will get IIRC a jcl error
are You defining the CLUSTER or are You letting DB2 do it under the covers ? |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Quote: |
are You defining the CLUSTER or are You letting DB2 do it under the covers ? |
We are not defining the table index to be clustered. As by default 1st index will act as clustering index.
How we can make it to 1 Extent? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
I am creating DB2 managed tablespaces. No I dont have control on defining LDS. |
|
Back to top |
|
|
|