Objects ranked by size
This report details the amount of disk space consumed by each object in a given library. This report is used to identify the largest objects so that appropriate purging and/or backup can be done.
Report Summary
Date of report: 8/24/2004
Time of report: 9:34:43 AM
Report data retrieved from system: flash
ODBC DSN used for the report: VDT_FLASH
ODBC DSN User id: ISEREMET
Library used in this report: TPCH     
LIBRARY OBJECT OBJECT SIZE (KB.) OBJECT TYPE % OF TOTAL
TPCH LINEITEM 833,592 *FILE 29.9428
TPCH LINEITEMXX 832,260 *FILE 29.8950
TPCH ORDERS 215,086 *FILE 7.7259
TPCH PARTSUPP 172,068 *FILE 6.1807
TPCH LINE3 100,384 *FILE 3.6058
TPCH LINE11 97,316 *FILE 3.4956
TPCH LINE2KLF 94,236 *FILE 3.3850
TPCH LINE4 86,556 *FILE 3.1091
TPCH LINE9 73,884 *FILE 2.6539
TPCH LINE10 64,668 *FILE 2.3229
TPCH LINE8 50,460 *FILE 1.8125
TPCH LINE6 50,208 *FILE 1.8035
TPCH CUSTOMER 34,856 *FILE 1.2520
TPCH PART 32,804 *FILE 1.1783
TPCH ORDERSKLF 25,692 *FILE 0.9229
TPCH PSUPPKLF 12,824 *FILE 0.4606
TPCH PARTKLF 3,224 *FILE 0.1158
TPCH SUPPLIER 2,088 *FILE 0.0750
TPCH DBGEN 1,188 *PGM 0.0427
TPCH DSPOBJDBSC 552 *FILE 0.0198
2,783,946