Presents group information from ISYSIQINFO in a readable format.
The ISYSIQINFO system 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 |
---|---|---|
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 SAP Sybase IQ
16.0) Mode of the server that last
opened the catalog read-write. One of the following values.
|