Presents group information from ISYSIQDBFILE in a readable format.
This view replaces the deprecated system view SYSIQFILE.
Column name |
Column type |
Description |
|---|---|---|
dbfile_id |
small int |
Unique ID for the dbfile |
start_block |
rowid |
Number of the first block |
block_count |
rowid |
Number of blocks for this file (dbspace) |
reserve_size |
rowid |
Preallocated file system space for the dbspace |
allocated |
char(1) |
Defines whether the segment is preallocated (T) or autoallocated (F) |
data_offset |
unsigned int |
Identifies the byte location of where the Sybase IQ data starts, relative to the beginning of the raw partition |
create_time |
timestamp |
Date and time the file was created |
last_modified |
timestamp |
Date and time the file was last modified |
read_write |
char(1) |
T indicates read-write |
online |
char(1) |
T indicates online |
create_txn_id |
xact_id |
Transaction ID that created the dbfile |
alter_txn_id |
xact_id |
Transaction ID that last modified read_write status |
server_id |
unsigned int |
Multiplex server name |
file_name |
text |
the IQ dbspace name used by the multiplex server to open the IQ dbspace |
Constraints on underlying system table
Foreign key (server_id) references SYS.ISYSIQMPXSERVER
Unique (server_id, file_name)
