Sybase 12.4.2 manual Troubleshooting startup, shutdown, and connections

CHAPTER 2 Running Adaptive Server IQ

Troubleshooting startup, shutdown, and connections

See the sections that follow for help in resolving problems with your database server, connections, and DBISQL. For other troubleshooting hints, see the Adaptive Server IQ Troubleshooting and Error Messages Guide.

What to do if you can’t start Adaptive Server IQ

This section describes some common problems when starting the database server.

Ensure that your files are valid

The server will not start if the existing transaction log is invalid. For example, during development, you may replace a database file with a new version, without deleting the transaction log at the same time. This causes the transaction log file to be different from the database, and results in an invalid transaction log file.

The same is true for the IQ Temporary Store file.

Ensure that you have sufficient disk space for your temporary file

Adaptive Server IQ uses a temporary file to store information while running. This file is stored in the directory pointed to by the TMP or TEMP environment variable, or the ASTMP environment variable on UNIX. On Windows NT, this directory is typically c:\temp. On UNIX, if more than one database server is running on the same machine, each user needs a separate temporary directory; typically this directory is set to /tmp/.userid.

If you do not have sufficient disk space available to the temporary directory, you will have problems starting the server.

93