iqinit Database Administration Utility

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

iqinit is the IQ version of the SQL Anywhere dbinit utility. iqinit lets you create either an IQ or SQL Anywhere database from the command line without starting a database:
  • If no iqinit command line parameters are specified, iqinit creates a SQL Anywhere database.
  • If the -iqpath command line parameter is specified, iqinit creates an IQ database.

Syntax

iqinit  options ] new-database-file

Parameters

This table lists the available options for the iqinit utility.

iqinit options

Option

Description

@data

For descriptions of options common to dbinit and iqinit, see SQL Anywhere Server - Database Administration > Administering Your Database > Database administration utilities > Initialization utility (dbinit).

-a

-af

-b

-c

-dba  [ DBA-user ] [ pwd  ]

-dbs sizek | 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.

-iqtmpreservesize

The size in MB to reserve for the temporary IQ store.

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