現行データベースの表スペースのリストを表示します。
効力範囲
このコマンドは、それが実行されたノードに対してだけ情報を戻します。
許可
以下のどれかが必要です。
必須接続
データベース
コマンド構文
>>-LIST TABLESPACES--+-------------+--------------------------->< '-SHOW DETAIL-'
コマンド・パラメーター
0x0 Normal 0x1 Quiesced: SHARE 0x2 Quiesced: UPDATE 0x4 Quiesced: EXCLUSIVE 0x8 Load pending 0x10 Delete pending 0x20 Backup pending 0x40 Roll forward in progress 0x80 Roll forward pending 0x100 Restore pending 0x100 Recovery pending (not used) 0x200 Disable pending 0x400 Reorg in progress 0x800 Backup in progress 0x1000 Storage must be defined 0x2000 Restore in progress 0x4000 Offline and not accessible 0x8000 Drop pending 0x2000000 Storage may be defined 0x4000000 StorDef is in 'final' state 0x8000000 StorDef was changed prior to rollforward 0x10000000 DMS rebalancer is active 0x20000000 TBS deletion in progress 0x40000000 TBS creation in progress 0x8 For service use only
このオプションを指定した場合は、 各表スペースに関して下記の付加的な情報が表示されます。
例
下記に示すのは、LIST TABLESPACES SHOW DETAIL の 2 つの出力例です。
Tablespaces for Current Database Tablespace ID = 0 Name = SYSCATSPACE Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 895 Useable pages = 895 Used pages = 895 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 Tablespace ID = 1 Name = TEMPSPACE1 Type = System managed space Contents = Temporary data State = 0x0000 Detailed explanation: Normal Total pages = 1 Useable pages = 1 Used pages = 1 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 Tablespace ID = 2 Name = USERSPACE1 Type = System managed space Contents = Any data State = 0x000c Detailed explanation: Quiesced: EXCLUSIVE Load pending Total pages = 337 Useable pages = 337 Used pages = 337 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 State change tablespace ID = 2 State change object ID = 3 Number of quiescers = 1 Quiescer 1: Tablespace ID = 2 Object ID = 3 DB21011I In a partitioned database server environment, only the table spaces on the current node are listed.
Tablespaces for Current Database Tablespace ID = 0 Name = SYSCATSPACE Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 1200 Useable pages = 1200 Used pages = 1200 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 Tablespace ID = 1 Name = TEMPSPACE1 Type = System managed space Contents = Temporary data State = 0x0000 Detailed explanation: Normal Total pages = 1 Useable pages = 1 Used pages = 1 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 Tablespace ID = 2 Name = USERSPACE1 Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 1 Useable pages = 1 Used pages = 1 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 4096 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 Tablespace ID = 3 Name = DMS8K Type = Database managed space Contents = Any data State = 0x0000 Detailed explanation: Normal Total pages = 2000 Useable pages = 1952 Used pages = 96 Free pages = 1856 High water mark (pages) = 96 Page size (bytes) = 8192 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 2 Tablespace ID = 4 Name = TEMP8K Type = System managed space Contents = Temporary data State = 0x0000 Detailed explanation: Normal Total pages = 1 Useable pages = 1 Used pages = 1 Free pages = Not applicable High water mark (pages) = Not applicable Page size (bytes) = 8192 Extent size (pages) = 32 Prefetch size (pages) = 32 Number of containers = 1 DB21011I In a partitioned database server environment, only the table spaces on the current node are listed.
使用上の注意
マルチノード環境では、 このコマンドがデータベースのすべての表スペースを戻すわけではありません。 すべての表スペースのリストを表示するには、 SYSCAT.SYSTABLESPACES を照会します。
表スペースのバランス調整操作中には、 使用可能ページ数には新しく追加されたコンテナーのページ数が含まれますが、 バランス調整完了までの間、それらの新しいページは、未使用ページ数に反映されません。 表スペースのバランス調整が実行されていない 場合、 使用されたページの数と未使用ページの数を合計すると、使用可能ページ数の値に等しくなります。
表スペースの詳細については、管理の手引き を参照してください。
以下も参照