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 | ||
|---|---|---|---|---|
| dbsnum | smallint | Dbspace number | ||
| name | char(128) | Dbspace name | ||
| owner | char(32) | User ID of owner of the dbspace | ||
| fchunk | smallint | Number of the first chunk in the dbspace | ||
| nchunks | smallint | Number of chunks in the dbspace | ||
| pagesize | integer | Page size | ||
| is_mirrored | integer | 1 If dbspace is mirrored, 0 if not | ||
| is_blobspace | integer | 1 If the dbspace is a blobspace, 0 if not | ||
| is_sbspace | integer | 1 If the dbspace is a sbspace, 0 if not | ||
| is_temp | integer | 1 If the dbspace is a temporary dbspace, 0 if not | ||
| flags | smallint | Flags | Hexadecimal | Meaning |
| 1 | 0x0001 | Dbspace has no mirror | ||
| 2 | 0x0002 | Dbspace uses mirroring | ||
| 4 | 0x0004 | Dbspace mirroring is disabled | ||
| 8 | 0x0008 | Dbspace is newly mirrored | ||
| 16 | 0x0010 | Space is a blobspace | ||
| 32 | 0x0020 | Blobspace is on removable media | ||
| 64 | 0x0040 | Blobspace is on optical media | ||
| 128 | 0x0080 | Blobspace has been dropped. | ||
| 256 | 0x0100 | Blobspace is an optical stageblob | ||
| 512 | 0x0200 | Space is being recovered | ||
| 1024 | 0x0400 | Space has been physically recovered | ||
| 2048 | 0x0800 | Space is in logical recovery | ||
| 32768 | 0x8000 | Space is an sbspace | ||