Question & Answer
Question
What information should be collected when you experience a performance problem with your software? Collect data using the script provided here. Collecting this information before calling IBM support will help you understand the problem and save time analyzing the data.
Answer
- Collecting data for diagnosing engine hangs on versions 11.70.xC1 and later
- Collecting information for versions prior to 11.70.xC1
- Submitting information to IBM Support
In versions of the Informix Server engine 11.70.xC1 and later ifxcollect can be used to gather diagnostic information without utilizing the hangstats.sh script. To gather the information execute the following command while experiencing the engine hang:
$INFORMIXDIR/bin/ifxcollect -c performance -s general
Executing ifxcollect will create a tar file in $INFORMIXDIR/isa/data that can be uploaded to IBM for review. The format of the file is ifxcollect.<timestamp>.tar. Uploading the file can be accomplished using any of the methods described in the "Submitting information to IBM Support section".
For additional information on ifxcollect see the following link:
Collecting data with the ifxcollect tool
For all versions of Informix Server prior to 11.70.xC1, gather the following information for any problem:
General Information to collect for Informix Family product problems
For all versions of Informix Server prior to 11.70.xC1 gather the following information during the engine hang:
Before continuing, confirm that onstat commands will execute by entering this command: onstat -g ath. If the command does not return quickly, do not continue with any of the instructions below. Contact IBM Informix technical support.
- Obtain the file hangstats.sh.txt (attached below). Do all transfers in binary mode.
- Copy hangstats.sh.txt to hangstats.sh
- Move hangstats.sh to a directory where it can be executed
- Make hangstats.sh executable
- Execute hangstats.sh while you are experiencing the hang. Use the sh shell
- Collect a shared memory dump. Instructions are provided at the end of the hangstats.sh execution.
Note: There are similar articles containing scripts specific to LINUX, Solaris, HP-UX, and AIX platforms.
Once you have collected the preceding information, simply submit the diagnostic information to IBM support.
You can submit files using one of following methods to help speed problem diagnosis:
- IBM Support Assistant (ISA)
- Electronic Service Request (ESR)
- FTP to the Enhanced Customer Data Repository (ECuRep)
See the Related information article, Submitting diagnostic information to IBM Technical Support for problem determination.
Related Information
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"10.0;11.1;11.5;7.3;9.4;11.7","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21269122