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 | ||
|---|---|---|---|---|
| chknum | smallint | Chunk number | ||
| dbsnum | smallint | Dbspace number | ||
| nxchknum | smallint | 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 | ||
| pagesize | integer | Page size (in units of system default page size) | ||
| nfree | integer | Number of free pages in the chunk (in units of system default page size) | ||
| 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 | 1 If the chunk is in a blobspace, 0 if not | ||
| is_sbchunk | integer | 1 If the chunk is a sbspace, 0 if not | ||
| 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 | ||
| 512 | 0x0200 | Chunk is part of a blobspace | ||
| 1024 | 0x0400 | Chunk is being dropped | ||
| 2048 | 0x0800 | Chunk is part of an optical stageblob | ||
| 4096 | 0x1000 | Chunk is inconsistent | ||
| 16384 | 0x4000 | Chunk contains temporary log space | ||
| 32768 | 0x8000 | Chunk was added during roll forward | ||
| fname | char(256) | Pathname for the file or device of this chunk | ||
| mfname | char(256) | 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 | smallint | Mirrored chunk flags; values and meanings are the same as the flags column. | ||