Table space and index extents report
The Table Space and Index Extents Report lists the allocated space, used space, and number of extents for Db2 table spaces and index spaces that equal or exceed the specified number of extents.
The report sorts objects by percentage of space limit in descending order.
The following figure is an example of a Table space and index extents report.
Table Space and Index Extents Report
TABLE SPACE AND INDEX EXTENTS REPORT PAGE 1
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
A
DBNAME TSNAME PART PQTY SQTY U SPACE EXT
-------- -------- ---- ------- ------- - --------- ---------
QZUDAC QZUS01AC 4 1 1 C 1575 14
QZUDAC QZUS01AC 1 1 1 C 420 7
QZUDAC QZUS01AC 2 1 1 C 420 7
QZUDAC QZUS01AC 3 1 1 C 420 7
QZUDAC QZUS02AC 1 1 1 C 420 7
QZUDAC QZUS02AC 2 1 1 C 420 7
QZUDAC QZUS02AC 3 1 1 C 420 7
QZUDAC QZUS02AC 4 1 1 C 420 7
QZUDAC QZUS03AC 1 1 1 C 420 7
QZUDAC QZUS04AC 0 1 1 C 420 7
QZUDAC QZUS05AC 0 1 1 C 420 7
QZUDAC QZUS06AC 0 1 1 C 420 7
QZUDAC QZUS07AC 0 1 1 C 420 7
QZUDAC QZUS08AC 0 1 1 C 420 7
TABLE SPACE AND INDEX EXTENTS REPORT PAGE 2
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
A
DBNAME CREATOR IXNAME PART PQTY SQTY U SPACE EXT
-------- -------- ------------------------------ ---- ------- ------- - --------- ---------
QZUDAC QZU QZUX05_DACS08T01 0 1 1 C 1365 28
QZUDAC QZU QZUX05_DACS03T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS04T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS05T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS06T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS07T01 0 1 1 C 2040 16
QZUDAC QZU QZUX03_DACS08T01 0 1 1 C 615 14
QZUDAC QZU QZUX05_DACS01T01 4 1 1 C 990 11
QZUDAC QZU QZUX05_DACS02T01 4 1 1 C 990 11
QZUDAC QZU QZUX03_DACS03T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS04T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS05T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS06T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS07T01 0 1 1 C 825 10
QZUDAC QZU QZUX07_DACS01T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS02T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS03T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS04T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS05T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS06T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS07T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS08T01 0 1 1 C 420 9
QZUDAC QZU QZUX06_DACS08T01 0 1 1 C 225 8
QZUDAC QZU QZUX03_DACS01T01 4 1 1 C 420 7
QZUDAC QZU QZUX03_DACS02T01 4 1 1 C 420 7
QZUDAC QZU QZUX05_DACS01T01 1 1 1 C 315 6
QZUDAC QZU QZUX05_DACS01T01 2 1 1 C 315 6
QZUDAC QZU QZUX05_DACS01T01 3 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 1 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 2 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 3 1 1 C 315 6
QZUDAC QZU QZUX06_DACS03T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS04T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS05T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS06T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS07T01 0 1 1 C 315 6
QZUDAC QZU QZUX03_DACS01T01 1 1 1 C 150 4
QZUDAC QZU QZUX03_DACS01T01 2 1 1 C 150 4
QZUDAC QZU QZUX03_DACS01T01 3 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 1 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 2 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 3 1 1 C 150 4
QZUDAC QZU QZUX06_DACS01T01 4 1 1 C 150 4
QZUDAC QZU QZUX06_DACS02T01 4 1 1 C 150 4
QZUDAC QZU QZUX01_DACS03T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS04T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS05T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS06T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS07T01 0 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 1 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 2 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 3 1 1 C 45 2
TABLE SPACE AND INDEX EXTENTS REPORT PAGE 3
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
Input Parameters
DEMO ASUvrDDR QZUDAC 0
ssid plan dbname extents
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
A
DBNAME TSNAME PART PQTY SQTY U SPACE EXT
-------- -------- ---- ------- ------- - --------- ---------
QZUDAC QZUS01AC 4 1 1 C 1575 14
QZUDAC QZUS01AC 1 1 1 C 420 7
QZUDAC QZUS01AC 2 1 1 C 420 7
QZUDAC QZUS01AC 3 1 1 C 420 7
QZUDAC QZUS02AC 1 1 1 C 420 7
QZUDAC QZUS02AC 2 1 1 C 420 7
QZUDAC QZUS02AC 3 1 1 C 420 7
QZUDAC QZUS02AC 4 1 1 C 420 7
QZUDAC QZUS03AC 1 1 1 C 420 7
QZUDAC QZUS04AC 0 1 1 C 420 7
QZUDAC QZUS05AC 0 1 1 C 420 7
QZUDAC QZUS06AC 0 1 1 C 420 7
QZUDAC QZUS07AC 0 1 1 C 420 7
QZUDAC QZUS08AC 0 1 1 C 420 7
TABLE SPACE AND INDEX EXTENTS REPORT PAGE 2
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
A
DBNAME CREATOR IXNAME PART PQTY SQTY U SPACE EXT
-------- -------- ------------------------------ ---- ------- ------- - --------- ---------
QZUDAC QZU QZUX05_DACS08T01 0 1 1 C 1365 28
QZUDAC QZU QZUX05_DACS03T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS04T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS05T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS06T01 0 1 1 C 2040 16
QZUDAC QZU QZUX05_DACS07T01 0 1 1 C 2040 16
QZUDAC QZU QZUX03_DACS08T01 0 1 1 C 615 14
QZUDAC QZU QZUX05_DACS01T01 4 1 1 C 990 11
QZUDAC QZU QZUX05_DACS02T01 4 1 1 C 990 11
QZUDAC QZU QZUX03_DACS03T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS04T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS05T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS06T01 0 1 1 C 825 10
QZUDAC QZU QZUX03_DACS07T01 0 1 1 C 825 10
QZUDAC QZU QZUX07_DACS01T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS02T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS03T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS04T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS05T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS06T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS07T01 0 1 1 C 675 9
QZUDAC QZU QZUX07_DACS08T01 0 1 1 C 420 9
QZUDAC QZU QZUX06_DACS08T01 0 1 1 C 225 8
QZUDAC QZU QZUX03_DACS01T01 4 1 1 C 420 7
QZUDAC QZU QZUX03_DACS02T01 4 1 1 C 420 7
QZUDAC QZU QZUX05_DACS01T01 1 1 1 C 315 6
QZUDAC QZU QZUX05_DACS01T01 2 1 1 C 315 6
QZUDAC QZU QZUX05_DACS01T01 3 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 1 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 2 1 1 C 315 6
QZUDAC QZU QZUX05_DACS02T01 3 1 1 C 315 6
QZUDAC QZU QZUX06_DACS03T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS04T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS05T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS06T01 0 1 1 C 315 6
QZUDAC QZU QZUX06_DACS07T01 0 1 1 C 315 6
QZUDAC QZU QZUX03_DACS01T01 1 1 1 C 150 4
QZUDAC QZU QZUX03_DACS01T01 2 1 1 C 150 4
QZUDAC QZU QZUX03_DACS01T01 3 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 1 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 2 1 1 C 150 4
QZUDAC QZU QZUX03_DACS02T01 3 1 1 C 150 4
QZUDAC QZU QZUX06_DACS01T01 4 1 1 C 150 4
QZUDAC QZU QZUX06_DACS02T01 4 1 1 C 150 4
QZUDAC QZU QZUX01_DACS03T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS04T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS05T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS06T01 0 1 1 C 45 2
QZUDAC QZU QZUX01_DACS07T01 0 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 1 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 2 1 1 C 45 2
QZUDAC QZU QZUX06_DACS01T01 3 1 1 C 45 2
TABLE SPACE AND INDEX EXTENTS REPORT PAGE 3
DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBEXT
Time . . . . . . . . : 01:45:45 dd mmm yyyy
DB2 ID . . . . . . . : DEMO
DB2 Version . . . . . : vvrr
Current Function Level: VvvRrMmmm Catalog Level . . . . .: VvvRrMmmm
Highest Active Level : VvvRrMmmm Previous Function Level: VvvRrMmmm
SPE Level . . . . . .:
User . . . . . . . . : MVSTYG
Input Parameters
DEMO ASUvrDDR QZUDAC 0
ssid plan dbname extents
The Table space and index extents report contains the following fields:
Value | Description |
|---|---|
DBName/TSName | fully qualified name of the table space |
Part | partition number |
Pqty | primary allocation quantity |
Sqty | secondary allocation quantity |
AU | allocation unit (T – tracks or C – cylinders) |
Space | allocated space in tracks or cylinders |
Ext | number of extents for the object |
DBName/Creator/IXName | fully qualified index name |
The Table space and index extents report requires the following lines of input parameters:
ssid plan dbname extents
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*