IBM Support

Collecting Data for an Informix Server performance issue on AIX platforms

Question & Answer


Question

Collecting data for general engine performance problems with Informix Dynamic Server on AIX. Gathering this information before calling IBM® support helps familiarize you with the troubleshooting process and saves you time.

Answer



Collecting performance specific information for versions 11.70.xC1 and later

In versions of the Informix Server engine 11.70.xC1 and later ifxcollect can be used to gather diagnostic information without utilizing the onstats.sh script. To gather performance specific information execute the following command while experiencing performance problems:

$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

Collecting information for versions prior to 11.70.xC1

For all versions of Informix Server prior to 11.70.xC1, gather the following information for any problem:

MustGather: General Information to collect for Informix Family product problems

For all versions of Informix Server prior to 11.70.xC1 gather the following performance specific information:
  1. Obtain the "onstats.sh.txt" file (attached below) and save it to the directory it will be executed from
  2. Rename onstats.sh.txt to onstats.sh
  3. Make onstats.sh executable
  4. Execute onstats.sh while experiencing the performance problem. Use the sh shell

Note: There are similar articles specific to Linux, HP-UX, and Solaris platforms.

Submitting information to IBM Support

Once you have collected your information, you can begin Problem Determination through the product Support web page, or 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.

Internal Use Only


Comment from customer:

"need to specify what information is sent to IBM, as the details are not spelled out, I could send the complete PERFORMANCE file, or do I send iostats.out?"


This from the script....the results should be in a zip or gz
file. Maybe on some systems the zip or gz is not running.
Customer should have specified. There should have been an error.
What happened?

echo "========================================================="
if [ -f ${CASENUMBER}.perf.zip ]
then
echo "Please submit file \"${CASENUMBER}.perf.zip\" to"
echo "IBM Informix technical support."
else
if [ -f ${CASENUMBER}.perf.tar.gz ]
then
echo "Please submit file \"${CASENUMBER}.perf.tar.gz\" to"
echo "IBM Informix technical support."
else
echo "Program did not create file to submit."
echo "Please contact IBM Informix technical support."
fi
fi
echo "========================================================="

onstats.sh.txt

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.0;11.1;11.5;11.7","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21269116