DB2 Group Tables
Syntax:

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
CTypeSchemaTable Name
NIFGRP25ND0078557F8525722E
NIFGRP25ND0026AD0D85257219
NIF GRP25ND002DEF1F85257235
*NIFGRP25ND005901758525722D
NIFGRP25ND007857608525722E
NIFGRP25ND002DA2ED85257235
NIFGRP25ND002693D185257235
NIFGRP25ND00737C8485257234
NIFGRP25ND0072ACE985257234
NIFGRP25ND0052AF9E85257212
NIFGRP25 ND0071FEAB85257234
NIFGRP25NIFCTL
NIFGRP25NIFDATA
*NIFGRP25NIFSUMMARY
*NIFGRP25ND00699B538525720A
*NIFGRP25ND004C2FB1852571C5
NSFGRP25PROPERTIES
NSFGRP25DB2MAP
*NSFGRP25NSFNOTE
*NSFGRP25NSFOBJECT
NSFGRP25NSFOBJNAM
*NSFGRP25NSFDATA
USEROIDTEST2 ANOTHER_COPY_OF_TEST_T
USERMOD2S_X
USERMOD2S_T
USEROIDTEST2TEST_X
USEROIDTEST2 TEST_T
USERMARY2 D_X
USERMARY2D_T
USEROIDTEST2ANOTHER_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

Related topics