13.8.2 List of items that are output in the usage information of archived chunks

The following table lists the titles and output content of items (columns) that are output in the usage 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 usage information of archived chunks, see 13.12 Output rules for the adbdbstatus command.

Table 13‒22: Columns output as usage information for archived chunks
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of output information `Used_chunk:` Usage 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	`DBarea_name`	DB area name	Y
4	`DBarea_ID`	DB area ID	N
5	`Rsv`	--	--
6	`Object_type`	Schema object type `table`: Table	N
7	`Schema_name`	Table schema name	Y
8	`Object_identifier`	Table identifier	Y
9	`Object_ID`	Table ID	N
10	`Chunk_ID`	Chunk ID	N
11	`Chunk_status`	Chunk status `Normal`: Normal status `Wait`: Wait status `Pending_delete`: Deletion-pending status	N
12	`Range_min`	Minimum value of the archive range column Information is output as the data type in the archive range column. Information is only output if there is an archive file that corresponds to a chunk (the data is stored in the chunk) whose ID is output in the `Chunk_ID` column. If the archive file name is output in the `Archive_file_name` column The minimum value of the corresponding archive file's archive range column is output. If nothing is output in the `Archive_file_name` column The minimum value of the archive range columns in all archive files that correspond to chunks whose ID is output in the `Chunk_ID` column is output.	Y
13	`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`. Information is only output if there is an archive file that corresponds to a chunk (the data is stored in the chunk) whose ID is output in the `Chunk_ID` column.	Y
14	`Range_max`	Maximum value of the archive range column Information is output as the data type in the archive range column. Information is only output if there is an archive file that corresponds to a chunk (the data is stored in the chunk) whose ID is output in the `Chunk_ID` column. If the archive file name is output in the `Archive_file_name` column The maximum value of the corresponding archive file's archive range column is output. If nothing is output in the `Archive_file_name` column The maximum value of the archive range columns in all archive files that correspond to chunks whose ID is output in the `Chunk_ID` column is output.	Y
15	`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`. Information is only output if there is an archive file that corresponds to a chunk (the data is stored in the chunk) whose ID is output in the `Chunk_ID` column.	Y
16	`Archive_file_name`	Archive file name The file path of the archive file corresponding to the chunk is output. If nothing is output to this column, the total size of all archive files corresponding to chunks whose ID is output in the `Chunk_ID` column, is output to the `Archive_file_size` column.	Y
17	`Archive_file_size`	Archive file size (units: bytes) If the archive file name is output in the `Archive_file_name` column The size of the corresponding archive file is output. If nothing is output in the `Archive_file_name` column The total size of all archive files corresponding to chunks whose ID is output in the `Chunk_ID` column is output.	N
18	`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