Diagnostic Tools

If temporary dbfiles cannot be opened or are damaged, you can restore the database to a different temporary file topology.

The sp_iqstatus stored procedure provides a variety of SAP IQ status information.

By default, SAP IQ displays information about your database during insert and load operations in the IQ message log (.iqmsg file).

If you suspect problems in your database, try running the stored procedure sp_iqcheckdb.

When diagnosing server startup, resource, or processing issues, you may need to check the current values of database options and server startup options.

When diagnosing a problem, you may want to know what statement was executing when the problem occurred.

To isolate some types of problems, especially problems with queries, log server requests.

The database option DEDICATED_TASK lets the DBA dedicate a request handling task to handle requests from a single connection.

If your server returns a communication error on startup, you may want to set the -z command line option when you start the server.