Database storage utilization report
The Database Storage Utilization Report lists the following items:
- Tracks allocated
- Tracks used
- Percentage of space used
- Number of extents
- Number of data sets
- Primary and secondary space allocation
- Allocation unit
- Number of volumes
- The name of the first volume for each table space and index of a DB2 database
- Totals by indexes
The report also displays, table spaces, table spaces and indexes, database—and by report if you specify multiple databases.
The following figure shows a Database Storage Utilization Report
Database Storage Utilization Report
DATABASE STORAGE UTILIZATION REPORT PAGE 1
DASD MANAGER PLUS FOR DB2 12.01.00 - ASUDBSPA
Time . . . . . . . . : 23:51:38 24 Aug 2021
DB2 ID . . . . . . . : DEJM
DB2 Version . . . . . : 1215
Current Function Level: V12R1M509 Catalog Level . . . . .: V12R1M509
Highest Active Level : V12R1M509 Previous Function Level: V12R1M508
SPE Level . . . . . .: SPE2110
User . . . . . . . . : MVSAYB
TS/IX TRKS TRKS % A
DATABASE OBJECT PART TYPE SPACE USED USED IX DSNS PQTY SQTY U VOLS VOLSER
------------------------------------------- ---- ------ ------------- ------------- ---- ---- ---- ------ ------ - ---- ------
QZUD10.QZUS0110 0 b-A 31 11 35 3 1 1 15 T 1 AZU007
QZU.QZUX01_D10S01T01 0 2-A 90 2 2 2 1 6 1 C 1 AZU007
QZU.QZUX02_D10S01T01 0 2-A 90 4 4 3 1 6 1 C 1 AZU007
QZU.QZUX03_D10S01T01 0 2-A 90 9 10 3 1 6 1 C 1 AZU007
QZU.QZUX04_D10S01T01 0 2-A 90 9 10 3 1 6 1 C 1 AZU007
QZU.QZUX05_D10S01T01 0 2-A 90 9 10 1 1 6 1 C 1 ASU022
============= =============
TOTAL - INDEXES 450 33
============= =============
TOTAL - TABLE SPACE 31 11
============= =============
TOTAL - TABLE SPACE AND INDEXES 481 44
QZUD10.QZUS0210 0 b-A 3 3 100 1 1 3 15 T 1 AZU007
QZU.QZUX01_D10S02T01 0 2-A 3 3 100 1 1 3 15 T 1 AZU007
============= =============
TOTAL - INDEXES 3 3
============= =============
TOTAL - TABLE SPACE 3 3
============= =============
TOTAL - TABLE SPACE AND INDEXES 6 6
============= =============
TOTAL - DATABASE 487 50
QZUD11.QZUS0111 1 b-A 30 1 3 1 1 2 1 C 1 ASU022
2 b-A 30 1 3 1 1 2 1 C 1 ASU011
3 b-A 30 3 10 2 1 2 1 C 1 AZU007
4 b-A 30 9 30 1 1 2 1 C 1 ASU011
============= =============
TOTAL - TABLEPARTS 120 14
QZU.QZUX01_D11S01T01 0 2-A 30 2 6 2 1 2 1 C 1 AZU007
QZU.QZUX02_D11S01T01 0 2-A 30 4 13 2 1 2 1 C 1 AZU007
QZU.QZUX03_D11S01T01 1 2-A 30 1 3 2 1 2 1 C 1 AZU007
2 2-A 30 1 3 1 1 2 1 C 1 ASU011
3 2-A 30 2 6 1 1 2 1 C 1 ASU022
4 2-A 30 6 20 1 1 2 1 C 1 ASU011
============= =============
TOTAL - INDEX PARTS 120 10
============= =============
TOTAL - INDEXES 180 16
============= =============
TOTAL - TABLE SPACE 120 14
============= =============
TOTAL - TABLE SPACE AND INDEXES 300 30
QZUD11.QZUS0211 1 b-A 30 1 3 1 1 2 1 C 1 ASU022
2 b-A 30 1 3 1 1 2 1 C 1 ASU022
DATABASE STORAGE UTILIZATION REPORT PAGE 505
DASD MANAGER PLUS FOR DB2 12.01.00 - ASUDBSPA
Time . . . . . . . . : 23:51:38 24 Aug 2021
DB2 ID . . . . . . . : DEJM
DB2 Version . . . . . : 1215
Current Function Level: V12R1M509 Catalog Level . . . . .: V12R1M509
Highest Active Level : V12R1M509 Previous Function Level: V12R1M508
SPE Level . . . . . . : SPE2110
User . . . . . . . . : MVSAYB
Input Parameters
DEJM ASUC2DDR QZUD% 0
ssid plan dbname vcatname
The Database storage utilization report contains the following fields:
Field | Description |
|---|---|
Database Object | Name of the table space or index for which the product generates the report |
Part | Number of the partition in the table space or index |
TS/IX Type | For table spaces – The type of table space and the format of pages (from SYSIBM.SYSTABLESPACE.PAGENUM). For indexes – The index type and the format of page numbers (from SYSIBM.SYSINDEXES.PAGENUM). |
Trks Space | Number of tracks that are allocated for the object |
Trks Used | Tracks that the object uses |
% Used | Percentage of the allocated space that the object uses |
Ext | Number of extents that the object is in |
DSNS | Number of data sets in the object |
Pqty | Primary allocation quantity |
Sqty | Secondary allocation quantity |
AU | Allocation unit (T—tracks or C—cylinders) |
Vols | Number of volumes for the object |
Volser | Volume serial number of the first volume for the object |
Total – Tableparts | Total number of tracks allocated and used for the tables pace partitions |
Total – Indexparts | Total number of tracks allocated and used for the index space partitions |
Total – Indexes | Total number of tracks allocated and used for the indexes |
Total – Table Space | Total number of tracks allocated and used for the table spaces |
Total – Table Space and Indexes | Total number of tracks allocated and used for the table spaces and indexes |
Total – Database | Total number of tracks allocated and used for the database |
The Database storage utilization requires the following lines of input parameters: