Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 113 / 536

CHAPTER 2 Running Adaptive Server IQ
93
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.