13.6.2 List of items that are output in the summary information of archived chunks

The following table lists the titles and output content of items (columns) that are output in the summary information of archived chunks. Each column's information is output in the order of the item numbers in the following table. For the rules for outputting archived chunks' summary information, see 13.12 Output rules for the adbdbstatus command.

Table 13‒19: Columns output as summary information for archived chunks
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of output information `Archive_chunk`: Summary information of archived chunk	N
2	`Timestamp`	Time stamp of `adbdbstatus` command execution The date and time the `adbdbstatus` command was executed is output in the following format: `"YYYY-MM-DD`∆`hh:mm:ss"`^#	Y
3	`Schema_name`	Table schema name	Y
4	`Table_identifier`	Table identifier	Y
5	`Table_ID`	Table ID	N
6	`Chunk_ID`	Chunk ID	N
7	`Chunk_status`	Chunk status `Normal`: Normal status `Wait`: Wait status `Pending_delete`: Deletion-pending status	N
8	`Archive_status`	Chunk archived state `Archived`: Archived state If a chunk is not in archived state, nothing is output.	N
9	`Range_min`	Minimum value of the archive range column Information is output as the data type in the archive range column. However, if any of the following apply, nothing is output: No data is stored in the chunk. The chunk is pending deletion. The range index defined in the archive range column is in unfinished status, and the chunk has not been archived.	Y
10	`Range_min_raw`	Minimum value (hexadecimal) of the archive range column Information is output as hexadecimal-format binary data only when the data type in the archive range column is `CHARACTER`. However, if any of the following apply, nothing is output: No data is stored in the chunk. The chunk is pending deletion. The range index defined in the archive range column is in unfinished status, and the chunk has not been archived.	Y
11	`Range_max`	Maximum value of the archive range column Information is output as the data type in the archive range column. However, if any of the following apply, nothing is output: No data is stored in the chunk. The chunk is pending deletion. The range index defined in the archive range column is in unfinished status, and the chunk has not been archived.	Y
12	`Range_max_raw`	Maximum value (hexadecimal) of the archive range column Information is output as hexadecimal-format binary data only when the data type in the archive range column is `CHARACTER`. However, if any of the following apply, nothing is output: No data is stored in the chunk. The chunk is pending deletion. The range index defined in the archive range column is in unfinished status, and the chunk has not been archived.	Y
13	`Rows`	Number of rows stored in the archived chunk This is only output if the chunk is in archived state.	--
14	`Archive_file_num`	Total number of archive files corresponding to the archived chunk If a chunk is not in archived state, `0` is output.	--
15	`Archive_file_size`	Total size (units: bytes) of all archive files corresponding to the archived chunk If a chunk is not in archived state, `0` is output.	--
16	`Unarchive_table_size`	Size (units: bytes) of segment used to store the table of chunks that have not yet been archived If a chunk is not in archived state, `0` is output.	--
17	`Unarchive_index_size`	Size of segment (units: bytes) used to store the indexes of chunks that have not yet been archived If any indexes are defined in the target table, the size of the segment used to store the indexes of chunks that have not yet been archived is output. If a chunk is not in archived state, `0` is output.	--
18	`Compression_ratio`	Compression rate (units: percent) of archived chunks This is only output if the chunk is in archived state. However, even if a chunk is in archived state, if there are 0 rows stored in the chunk, nothing is output.	--
19	`Chunk_comment`	Comment specified in a chunk This is output only when a chunk comment is specified in a chunk.	Y
20	`Rsv`	--	--

Legend:

--: No value is output.

Y: The output value is enclosed in enclosing characters.

N: The output value is not enclosed in enclosing characters.

#

The year (YYYY) is output in 4 digits. The month (MM), date (DD), hours (hh), minutes (mm), and seconds (ss) are each output in 2 digits. If there are not enough digits in a value, the left side of the value is padded with zeros (0). ∆ represents a halfwidth space.

To Page Top