CREATE TABLE SYS.SYSIQINFO ( last_full_backup TIMESTAMP, last_incr_backup TIMESTAMP, create_time TIMESTAMP NOT NULL, update_time TIMESTAMP NOT NULL, file_format_version UNSIGNED INT NOT NULL, cat_format_version UNSIGNED INT NOT NULL sp_format_version UNSIGNED INT NOT NULL, block_size UNSIGNED INT NOT NULL chunk_size UNSIGNED INT NOT NULL, file_format_date CHAR(10) NOT NULL, dbsig BINARY(136) NOT NULL, multiplex_name CHAR(128) NULL, last_multiplex_mode TINYINT NULL, PRIMARY KEY ( create_time ), )
This 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 are new for Sybase IQ 15.2.
last_full_backup Completion time of the most recent full backup.
last_incr_backup Completion time of the most recent incremental backup.
create_time Date and time created.
update_time Date and time of the last update.
file_format_version File format number of files for this database.
cat_format_version Catalog format number for this database.
sp_format_version Stored procedure format number for this database.
block_size Block size specified for the database.
chunk_size Number of blocks per chunk as determined by the block size and page size specified for the database.
file_format_date Date when file format number was last changed.
dbsig Used internally by catalog.
multiplex_name Used internally by catalog.
last_multiplex_mode Mode of the server that last opened the catalog read-write. One of the following values.
0 – Single Node.
1 – Reader.
2 – Coordinator.
3 – Writer.
