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.
|
Constraint: Primary key( create_time )