SYSIQINFO system table

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 Sybase IQ database was created using CREATE DATABASE. It always contains only one row.

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.