Command Reference

LIST TABLESPACE CONTAINERS

Lists containers for the specified table space.

Scope

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

Authorization

One of the following:

• sysadm
• sysctrl
• sysmaint
• 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 LIST TABLESPACES.

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 useable pages
• Accessible (yes or no).

Examples

The following is sample output from LIST TABLESPACE CONTAINERS:

            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 with 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

See Also

LIST TABLESPACES.