Switches for the start_asiq utility

The following utility switches were omitted from Table 1-1 in the Sybase IQ Utility Guide:

Table 11: Server start-up options for start_asiq

Switch

Description

-cc {+|-}

Enable/disable page collection for cache warming

-cr {+|-}

Enable/disable cache warming

-cs

Display cache sizing statistics

-cv {+|-}

Enable/disable cache warming status messages

-f

Force database to start without transaction log

-gf

Disable firing of triggers

-iqnolocalreplay 1

Do not replay the TLV log after synchronizing a multiplex.

-iqnomain 1

Start a query server with a local store without opening shared IQ Main Store.

-iqnotemp size

Create a temporary file in place of the defined temporary dbspace. The argument to the switch specifies the file size in MB an argument to the switch.

-oe filename

Set filename to log start-up errors, fatal errors, and assertions

-startdir dirname

Start the server in the specified directory. If you use this parameter on Windows, IQ assumes that each server is being started by the Sybase IQ Agent, and starts the server in the background

If there is a problem starting the server, start_asiq returns a non-zero value. If you did not specify a log file after the -o switch on start-up, the error is written to the first one of the following that is defined: