Checklist: information for Technical Support

You can run the getiqinfo script to collect much of this information.

Information requested

Value

Sybase IQ version (for example 15.1 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.nnnn.svrlog and server.nnnn.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