Collecting diagnostic information using getiqinfo

Sybase IQ includes a script for collecting information that Sybase Technical Support needs to diagnose problems. The getiqinfo script collects information about the operating system environment, the Sybase IQ environment, and log files.

Run this script before reporting a problem to Sybase Technical Support. By doing so, you can help Sybase staff resolve your issue more quickly, with less effort on your part.

The getiqinfo script automatically collects all of the information discussed in “Reporting problems to Technical Support”, as well as other information that may be needed to resolve your issue.

The getiqinfo script is not designed for troubleshooting Sybase IQ installations and does not provide on-site troubleshooting facilities. This script executes successfully only when the Sybase IQ environment is properly set up and the server is running.

Before you run getiqinfo

Have the following information ready before running the script:

If possible, leave the Sybase IQ server running, or start the server before running getiqinfo. This allows the script to collect internal database data that is only available when Sybase IQ is running. The script does not automatically start the server.

The script runs with the same environment settings that are used to start the Sybase IQ server. getiqinfo uses some IQ-specific environment variables to search for files.

The script puts collected data in the current directory (where you start the program). Be sure you have enough space under that directory. The script does not prompt for an alternative, but you can modify the script to change the output location by resetting the variable DEST_DIR.

Running the getiqinfo script

On UNIX platforms, getiqinfo is a shell script. On Windows platforms, getiqinfo.bat is a batch script in the ASIQ-12_7\win32 directory.

StepsTo run getiqinfo:

The steps vary for UNIX and Windows platforms.

  1. Start the script according to your platform:

    • At the UNIX command prompt, in the ASIQ-12_7/bin directory, type:

      getiqinfo.sh
      
    • In the Windows menu, enter Start → Run → <install_path>\ASIQ-12_7\win32\getiqinfo.bat.

  2. As the program prompts you, enter:

    • The directory of the database file. This is also the default location of the .iqmsg file, and the stktrc*.iq file on UNIX.

    • The base name of the database file (the file name without the .db suffix). This is also the default base name of the .iqmsg file.

    • Other directories to search for these files

    • Sybase IQ engine name (server name) and port number for this database server

    • User ID and password with DBA privileges for this database

    • The full path to the configuration file used to start the Sybase IQ server, if one was used

    • The full path to the output file in the -zo server option, if one was specified

The program also directs you to send the listed files to Sybase Technical Support.