The sysdbspaces table describes each of the dbspaces that the database server manages. In the flags column, each bit position represents a separate flag. Thus, it might be easier to read values in the flags column if the values are returned using the HEX function.
| Column | Type | Description | ||
|---|---|---|---|---|
| coserver_id | integer | Coserver number | ||
| name | char(128) | Dbspace name | ||
| dbsum | integer | Dbspace number | ||
| owner | char(32) | User ID of owner of the dbspace | ||
| fchunk | integer | Number of the first chunk in the dbspace | ||
| nchunks | integer | Number of chunks in the dbspace | ||
| is_mirrored | integer | 1 if dbspace is mirrored, 0 if not | ||
| is_blobspace | integer | (always 0) | ||
| is_temp | integer | 1 if the dbspace is a temporary dbspace, 0 if not | ||
| is_skipreplay | integer | 1 if log replay can be skipped for this dbspace | ||
| flags | integer | Flags 1 | Hexadecimal 0x0001 | Meaning Dbspace has no mirror. |
| 2 | 0x0002 | Dbspace uses mirroring. | ||
| 4 | 0x0004 | Dbspace mirroring is disabled. | ||
| 8 | 0x0008 | Dbspace is newly mirrored. | ||
| 512 | 0x0200 | Space is being recovered. | ||
| 1024 | 0x0400 | Space has been physically recovered. | ||
| 2048 | 0x0800 | Space is in logical recovery. | ||
| 131072 | 0x20000 | Skip logical replay. | ||