Information Collected by getiqinfo

• Type of hardware, amount of memory, CPU type, speed, number of CPUs

• Operating system (for example, Sun Solaris 2.10)

• Swap space size

• SAP Sybase IQ version and EBF level, and Anywhere version

• Stack trace file for the date and time this problem occurred, named stktrc-YYYYMMDD-HHMMSS_#.iq, in the directory where you started the database server. (UNIX and Linux platforms only)

• Command or query that produced the error

• Message log file, named dbname.iqmsg, located, by default, in the directory where you started the database server

• Query plan (recorded in .iqmsg file; see the note below)

• Server logs

  • For UNIX, IQ-16_0/logfiles/<servername>.000n.stderr and IQ-16_0/logfiles/<servername>.000n.srvlog

  • On Windows platforms, if needed, you must restart the server and manually collect a copy of the console window

• 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)

The following information is not collected by getiqinfo, but may be requested by Technical Support:

• Connectivity protocol used (for example, ODBC, JDBC, TDS)

• Open Client version

• Configuration type (single user or multi user)

• Front-end tool used (for example, Brio Query)

• Schema and indexes for the database

• Output from sp_iqcheckdb procedure

Query plan detail is collected automatically by getiqinfo if the options below are set. You can also collect this information manually, by setting the options and re-running the command that produced the error.

SET TEMPORARY OPTION QUERY_PLAN = 'ON'

SET TEMPORARY OPTION QUERY_DETAIL = 'ON'

If you have performance problems, set the following option:

SET TEMPORARY OPTION QUERY_PLAN_AFTER_RUN = 'ON'

Setting this option enables Technical Support to see which steps in the query processing used the time.