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 iqsrv16 command.

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

Before running iqsrv16, 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: unlimit affects soft limits only. You must change any hard limits by setting kernel parameters.
Set all server options appropriately for your platform. See the Installation and Configuration Guide guide.
Add the path $SYBASE/OCS-15_0/lib to the environment to load the engine and required libraries before you invoke iqsrv16. Put this path in the environment only during testing, as follows:
On AIX:
```
% setenv LIBPATH "${LIBPATH}:{SYBASE}/OCS-15_0/lib" 
```
On other UNIX/LINUX platforms:
```
% setenv LD_LIBRARY_PATH "${LD_LIBRARY_PATH}:${SYBASE}/OCS-15_0/lib"
```

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, SAP Sybase IQ cannot find those database files.

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

The syntax for iqsrv16 is:

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

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

iqsrv16 @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 iqsrv16 command, then attempt to start again using the iqsrv16 utility with minimal switches and parameters. For example:

iqsrv16 -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 iqsrv16 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