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 |
Constraints on underlying system table:
Primary key (dbspace_id)
Foreign key (dbspace_id) references SYS.ISYSDBSPACE(dbspace_id)