Table space and index storage limits report

The Table Space and Index Storage Limits Report indicates the percentage of the physical object limit that Db2 table spaces and indexes have used that is equal to or greater than the limit specified.

The report prints a line for objects whose %GB is greater than or equal to the pctlimit. The report sorts the objects by the largest percentage of possible space used.

Table Space and Index Storage Limits Report

               TABLE SPACE AND INDEX STORAGE LIMITS REPORT             PAGE    1

DASD MANAGER PLUS FOR DB2 <vv.rr.mm> - ASUDBLIM
   Time . . . . . . . . : 09:21:31    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 . . . . . .: SPEyymm
   User . . . . . . . . : RDAMAV4
                                    (KB)      MAX                    ESTIMATED
DBNAME   TSNAME     PART TYPE   USED SPACE    GB   % GB       ROWS   NEW ROWS DATE STATS
-------- --------   ---- ---- ------------ ----- ------ ---------- ---------- ----------
QZUDVL   QZUS01VL      0 b-A      60193324    64 89.70    2.2E+09 252755405 mm.dd.yyyy
QZUDVL   QZUS02VL <=   1 G-A      60193324    64 89.70 2200000000 252755405 mm.dd.yyyy
QZUDVL   QZUS03VL      0 b-A      60193308    64 89.70    2.2E+09 252756057 mm.dd.yyyy

               TABLE SPACE AND INDEX STORAGE LIMITS REPORT             PAGE    2

DASD MANAGER PLUS FOR DB2 <vv.rr.mm> - ASUDBLIM
   Time . . . . . . . . : 09:21:31    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 . . . . . .: SPEyymm
   User . . . . . . . . : RDAMAV4

                                                         IX      (KB)        MAX
DBNAME   CREATOR IXNAME                           PART TYPE USED SPACE      GB   % GB DATE STATS
-------- -------- ------------------------------   ---- ---- ---------- ------- ------ ----------
QZUDVL   QZU      QZUX01_DVLS03T01                    0 2-A    36823376   64.00 54.87 mm.dd.yyyy
QZUDVL   QZU      QZUX01_DVLS01T01                    0 2-A    36211768   64.00 53.96 mm.dd.yyyy
QZUDVL   QZU      QZUX01_DVLS02T01                    0 2-A    39278264 8192.00   0.46 mm.dd.yyyy

               TABLE SPACE AND INDEX STORAGE LIMITS REPORT            PAGE    3

DASD MANAGER PLUS FOR DB2 vv.rr.mm - ASUDBLIM
   Time . . . . . . . . : 09:21:31    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 . . . . . .: SPEyymm
   User . . . . . . . . : RDAMAV4

Input Parameters

DEMO ASUvrQDR QZUDVL% 0
ssid plan     dbname pctlimit

The Table space and index storage limits report contains the following fields:

Field	Description
DBName/TSName	Fully qualified table space name
DBName/Creator/IXname	Fully qualified index name
Part	Partition number
Type	Type of table space and the format of pages (from SYSIBM.SYSTABLESPACE.PAGENUM). Important A table space type of blank is shown as a lower case b.
IX Type	The Index type and the format of page numbers (from SYSIBM.SYSINDEXES.PAGENUM). Important An index type of blank is shown as a lower case b.
Used Space (KB)	Space that the Db2 object currently uses, in kilobytes
Max GB	Maximum amount of space to be allocated for the object in gigabytes
% GB	Percentage of the maximum space that the object currently uses
Rows	Number of rows in the object
Estimated New Rows	Estimated number of rows still available for the object.
Date Stats	Date that you last ran BMCSTATS on the object

The Table space and index storage limits report requires the following line of input parameters:

ssid plan dbname pctlimit

Table space and index storage limits report

On this page