Diagnostic Tools

Several Sybase IQ tools help you diagnose various conditions.

• Restoring to a New Temporary File Topology
  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
  The sp_iqstatus stored procedure provides a variety of IQ status information.
• Interpreting Notification Messages
  By default, Sybase IQ displays information about your database during insert and load operations in the IQ message log (.iqmsg file).
• The sp_iqcheckdb Stored Procedure
  If you suspect problems in your database, try running the stored procedure sp_iqcheckdb.
• Checking Database and Server Startup Option Values
  When diagnosing server startup, resource, or processing issues, you may need to check the current values of database options and server startup options.
• Finding the Currently Executing Statement
  When diagnosing a problem, you may want to know what statement was executing when the problem occurred.
• Logging Server Requests
  For isolating some types of problems, especially problems with queries, logging server requests is helpful.
• Connection for Collecting Diagnostic Information
  The database option DEDICATED_TASK lets the DBA dedicate a request handling task to handling requests from a single connection.
• Diagnosing Communications Issues
  If your server returns a communication error on startup, you may want to set the -z command-line option when you start the server.