Presents group information from ISYSIQINFO in a readable format.
The ISYSIQINFO system table indicates the database characteristics as defined when the Sybase IQ database was created using CREATE DATABASE. It always contains only one row.
Column name |
Column type |
Description |
|---|---|---|
create_time |
TIMESTAMP NOT NULL |
Date and time that the database was created |
update_time |
TIMESTAMP NOT NULL |
Date and time of the last update |
file_format_version |
UNSIGNED INT NOT NULL |
File format number of files for this database |
cat_format_version |
UNSIGNED INT NOT NULL |
Catalog format number for this database |
sp_format_version |
UNSIGNED INT NOT NULL |
Stored procedure format number for this database |
block_size |
UNSIGNED INT NOT NULL |
Block size specified for the database |
chunk_size |
UNSIGNED INT NOT NULL |
Number of blocks per page as determined by the block size and page size specified for the database |
file_format_date |
CHAR(10) NOT NULL |
Date when file format number was last changed |
dbsig |
BINARY(136) NOT NULL |
Used internally by catalog |
commit_txn_id |
unsigned bigint |
For internal use |
rd_commit_txn_id |
unsigned bigint |
For internal use |
multiplex name |
CHAR(128) NULL |
Name of the multiplex that this database is a member of |
last_multiplex_mode |
TINYINT NULL |
(Column unused in Sybase IQ 15.3) Mode of the
server that last opened the catalog read-write. One of the following values.
|