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. The multiplex_name and last_multiplex_mode columns were added for Sybase IQ 15.0.
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 |
xact_id |
For internal use. |
rd_commit_txn_id |
xact_id |
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.1) Mode of the server that last opened the catalog read-write. One of the following values.
|
