sysdbspaces
The sysdbspaces table contains a description of each of the storage spaces that the database server manages.
| Column | Type | Description | ||
|---|---|---|---|---|
| dbsnum | smallint | Space number | ||
| name | char(128) | Space name | ||
| owner | char(32) | User ID of owner of the space | ||
| fchunk | smallint | Number of the first chunk in the space | ||
| nchunks | smallint | Number of chunks in the space | ||
| create_size | decimal | The minimum size of a chunk that can be created for this space using the storage pool. | ||
| extend_size | decimal | The minimum size by which a chunk in this storage space can be extended, either manually or automatically. | ||
| pagesize | integer | Page size | ||
| is_mirrored | integer | 1 = The space is mirrored 0 = The space is not mirrored |
||
| is_blobspace | integer | 1 = The space is a blobspace 0 = The space is not a blobspace |
||
| is_sbspace | integer | 1 = The space is an sbspace 0 = The space is not an sbspace |
||
| is_temp | integer | 1 = The space is a temporary dbspace 0 = The space is not a temporary dbspace |
||
| is_encrypted | integer | 1 = The space is encrypted 0 = The space is not encrypted |
||
| flags | smallint | Each bit position represents a separate flag. Thus, it might be easier
to read values in this column if you return the values with the HEX function.
|
||