The getiqinfo script collects all of the following information:
Type of hardware, amount of memory, CPU type, speed, number of CPUs
Operating system (for example, Sun Solaris 2.10)
Swap space size
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-15_1/logfiles/<servername>.000n.stderr and IQ-15_1/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 also 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
A checklist for recording information that Technical Support may need is provided at the end of this chapter, in the unlikely event that you need to collect this information manually.
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 then rerunning the command
that produced the error.
SET TEMPORARY OPTION QUERY_PLAN = 'ON'
SET TEMPORARY OPTION QUERY_DETAIL = 'ON'
The query plan is in the message log file. The default values for these options are QUERY_PLAN = ON and QUERY_DETAIL = OFF.
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.
