The syschunks table describes each of the chunks that the database server manages. In the flags and mflags columns, each bit position represents a separate flag. Thus, it might be easier to read values in the flags and mflags columns if the values are returned using the HEX function.
| Column | Type | Description | ||
|---|---|---|---|---|
| coserver_id | integer | Coserver number | ||
| chknum | integer | Chunk number | ||
| dbsnum | integer | Dbspace number | ||
| nxchknum | integer | Number of the next chunk in this dbspace | ||
| chksize | integer | Number of pages in this chunk | ||
| offset | integer | Page offset of the chunk in its device or path | ||
| nfree | integer | Number of free pages in the chunk | ||
| is_offline | integer | 1 if the chunk is offline, 0 if not | ||
| is_recovering | integer | 1 if the chunk is being recovered, 0 if not | ||
| is_blobchunk | integer | (always 0) | ||
| is_inconsistent | integer | 1 if the chunk is undergoing logical restore, 0 if not | ||
| flags | smallint | Flags | Hexadecimal | Meaning |
| 16 | 0x0010 | Chunk is a mirrored chunk. | ||
| 32 | 0x0020 | Chunk is in offline mode. | ||
| 64 | 0x0040 | Chunk is in online mode. | ||
| 128 | 0x0080 | Chunk is in recovery mode. | ||
| 256 | 0x0100 | Chunk has just been mirrored. | ||
| 1024 | 0x0400 | Chunk is being dropped. | ||
| 4096 | 0x1000 | Chunk is inconsistent. | ||
| 16384 | 0x4000 | Chunk contains temporary log space. | ||
| 32768 | 0x8000 | Chunk was added during roll forward. | ||
| fname | char(464) | Pathname for the file or device of this chunk | ||
| mfname | char(464) | Pathname for the file or device of the mirrored chunk, if any | ||
| moffset | integer | Page offset of the mirrored chunk | ||
| mis_offline | integer | 1 if mirror is offline, 0 if not | ||
| mis_recovering | integer | 1 if mirror is being recovered, 0 if not | ||
| mflags | integer | Mirrored chunk flags; values and meanings are the same as the flags column. | ||