13.4.2 List of items that are output as summary information for tables

1

Type

Type of information that is output:

Table: Summary information for a table

Table(Shared_lock): Summary information for a table (if the --shared-lock option is specified)

N

2

Timestamp

Timestamp when the adbdbstatus command was executed

The date and time the adbdbstatus was executed are output in the following format:

"YYYY-MM-DDΔhh:mm:ss"^#1

Y

3

DBarea_name

Name of the DB area where the table is stored

Y

4

DBarea_ID

DB area ID of the DB area where the table is stored

N

5

Schema_name

Schema name of the table

The schema name for a dictionary table (base table) or a system table (base table) is always HADB.

Y

6

Table_identifier

Table identifier

Y

7

Table_ID

Table ID

N

8

Table_type

Table type:

• user: User-defined table

• dictionary: Dictionary table (base table)

• system: System table (base table)

N

9

Rsv

--

--

10

Page_size

Page size (bytes)

N

11

Segment_size

Segment size (pages)

N

12

Creatable_chunks

Number of chunks that can be created for the table^#4

The number of times background import can be performed is output.

For a single-chunk table, 0 is output.

N

13

Created_chunks

Number of chunks created for the table^#4

The value that is output as the number of chunks created for the table also includes the following chunks:

• Delete-pending chunks

• System chunks used temporarily by the adbmergechunk command

This includes the number of chunks in wait status.

For a single-chunk table, 1 is output.

For a system table (base table), 1 or 2 is output.

N

14

Current_chunk_ID

Chunk ID of the current chunk for the table^#4

For a single-chunk table, 1 is output.

For a system table (base table), "1 plus the number of times the adbreorgsystemdata command is executed" is output.

N

15

Pending_delete_chunks

Number of delete-pending chunks for the table^#4

For a multi-chunk table, the number of merge-source chunks whose deletion has not been completed by the adbmergechunk command is output.

For a single-chunk table, 0 is output.

For a system table (base table), 0 or 1 is output (if deletion of pre-reorganization data has not been completed, 1 is output).

N

16

Non-updatable

Whether the table is non-updatable

• non-updatable: This is output if the table is non-updatable.

• no_check: This is output if the --shared-lock option is specified. Information about whether the table is non-updatable cannot be acquired.

In any other case, no value is output.

N

17

Command_status

Command termination status (whether the command needs to be re-executed)

abort is output in one of the following cases:

• If the command indicated in the Rerun_command column terminated abnormally during table or index creation

  Re-execute the command indicated in the Rerun_command column. Until that command is re-executed, other commands that create tables and indexes cannot be executed. The commands that create tables and indexes are as follows:

  - adbimport command

  - adbidxrebuild command

  - adbunarchivechunk command

• If the command indicated in the Rerun_command column terminated abnormally before deletion of pre-reorganization data was completed.

  Re-execute the command indicated in the Rerun_command column. This applies to the following command:

  - adbreorgsystemdata command

If the --shared-lock option is specified, no_check is output because information about the command termination status cannot be acquired.

In any other case, no value is output.

N

18

Rerun_command

Name of the command to be re-executed

If the value in the Command_status column is abort, the name of the command that needs be re-executed is output.

• adbimport: adbimport command

• adbidxrebuild: adbidxrebuild command

• adbunarchivechunk: adbunarchivechunk command

• adbreorgsystemdata: adbreorgsystemdata command

If no command needs to be re-executed, no value is output.

N

19

Rsv

--

--

20

Used_segments^#2

Number of segments in use by the table^{#3, #5}

The number of segments being used by the table^{#3, #5} is output.

N

21

Used_pages^{#2, #6}

Number of pages in use by the table^{#3, #5}

The number of pages being used by the table^{#3, #5} is output.

N

22

Rsv

--

--

23

Wait_chunks

Number of chunks in wait status^#4

For a single-chunk table, 0 is output.

N

24

Archive_chunks

Number of archived chunks

For a single-chunk table and regular multi-chunk table, 0 is output.

N

25

Storage_format

Table-data storage format

• row: Row store format

• column: Column store format

N