DB2 Group Summary
Syntax:

DB2 group summary <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.

Example:


Size Information for GRP25 (TSID 9)
CTNameTotal
IND0078557F8525722E196608.00
IND0026AD0D85257219327680.00
IND002DEF1F85257235196608.00
*IND005901758525722D318439424.00
IND007857608525722E196608.00
IND002DA2ED85257235196608.00
IND002693D185257235294125568.00
IND00737C8485257234196608.00
IND0072ACE985257234163840.00
ND0052AF9E85257212327680.00
ND0071FEAB85257234163840.00
NIFCTL425984.00
NIFDATA196608.00
*INIFSUMMARY1045069824.00
*IND00699B538525720A1638400.00
*IND004C2FB1852571C5905445376.00
NPROPERTIES1933312.00
NDB2MAP425984.00
*NNSFNOTE1596325888.00
*NNSFOBJECT270172160.00
NNSFOBJNAM655360.00
*NNSFDATA6750208.00
UANOTHER_COPY_OF_TE262144.00
US_X65536.00
US_T163840.00
UTEST_X65536.00
UTEST_T163840.00
UD_X163840.00
UD_T163840.00
UANOTHER_COPY_OF_TE163840.00
Total 4,444,782,592

This command lists the number of bytes of storage allocated to the tables in the group and some other basic information.

Size Information for GRP25 (TSID 9) the DB2 Tablespace ID for this group

C - compressed. An asterisk (*) 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

Total - allocated bytes of storage

summary:

Container: C:\DB2\NODE0000\SQL00001\25.DB2GRP

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

The actual physical container file used by DB2.

The physical size of the container and the summary of the space in use by the tables in the group. The percent indicates the relative "fragmentation" of the physical file. If this number is low, disk space may be recovered by running Compact <NOTE.. need to doc specifics>

Related topics