ISYSIQINFO System Table

This table indicates the database characteristics as defined when the SAP Sybase IQ database was created using CREATE DATABASE. It always contains only one row.

Column name	Column type	Description
last_full_backup	TIMESTAMP	The completion time of the most recent backup.
last_incr_backup	TIMESTAMP	The completion time of the most recent incremental backup.
create_time	TIMESTAMP NOT NULL	The date and time when the database was created.
update_time	TIMESTAMP NOT NULL	The date and time of the last update.
file_format_version	UNSIGNED INT NOT NULL	The file format number of files for this database.
cat_format_version	UNSIGNED INT NOT NULL	The catalog format number for this database.
sp_format_version	UNSIGNED INT NOT NULL	The stored procedure format number for this database.
block_size	UNSIGNED INT NOT NULL	The block size specified for the database.
chunk_size	UNSIGNED INT NOT NULL	The number of blocks per chunk as determined by the block size and page size specified for the database.
file_format_date	CHAR(10) NOT NULL	The date when file format number was last changed.
dbsig	BINARY(136) NOT NULL	Used internally by catalog.
multiplex_name	CHAR(128) NULL	Used internally by catalog.
last_multiplex_mode	TINYINT NULL	The 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.

Constraint: Primary key( create_time )