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 PRIMARY KEY ( create_time ), )
This table indicates the database characteristics as defined when the IQ database was created using CREATE DATABASE. It always contains only one row.
last_full_backup The completion time of the most recent full backup.
last_incr_backup The completion time of the most recent incremental backup.
create_time The date and time created.
update_time The 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.
