Initialization utility (iqinit)

The command line Initialization utility iqinit starts a database that gives the user executing iqinit permission to create a database. The user must have access to the computer and file system.

Syntax

iqinit  [ options ] new-database-file

Parameters

Table 4-6 lists the available options for the iqinit utility.

**Table 4-7: iqinit options**
Option	Description
@data	For descriptions of options common to dbinit and iqinit, see "Initialization utility (dbinit)" in SQL Anywhere Server – Database Administration.
-a
-af
-b
-c
-dba [ DBA-user ] [ pwd ]
-dbs size[ k \| m \| g \| p ]
-ea algorithm
-ek key
-ep
-et
-i
-k
-l
-le
-m filename
-n
-o filename
-p page-size
-q
-s
-t transaction-log-name
-z coll [ collation-tailoring-string
-ze encoding
-zn coll [ collation-tailoring-string
-iqblksize	The I/O transfer block size in bytes.
-iqmsgpath	The path name of the segment containing the Sybase IQ message trace file.
-iqpath	The path name of the main segment file containing the IQ data.
-iqpgsize	The page size in bytes for the Sybase IQ segment of the database.
-iqreservesize	The size in MB of the space to reserve for the IQ main store.
-iqsize	The size in MB of either the raw partition or OS file with the -iqpath.
-iqtmppath	The path name of the temporary segment file.
-iqtmpsize	The size in MB of either the raw partition or OS file for the -iqtmppath.

Example

This command creates a Sybase IQ database called bar.iq.

$ iqinit -iqpath bar.iq -iqsize 20M 
-iqpgsize 2048 
-iqreservesize 10M bar.db 
SQL Anywhere Initialization Utility Version 15.2.0.5530
Debug 
CHAR collation sequence:
ISO_BINENG(CaseSensitivity=Respect) 
CHAR character set encoding:  ISO_8859-1:1987 
NCHAR collation sequence:
UCA(CaseSensitivity=UpperFirst;
AccentSensitivity=Respect;
PunctuationSensitivity=Primary) 
NCHAR character set encoding:  UTF-8 
Creating system tables 
Creating system views 
Setting option values 
Database "bar.db" created successfully