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 (for example, HP Itanium HP-UX 11.23) |
|
operating system patch level |
|
front end tool used (for example, Brio Query) |
|
connectivity protocol used (for example, ODBC, JDBC, TDS) |
|
Open Client version |
|
configuration type (single or multiuser) |
|
message log file (dbname.iqmsg) |
|
log file (.svrlog and .stderr) |
|
stack trace file (stktrc-YYYYMMDD-HHNNSS_#.iq) |
|
command or query that produced the error |
|
startup 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 |
