Presents group information from ISYSIQDBSPACE in a readable format.
| Column Name | Column Type | Description |
|---|---|---|
| dbspace_id | small int | Each dbspace in a database is assigned a unique number (dbspace ID) |
| last_modified | timestamp | Time at which the dbspace's read-write status was last modified |
| segment_type | char(8) | Segment type: Main, Temp or Msg |
| read_write | char(1) | 'T' – read writable; 'F' – read only |
| online | char(1) | 'T' – online; 'F' – offline |
| create_txn_id | unsigned bigint | Transaction ID that create the dbspace |
| alter_txn_id | unsigned bigint | Transaction ID that last modified read_write status |
| striping_on | char(1) | 'T' – disk striping on; 'F' – disk striping off |
| stripe_size_kb | unsigned int | Number of kilobytes written to each file of the dbspace before the disk striping algorithm moves to the next dbfile |
| is_rlv_store | char(1) | 'T' – dbspace is a RLV store dbspace; 'F' – dbspace is a MIN, SHARED_TEMP, or TEMPORARY store dbspace. |
Constraints on underlying system table:
Primary key (dbspace_id)
Foreign key (dbspace_id) references SYS.ISYSDBSPACE(dbspace_id)