Question & Answer
Question
What information should be collected when you experience a problem with your software? Collecting data for an IDS Client Connection Failure. Collecting this information before calling IBM support will help you understand the problem and save time analyzing the data.
Answer
Collecting general information
General Information to collect for Informix Family product problems
Collecting specific information
- How are you attempting to make the connection? i.e. ODBC, JDBC, OLE DB etc.
- Are other clients connecting to the database server?
- Are you able to connect to the database server through another connection type, such as telnet, ftp, etc., using the same client machine?
- Can you connect to the database server using a different client application (dbaccess, etc.)?
- If you have more than one type of connection type defined on the server (SHM, TLI, SOC), does another type of connection work?
- If you have more than one connection port defined for use on the database server, does another connection port work?
- Are there errors that occur on the server when the client connection failure occurs?
- Does the client application return an error when the connection failure occurs?
- Does onstat - show that the database server is On-Line?
- Does the problem happen to all clients or specific to a client machine or user?
- Is this the first time the client application is connecting to the database server or was it able to connect before?
Processes to run
Read the operating system man pages and IDS documentation for usage and other information about the following commands, if necessary. Run the following commands and collect the output:
- On UNIX, run ps -elf a few time for the client process if it is still running.
- On UNIX (where available), run truss/trace for the client process.
Files to collect
- Relevant lines from the /etc/hosts or hosts files from the client and database server.
- Relevant lines from the /etc/services or services files from the client and database server.
- sqlhosts files from the client and server
- Any core files generated during the problem.
- Profile or environment variables set for the client application
Collecting data for connection failures on versions 11.70.xC1 and above
In versions of the Informix Server engine 11.70.xC1 and above ifxcollect can be used to gather diagnostic information by executing the following command while experiencing connection problems:
$INFORMIXDIR/bin/ifxcollect -c connection -s failure
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
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
Related Information
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","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;11.70;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
Informix Servers
Software version:
10.0, 11.1, 11.5, 7.3, 9.4, 11.7, 11.70, 12.1
Operating system(s):
AIX, HP-UX, Linux, Solaris
Document number:
351709
Modified date:
20 January 2022
UID
swg21271765
Manage My Notification Subscriptions