SYSIQDBSPACE System View

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)