Information collected by getiqinfo

The getiqinfo script collects all of the following information:

The following information is not collected by getiqinfo, but may also be requested by Technical Support:

A checklist for recording information that Technical Support may need is provided at the end of this chapter, in the unlikely event that you need to collect this information manually.

NoteQuery plan detail is collected automatically by getiqinfo if the options below are set. You can also collect this information manually, by setting the options and then rerunning the command that produced the error.

SET TEMPORARY OPTION QUERY_PLAN = 'ON'
SET TEMPORARY OPTION QUERY_DETAIL = 'ON'

The query plan is in the message log file. The default values for these options are QUERY_PLAN = ON and QUERY_DETAIL = OFF.

If you have performance problems, set the following option:

SET TEMPORARY OPTION QUERY_PLAN_AFTER_RUN = 'ON'

Setting this option enables technical support to see which steps in the query processing used the time.