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)

CT	Name	Data	Index	LOB	Total
I	ND0078557F8525722E	65536.00	131072.00	0.00	196608.00
I	ND0026AD0D85257219	65536.00	131072.00	131072.00	327680.00
I	ND002DEF1F85257235	65536.00	131072.00	0.00	196608.00
*I	ND005901758525722D	117374976.00	201064448.00	0.00	318439424.00
I	ND007857608525722E	65536.00	131072.00	0.00	196608.00
I	ND002DA2ED85257235	65536.00	131072.00	0.00	196608.00
I	ND002693D185257235	108560384.00	185565184.00	0.00	294125568.00
I	ND00737C8485257234	65536.00	131072.00	0.00	196608.00
I	ND0072ACE985257234	65536.00	98304.00	0.00	163840.00
I	ND0052AF9E85257212	65536.00	131072.00	131072.00	327680.00
I	ND0071FEAB85257234	65536.00	98304.00	0.00	163840.00
I	NIFCTL	196608.00	98304.00	131072.00	425984.00
I	NIFDATA	65536.00	0.00	131072.00	196608.00
*I	NIFSUMMARY	807993344.00	237076480.00	0.00	1045069824.00
*I	ND00699B538525720A	491520.00	1015808.00	131072.00	1638400.00
*I	ND004C2FB1852571C5	440991744.00	464322560.00	131072.00	905445376.00
N	PROPERTIES	688128.00	98304.00	1146880.00	1933312.00
N	DB2MAP	65536.00	0.00	360448.00	425984.00
*N	NSFNOTE	1099988992.00	486277120.00	10059776.00	1596325888.00
*N	NSFOBJECT	1245184.00	98304.00	268828672.00	270172160.00
N	NSFOBJNAM	262144.00	393216.00	0.00	655360.00
*N	NSFDATA	6520832.00	229376.00	0.00	6750208.00
U	ANOTHER_COPY_OF_TE	163840.00	98304.00	0.00	262144.00
U	S_X	65536.00	0.00	0.00	65536.00
U	S_T	163840.00	0.00	0.00	163840.00
U	TEST_X	65536.00	0.00	0.00	65536.00
U	TEST_T	163840.00	0.00	0.00	163840.00
U	D_X	163840.00	0.00	0.00	163840.00
U	D_T	163840.00	0.00	0.00	163840.00
U	ANOTHER_COPY_OF_TE	163840.00	0.00	0.00	163840.00
	NSF	1108770816.00	487096320.00	280395776.00	1876262912.00
	NIF	1476263936.00	1090256896.00	786432.00	2567307264.00
	USER	1114112.00	98304.00	0.00	1212416.00
	TOTAL	2586148864.00	1577451520.00	281182208.00	4444782592.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

DB2 Group Summary
DB2 Group
Domino and DB2 server commands

Glossary