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.
Have the following information ready before running the script:
Location of the database file
Full path of the configuration file used to start the server, if one is used
Full path of the .iqmsg file, if the Sybase IQ message file has been renamed
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.
On UNIX platforms, getiqinfo is a shell script. On Windows platforms, getiqinfo.bat is a batch script in the IQ-15_2\win32 directory.
The steps vary for UNIX and Windows platforms.
Start the script according to your platform:
At the UNIX command prompt, in the IQ-15_2/bin32 directory (on a 32-bit platform) or the IQ-15_2/bin64 directory (on a 64-bit platform), type:
getiqinfo.sh
In Windows, select Start > Run > <install_path>\IQ-15_2\bin32\getiqinfo.bat on a 32-bit platform or <install_path>\IQ-15_2\bin64\getiqinfo.bat((on a 64-bit platform.
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.
To run getiqinfo: