You can run the getiqinfo script to collect much of this information.
Information requested |
Value |
|---|---|
type of hardware |
|
amount of memory |
|
number of CPUs |
|
operating system name and version (e.g., Sun Solaris 2.9) |
|
operating system patch level |
|
front end tool used (e.g., Brio Query) |
|
connectivity protocol used (e.g., ODBC, JDBC, TDS) |
|
Open Client version |
|
configuration type (single or multiuser) |
|
message log file (dbname.iqmsg) |
|
stack trace file stktrc-YYYYMMDD-HHNNSS_#.iq |
|
command or query that produced the error |
|
start-up option settings |
|
connect option settings |
|
database option settings |
|
schema and indexes for the database |
|
sp_iqstatus output |
|
query plan: set options (Query_Plan, Query_Detail, Query_Plan_After_Run), rerun command or query |
