Setting IQ Create Database Preferences

Create a Sybase IQ connection profile for this database

Click this option to create a new Sybase IQ connection profile. (Default.)

The default name is the same as the database name. If a connection profile with the same name as the database already exists in WorkSpace, the tooling generates a new connection profile name by appending a number.

Case sensitive for string comparisons

Click this option to make all comparisons case sensitive, and to be compatible with ISO/ANSI SQL. Default is OFF (comparisons are case insensitive).

User IDs and other identifiers are case insensitive, even in case sensitive databases.

Install jConnect meta-information support

Click this option to use the Sybase jConnect JDBC driver to access system catalog information. You do not need to install jConnect to use JDBC for other purposes. Selected automatically when you select Create a Sybase IQ connection profile for this database.

Install JDK support

Click this option to use Java in your database. It installs entries for the Sybase runtime Java classes in the system tables.

Database page size, in bytes

Select a page size from the drop-down list. This is the page size for the Catalog Store which contains the system tables. Default is 4096.

Page size when you create the database cannot be larger than the page size used by the current Sybase IQ server. The first set of databases started sets the server page size.

IQ page size, in bytes

Page size for the IQ Store. Default is 131072 bytes.

IQ block size is based on the value of IQ page size.

IQ size, in MB

Size of the IQ Store. Default is 192 MB, which lets you create some tables and procedures and insert a few rows of data for testing purposes. The exact number of tables depends on the width of your data and the number of columns.

Maximum value is 128GB (128000MB). See the table of IQ size minimum values.

IQ temporary size is half of IQ size.