SYSIQINFO System View

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.

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

unsigned bigint

For internal use

rd_commit_txn_id

unsigned bigint

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.3) 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.

.