LIST TABLESPACE CONTAINERS command
The LIST TABLESPACE CONTAINERS command lists containers for the specified table space.
Important: This command or API has been deprecated in
Version 9.7 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 authorities:
- SYSADM
- SYSCTRL
- SYSMAINT
- SYSMON
- DBADM
Required connection
Database
Command syntax
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