DB2 Group Size
Syntax:

DB2 Group Size <Group Name> [Table Name]

Description:

Lists the physical storage allocated to the tables in the group. If a specific table name is provided, only size information for that table is returned. This command provides more detailed information than the Summary command provides.

Example:

db2 group size GRP25

Size Information for GRP25 (TSID 9)
CTNameDataIndexLOBTotal
IND0078557F8525722E65536.00131072.000.00196608.00
IND0026AD0D85257219 65536.00131072.00131072.00327680.00
IND002DEF1F8525723565536.00131072.000.00196608.00
*IND005901758525722D117374976.00201064448.000.00318439424.00
IND007857608525722E65536.00131072.000.00196608.00
I ND002DA2ED8525723565536.00131072.000.00196608.00
IND002693D185257235108560384.00185565184.000.00294125568.00
IND00737C848525723465536.00131072.000.00196608.00
IND0072ACE98525723465536.0098304.000.00163840.00
IND0052AF9E8525721265536.00131072.00131072.00327680.00
IND0071FEAB8525723465536.0098304.000.00163840.00
INIFCTL196608.0098304.00131072.00425984.00
INIFDATA65536.000.00131072.00196608.00
*INIFSUMMARY807993344.00237076480.000.001045069824.00
*IND00699B538525720A491520.001015808.00131072.001638400.00
*IND004C2FB1852571C5440991744.00464322560.00131072.00905445376.00
NPROPERTIES688128.0098304.001146880.001933312.00
NDB2MAP65536.000.00360448.00425984.00
*NNSFNOTE1099988992.00486277120.0010059776.001596325888.00
*NNSFOBJECT1245184.0098304.00268828672.00270172160.00
NNSFOBJNAM262144.00393216.000.00655360.00
*NNSFDATA6520832.00229376.000.006750208.00
UANOTHER_COPY_OF_TE163840.0098304.000.00262144.00
US_X65536.000.000.0065536.00
US_T163840.000.000.00163840.00
UTEST_X 65536.000.000.0065536.00
UTEST_T163840.000.000.00163840.00
UD_X163840.000.000.00163840.00
UD_T163840.000.000.00163840.00
UANOTHER_COPY_OF_TE163840.000.000.00163840.00
NSF1108770816.00487096320.00280395776.001876262912.00
NIF1476263936.001090256896.00786432.002567307264.00
USER1114112.0098304.000.001212416.00
TOTAL2586148864.001577451520.00281182208.004444782592.00
Container: C:\DB2\NODE0000\SQL00001\25.DB2GRP

Total disk space 4,447,535,104 bytes, actual used 4,444,946,432 bytes (99.9%)

Size Information for GRP25 (TSID 9)

CT Name Data Index LOB Total

C= compressed. A * indicates that the table is compressed using IBM® DB2® UDB™ 9.x's compression

T= same Type classifications as above, but abbreviated N=NSF, I=NIF (index), U=User (DAV)

and ?=Unknown

Name - the name of the DB2 table

Data - number of bytes stored in Data pages in DB2

Index - number of bytes stored in Index pages in DB2

LOB - number of bytes stored in LOB pages in DB2

Total - allocated bytes of storage

This command then summarizes the usage by category (NIF, NSF, User) and presents the same summary information as the DB2 GROUP SUMMARY command

Related topics