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 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 IQ installations and does not provide on-site troubleshooting facilities. This script executes successfully only when the 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 IQ message file has been renamed
If possible, leave the IQ server running, or start the server before running getiqinfo. This allows the script to collect internal database data that is only available when 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 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 ASIQ-12_6\win32 directory.
The steps vary for UNIX and Windows platforms.
Start the script according to your platform:
At the UNIX command prompt, in the ASIQ-12_6/bin directory, type:
getiqinfo.sh
In the Windows menu, enter Start → Run → <install_path>\ASIQ-12_6\win32\getiqinfo.bat.
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
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 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: