DB2 Version 9.7 for Linux, UNIX, and Windows

LIST TABLESPACE CONTAINERS command

Lists containers for the specified table space.

Important: This command or API has been deprecated and might be removed in a future release. You can use the MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions instead which return more information. For more information, see LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands have been deprecated.

The table space snapshot contains all of the information displayed by the LIST TABLESPACE CONTAINERS command.

Scope

This command returns information only for the node on which it is executed.

Authorization

One of the following:

sysadm
sysctrl
sysmaint
sysmon
dbadm

Required connection

Database

Command syntax


>>-LIST TABLESPACE CONTAINERS FOR--tablespace-id--+-------------+-><
                                                  '-SHOW DETAIL-'

Command parameters

FOR tablespace-id

An integer that uniquely represents a table space used by the current database. To get a list of all the table spaces used by the current database, use the LIST TABLESPACES command.

SHOW DETAIL

If this option is not specified, only the following basic information about each container is provided:

Container ID
Name
Type (file, disk, or path).

If this option is specified, the following additional information about each container is provided:

Total number of pages
Number of usable pages
Accessible (yes or no).

Examples

The following is sample output from LIST TABLESPACE CONTAINERS FOR 0:

            Tablespace Containers for Tablespace 0

 Container ID               = 0
 Name                       = /home/smith/smith/NODE0000/SQL00001/SQLT0000.0
 Type                       = Path

The following is sample output from LIST TABLESPACE CONTAINERS FOR 0 SHOW DETAIL specified:

            Tablespace Containers for Tablespace 0

 Container ID               = 0
 Name                       = /home/smith/smith/NODE0000/SQL00001/SQLT0000.0
 Type                       = Path
 Total pages                = 895
 Useable pages              = 895
 Accessible                 = Yes