Resolving The Problem
Collecting data for connection pooling problems for IBM WebSphere Application Server. Gathering this information before calling IBM support will help familiarize you with the troubleshooting process and save you time.
Collecting data manually
- What back-end system are you connecting to (database, messaging system, enterprise information system)? What is the name and version of the back-end system? If the back-end system is remote, what platform is it running on?
- Provide a full description of the problem that you have encountered, including the stack traces of any errors or exceptions that are occurring. Provide any logs that contain the errors or exceptions.
- What are the JNDI names of the data sources or connection factories that are involved in the problem scenario?
- Run the collector tool to produce a JAR file containing your WebSphere Application Server configuration files and other logs that are useful to the WebSphere Application Server support team.
Enabling J2C traces on WebSphere Application Server:
If you are getting a connection error while using the test connection functionality, please set up the trace on the JVM where the test connection occurs. Please refer to the table below to determine the correct JVM:
Data source scope
JVM where the test connection operation occurs
Deployment Manager process
Node agent process (of the relevant node)
Node agent for each node that contains a cluster member
Server; if the server is unavailable, the test connection operation is retried in the node agent for the node that contains the application server.
If the error is not occurring during the test connection, enable the trace on the server(s) where the error or issue is occurring.
For releases of tWAS V9.0, V8.5, V8, and V7:
a. In the Application Server Administrative Console, expand Troubleshooting and select Logs and Trace.
b. In the Logging and Tracing page, select your server and then Diagnostic Trace.
c. Ensure that Enable Log is selected.
d. Under Trace Output, select File, and accept the defaults. It is recommended to set the number of historical trace files to 10 and the size of each historical trace file to 100MB.
e. Click OK and save your configuration.
f. Again, expand Troubleshooting and select Logs and Trace.
g. In the Logging and Tracing page, select your server and then Change Log Detail Levels.
h. Enter the following trace string:
If connecting to a database:
If connecting to a database and having SSL related errors:
If connecting to a messaging system:
If connecting to an enterprise information system:
i. Click OK and save your configuration.
j. Restart the Application Server.
k. Reproduce the problem.
l. Send the resulting trace output file(s) along with the application server logs and FFDC files. Follow instructions to send diagnostic information to IBM support
Exchanging data with IBM Support
To diagnose or identify a problem, it is sometimes necessary to provide Technical Support with data and information from your system. In addition, Technical Support might also need to provide you with tools or utilities to be used in problem determination. You can submit files using one of following methods to help speed problem diagnosis:
Read first and related MustGathers
11 February 2020