DB2 group tables <Group Name>

Description:

Lists all of the IBM® DB2 Universal Database™ Enterprise Server Edition tables associated with the storage group.

Example:

> db2 group tables GRP25

C	Type	Schema	Table Name
	NIF	GRP25	ND0078557F8525722E
	NIF	GRP25	ND0026AD0D85257219
	NIF	GRP25	ND002DEF1F85257235
*	NIF	GRP25	ND005901758525722D
	NIF	GRP25	ND007857608525722E
	NIF	GRP25	ND002DA2ED85257235
	NIF	GRP25	ND002693D185257235
	NIF	GRP25	ND00737C8485257234
	NIF	GRP25	ND0072ACE985257234
	NIF	GRP25	ND0052AF9E85257212
	NIF	GRP25	ND0071FEAB85257234
	NIF	GRP25	NIFCTL
	NIF	GRP25	NIFDATA
*	NIF	GRP25	NIFSUMMARY
*	NIF	GRP25	ND00699B538525720A
*	NIF	GRP25	ND004C2FB1852571C5
	NSF	GRP25	PROPERTIES
	NSF	GRP25	DB2MAP
*	NSF	GRP25	NSFNOTE
*	NSF	GRP25	NSFOBJECT
	NSF	GRP25	NSFOBJNAM
*	NSF	GRP25	NSFDATA
	USER	OIDTEST2	ANOTHER_COPY_OF_TEST_T
	USER	MOD2	S_X
	USER	MOD2	S_T
	USER	OIDTEST2	TEST_X
	USER	OIDTEST2	TEST_T
	USER	MARY2	D_X
	USER	MARY2	D_T
	USER	OIDTEST2	ANOTHER_COPY_OF_TEST_X

This command reports all of the tables associated with this group, the columns are...

C - compressed. An asterisk (*) indicates that the table is compressed using DB2 9.x's compression

Type - classification of the table, NIF is Notes View related, NSF is basic note and object storage, USER tables are DB2 Access View related tables, UNKNOWN is an unknown table type

Schema - the DB2 Schema of the table

Table Name - the name of the DB2 table

See also

DB2 Group
Domino and DB2 server commands

Glossary