Technical Support

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.

Technical Support needs information about your environment to resolve your problem. Before contacting Technical Support, run the getiqinfo script to collect as much information as possible automatically. You may also need to collect some information manually. Providing this information helps expedite the resolution of your problem.

In this list, * indicates items collected by getiqinfo:

• Sybase IQ version (for example, 15.1 GA or ESD level)

• Type of hardware, amount of memory, number of CPUs*

• Operating system and version (for example, Microsoft Windows 2008 Service Pack 1)*

• Operating system patch level

• Front-end tool used (for example, Business Objects Crystal Reports)

• Connectivity protocol used (for example, ODBC, JDBC, Tabular Data Stream™ (TDS))

• Open Client version

• Configuration type (single user or multiuser)

• Message log file* (very important)

  Named dbname.iqmsg, located by default in the directory where you started the database server

• Stack trace file for the date and time this problem occurred (if applicable)

  Named stktrc-YYYYMMDD-HHMMSS_#.iq, located in the directory where you started the database server*

• Command or query that produced the error

• Query plan* (recorded in .iqmsg file)

  The query plan is collected automatically by getiqinfo. If you collect information manually, you must type these commands and then rerun the command that produced the error:

  SET TEMPORARY OPTION Query_Plan = 'ON'
  

  SET TEMPORARY OPTION Query_Detail = 'ON'
  

  SET TEMPORARY OPTION Query_Plan_As_Html= 'ON'
  

  SET TEMPORARY OPTION Query_Plan_As_Html_Directory=
  'ON'
  

  The plan will be in the message log file.

  If you have performance problems, set this option:

  SET TEMPORARY OPTION Query_Plan_After_Run = 'ON'
  

  This enables Technical Support to see which steps in the query processing used the time.

• Server logs

  • For UNIX and Linux: IQ-15_1/logfiles/<servername>.nnnn.stderr and IQ-15_1/logfiles/<servername>.nnnn.srvlog*

  • On Windows platforms: %ALLUSERSPROFILE%SybaseIQ\logfiles\ <servername>.nnnn.srvlog*

    For example, on Windows 2003 the server log files are located in C:\Documents and Settings\All Users\SybaseIQ\logfiles and on Windows 2008 the server log files are located in C:\ProgramData\SybaseIQ\logfiles

• Startup and connection option settings, from the configuration file (by default, dbname.cfg)*

• Database option settings and output from sa_conn_properties* (if the server is still running)

• Schema and indexes for the database

• Output from sp_iqstatus and sp_iqcheckdb

• On multiplex databases, you must execute getiqinfo on each node (coordinator and secondary nodes)

• Screen snapshot of the problem, if possible

A checklist for recording this information for Technical Support is provided at the end of this release bulletin.

For more information on getiqinfo, see “Collecting diagnostic information using getiqinfo” in Chapter 14, “Troubleshooting Hints” in the System Administration Guide: Volume 1.