You Cannot Run start

If you cannot run the start_iq command and you normally use a configuration file or other command line switches, try starting the server using only start_iq with the server name and database name.

If the server starts with this simple command, then the problem is probably caused by one or more of the switches or parameters entered on the command line or in the configuration file. Try to isolate which parameter or switch is preventing the server from starting.

If the server does not start with the most basic start_iq command, try starting the iqdemo demo database using your configuration file and command line switches. If the server starts with the iqdemo database, there may be a problem with your database.

If you still cannot run the start_iq command, use the Tools > Sybase IQ 15 > Start Server in Sybase Central or the iqsrv15 command.

Note: Use iqsrv15 only for troubleshooting server start-up errors. Always use start_iq to start Sybase IQ servers.

Before running iqsrv15, you must perform the following tasks (which start_iq normally does for you):

Remove all limits, and then set limits on the stack size and descriptors. To do so, go to the C shell and issue these commands:
```
% unlimit 
% limit stacksize 8192 
% limit descriptors 4096
```
Note: Be aware that unlimit affects soft limits only. You must change any hard limits by setting kernel parameters.
Set all server options appropriately for your platform. For details about appropriate options and how to set them in a configuration file, see the Installation and Configuration Guide.
Add the path $IQDIR/lib64/ocs to the environment to load the engine and required libraries before you invoke iqsrv15. Put this path in the environment only during testing, as follows:
On AIX:
```
% setenv LIBPATH "${LIBPATH}:{IQDIR15}/lib64/ocs" 
```
On other UNIX/LINUX platforms:
```
% setenv LD_LIBRARY_PATH "${LD_LIBRARY_PATH}:${IQDIR15}/lib64/ocs"
```

For any database created with a relative path name, you must start the database server from the directory where the database is located.

Note what directory you are in when you start the server. The server startup directory determines the location of any new database files you create with relative path names. If you start the server in a different directory, Sybase IQ cannot find those database files.

Any server startup scripts should change directory to a known location before issuing the server startup command.

Syntax for iqsrv15 is as follows:

iqsrv15 -n server-name -gm number
[ other-server-switches ] [ database-file [ database-switches ] ]

Note: On the iqsrv15 command line, the last option specified takes precedence, so if you want to override your configuration file, list any options you want to change after the configuration file name. For example:

iqsrv15 @iqdemo.cfg -x 'tcpip{port=1870}' iqdemo

The –x parameter here overrides connection information in the iqdemo.cfg file.

If the server fails to start when you run the iqsrv15 command, then attempt to start again using the iqsrv15 utility with minimal switches and parameters. For example:

iqsrv15 -n <servername> <dbname>.db -c 32m
-gd all -gl all

If the server starts with the minimum parameters and switches, then one of the parameters or switches normally used to start the server may be causing a problem. Try to isolate which parameter or switch is preventing the server from starting.

When you start the server with the iqsrv15 command, it does not run in the background, and messages do not automatically go to the server log. However, if you include the -o file name server switch, messages are sent to the named file in addition to the server window.

You Cannot Run start_iq