The getiqinfo script collects
information.
- 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'
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.