You can run the getiqinfo script to collect much of this information.
Information requested |
Value |
|---|---|
Sybase IQ version (for example 15.0 GA or ESD number) |
|
sp_iqlmconfig output |
|
type of hardware |
|
amount of memory |
|
number of CPUs |
|
operating system name and version (for example, Microsoft Windows 2008 Service Pack 1) |
|
operating system patch level |
|
front end tool used (for example, Business Objects Crystal Reports) |
|
connectivity protocol used (for example, ODBC, JDBC, TDS) |
|
Open Client version |
|
configuration type (single node or multiplex) |
|
message log file (dbname.iqmsg) |
|
server log files (server.nnn.svrlog and server.nnn.stderr) |
|
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, Query_Plan_As_Html, Query_Plan_As_Html_Directory, Query_Timing), rerun command or query |
|
Screen snapshot of the problem, if possible |
