C.5 Content of STATUS_CHUNKS

STATUS_CHUNKS stores chunk information related to multi-chunk tables. Each row stores information for one chunk.

The following table describes the contents of STATUS_CHUNKS.

Table C‒6: Content of STATUS_CHUNKS
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier
3	`CHUNK_ID`	`INTEGER`	Chunk ID
4	`CREATE_TIME`	`TIMESTAMP`	Date and time the chunk was created If chunks have been merged, the earliest creation time associated with the merge-source chunks is stored. For a chunk that was created in wait status by the `adbimport` command and was later changed to the normal status by the `adbchgchunkstatus` command, the date and time the `adbchgchunkstatus` command was executed are stored. For a chunk that was created by using the `adbchgchunkstatus` command to swap the current chunk, the date and time the `adbchgchunkstatus` command was executed are stored. In the following case, the null value is stored: When a chunk is created in wait status by the `adbimport` command
5	`SWAP_TIME`	`TIMESTAMP`	Date and time when the current chunk was swapped If chunks have been merged, the most recent date and time information associated with the merge-source chunks when the current chunk was swapped is stored. For a chunk that was created in wait status by the `adbimport` command and was later changed to the normal status by the `adbchgchunkstatus` command, and which was not swapped to become the current chunk when its status was changed to the normal status, the date and time the `adbchgchunkstatus` command was executed are stored. A null value is stored in the following cases: A new chunk has not been created (the current chunk has not been swapped). When chunks were merged, the current chunk was included in the merge-source chunks. When a chunk is created in wait status by the `adbimport` command
6	`CHUNK_COMMENT`	`VARCHAR(1024)`	Comment that is set to the chunk The null value is stored if no comment is set.
7	`CHUNK_STATUS`	`VARCHAR(32)`	Chunk status `'Normal'` Normal status `'Pending Delete'` Delete-pending status `'Wait'` Wait status
8	`ARCHIVE_STATUS`	`VARCHAR(32)`	Is archived chunk? `'Archive'` Is archived chunk Null value Is not archived chunk
9	`STORAGE_FORMAT`	`VARCHAR(32)`	Chunk-data storage format `'COLUMN'` Column store format `'ROW'` Row store format

To Page Top