View previous topic :: View next topic
|
Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
Below is the space status of my partitioned tablespace, which has been defined as 22 partitions.
Code: |
Command ===> Scroll ===> CSR
Command - Enter "/" to select action Tracks %Used XT Device
-----------------------------------------------------------------------------
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A001 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A002 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A003 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A004 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A005 12510 ? 1 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A006 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A007 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A008 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A009 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A010 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A011 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A012 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A013 12510 ? 2 3390
CATA01.DSNDBD.TESTDB01.TBEMPC.I0001.A014 12510 ? 2 3390 |
when I unload data from partition 6, I found the partition contains no data. In other words, only partition 1-5 contain data.
I do not understand since partition 6 to 22 contain no data, why it takes as much space (12510 tracks) as the first 5 partitions?[/quote] |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
May be the pertitions were containing some data initially and now it has been deleted. Try running a reorg and then check the space. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
PRIQTY |
|
Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
I use the same PRIQTY and SECQTY for the whole tablespace, but why all partitions except the 5th partition all have extention number 2?
by the way, below is part of the definition:
Code: |
PRIQTY 600000
SECQTY 60000 |
.
I'm using the virtual host environment instead of a real host. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
but why all partitions except the 5th partition all have extention number 2? |
after so much time You should know that the correct term is EXTENT
the number of extents is related only to the fragmentation status of the volume ( amount of space available in contiguous EXTENTS )
once You ask a certain amount of space You might get it in a single extent or multiple extents
nothing You can do about it, and not a symptom of malfunction in se.
Quote: |
I'm using the virtual host environment instead of a real host. |
apart the foggy meaning of the sentence how does that relate to the dasd extents allocated to a dataset? |
|
Back to top |
|
|
|