Technical Support needs information about your environment to resolve your problem.
Before contacting Technical Support, run the getiqinfo script to automatically collect as much information as possible. You may also need to collect some information manually .
The query plan is collected automatically by getiqinfo. If you manually collect information, enter commands like these, then re-run the command that produced the error.
SET TEMPORARY OPTION Query_Plan = 'ON' SET TEMPORARY OPTION Query_Detail = 'ON' SET TEMPORARY OPTION Query_Plan_As_Html= 'ON' SET TEMPORARY OPTION Query_Plan_As_Html_Directory= '/mymachine1/user/myqueryplans'
SET TEMPORARY OPTION Query_Plan = 'ON' SET TEMPORARY OPTION Query_Detail = 'ON' SET TEMPORARY OPTION Query_Plan_As_Html= 'ON' SET TEMPORARY OPTION Query_Plan_As_Html_Directory= 'C:\user1\myqueryplans'
The plan is in the message log file.
If you have performance problems, set this database option:
SET TEMPORARY OPTION Query_Plan_After_Run = 'ON'
This enables Technical Support to see which steps in the query processing used the time.
On Windows platforms: %ALLUSERSPROFILE%SybaseIQ\logfiles\ <servername>.nnnn.srvlog*
For example, on Windows 2003, the server log files are located in C:\Documents and Settings\All Users\SybaseIQ\logfiles. On Windows 2008, the server log files are located in C:\ProgramData\SybaseIQ\logfiles.
A checklist for recording this information for Technical Support is provided in this release bulletin.
See Collecting Diagnostic Information Using getiqinfo in Administration: Database.