Container names in automatic storage table spaces

Although container names for automatic storage table spaces are assigned by the database manager, they are visible if you run commands such as LIST TABLESPACE CONTAINERS, or GET SNAPSHOT FOR TABLESPACES commands. This topic describes the conventions used for container names so that you can recognize them when they appear.

The names assigned to containers in automatic storage table spaces are structured as follows:

 storage path/instance name/NODE####/database name/T#######/C#######.EXT

where:

storage path

Is a storage path associated with a storage group

instance name

Is the instance under which the database was created

database name

Is the name of the database

NODE####

Is the database partition number (for example, NODE0000)

T#######

Is the table space ID (for example, T0000003)

C#######

Is the container ID (for example, C0000012)

EXT

Is an extension based on the type of data being stored:

CAT: System catalog table space
TMP: System temporary table space
UTM: User temporary table space
USR: User or regular table space
LRG: Large table space

Examples

For example, assume an automatic storage table space TBSAUTO has been created in the database SAMPLE. When the LIST TABLESPACES command is run, it is shown as having a table space ID of 10:


 Tablespace ID                        = 10
 Name                                 = TBSAUTO
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal

If you now run the LIST TABLESPACE CONTAINERS command for the table space with the ID of 10, you can see the names assigned to the containers for this table space:


LIST TABLESPACE CONTAINERS FOR 10 SHOW DETAIL

            Tablespace Containers for Tablespace 10

 Container ID                         = 0
 Name                                 = D:\DB2\NODE0000\SAMPLE\T0000010\C0000000.LRG
 Type                                 = File
 Total pages                          = 4096
 Useable pages                        = 4064
 Accessible                           = Yes

In this example, you can see the name of the container, with container ID 0, for this table space is

D:\DB2\NODE0000\SAMPLE\T0000010\C0000000.LRG