MustGather: Connection pooling problems for WebSphere Application Server V6.1, V6.0, V5.1, and V5.0 releases
 Technote (troubleshooting)
 
Problem(Abstract)
MustGather for connection pooling problems for IBM® WebSphere® Application Server V6.1, V6.0, V5.1, and V5.0. Gathering this information before calling IBM support will help familiarize you with the troubleshooting process and save you time.
 
Resolving the problem

Do you want to automate the collection of MustGather data?
You can automatically collect this data using IBM Support Assistant (ISA) Lite - a special offering that contains the data collector component of the IBM Support Assistant Workbench.

For a full range of problem-solving features, install the IBM Support Assistant Workbench - your support workbench for finding answers and solving problems. The workbench contains all the data collection capability of ISA Lite plus much more!



If you have already contacted support, continue on to the component-specific MustGather information. Otherwise, click: MustGather: Read first for all WebSphere Application Server products.

Collecting connection pooling specific information
  1. What is the exact version and edition of the WebSphere Application Server installed?

    For example:
    • Base
    • Enterprise
    • WebSphere Business Integration Server Foundation
    • Network Deployment

  2. What backend system are you connecting to (database, messaging system, enterprise information system)? What is the name and version of the backend system? If the backend system is remote, what platform is it running on?

  3. If you are connecting to a database, what is the name and version of the JDBC™ driver that you are using?

  4. If you are connecting to a database, are you using a standard (V5) data source or a V4 data source?

  5. If you are connecting to a database, does the same problem occur when you perform the same operation in a Java™ program running outside of WebSphere Application Server using the same JDBC driver to connect to the database?

  6. 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.

  7. Under what circumstances does the problem occur? Does it occur every time a certain task is done or does it occur intermittently? Has this problem always occurred? If not, was a change recently made before the problem started to occur?

  8. What are the names and JNDI names of the data sources or connection factories that are involved in the problem scenario?

  9. Send the SystemOut.log file for the application server on which the problem occurs:
    • For V5, the file is located in the following directory:

      install_root/logs/server_name

    • For V6, the file is located in the following directory:

      install_root/profiles/profile_name/logs/server_name

  10. If the problem can be reproduced easily, enable a WebSphere Application Server trace:

    Note: If you are using a V4 data source, replace "WAS.j2c=all=enabled:RRA=all=enabled" with "com.ibm.ejs.cm.*=all=enabled" in the trace V5 trace instructions, and replace "WAS.j2c=all:RRA=all" with "com.ibm.ejs.cm.*=all" in the V6 trace instructions below.
    • For releases of V6.1 and V6:
      1. In the Application Server Administrative Console, expand Troubleshooting and select Logs and Trace.

      2. In the Logging and Tracing page, select your server and then Diagnostic Trace.

      3. Ensure that Enable Log is selected.

      4. Under Trace Output, select File, and accept the defaults.

      5. Click OK and save your configuration.

      6. Again, expand Troubleshooting and select Logs and Trace.

      7. In the Logging and Tracing page, select your server and then Change Log Detail Levels.

      8. Enter the following trace string:
        • If connecting to a database:

          *=info:WAS.j2c=all:RRA=all:WAS.database=all:Transaction=all

        • If connecting to a messaging system:

          *=info:WAS.j2c=all:Messaging=all:JMSApi=all:Transaction=all

        • If connecting to an enterprise information system:

          *=info:WAS.j2c=all:com.ibm.connector2.*=all:Transaction=all

      9. Click OK and save your configuration.


      10. Restart the Application Server.


      11. Reproduce the problem.


      12. Send the resulting trace output file.
    • For releases of V5.1 and V5:
      1. In the Application Server Administrative Console, expand Troubleshooting and select Logs and Trace.

      2. In the Logging and Tracing page, select your server and then Diagnostic Trace.

      3. Ensure that enable trace with the following specification is selected.

      4. In the Trace Specification field, enter the following:
        • If connecting to a database in V5.0:

          WAS.j2c=all=enabled:RRA=all=enabled:WAS.database=all=enabled:
          com.ibm.ejs.jts.*=all=enabled:com.ibm.ws.LocalTransaction.*=all=enabled

        • If connecting to a database in V5.1:

          WAS.j2c=all=enabled:RRA=all=enabled:WAS.database=all=enabled:
          Transaction=all=enabled

        • If connecting to a messaging system in V5.0:

          WAS.j2c=all=enabled:Messaging=all=enabled:JMSApi=all=enabled:
          com.ibm.ejs.jts.*=all=enabled:com.ibm.ws.LocalTransaction.*=all=enabled

        • If connecting to a messaging system in V5.1:

          WAS.j2c=all=enabled:Messaging=all=enabled:JMSApi=all=enabled:
          Transaction=all=enabled

        • If connecting to an enterprise information system in V5.0:

          WAS.j2c=all=enabled:com.ibm.connector2.*=all=enabled:
          com.ibm.ejs.jts.*=all=enabled:com.ibm.ws.LocalTransaction.*=all=enabled

        • If connecting to an enterprise information system in V5.1:

          WAS.j2c=all=enabled:com.ibm.connector2.*=all=enabled:Transaction=all=enabled



          Note:
          If using V4 data source style, please substitute:
          WAS.j2c=all=enabled:RRA=all=enabled
          with
          com.ibm.ejs.cm.*=all=enabled
          from the above trace strings
      5. Under Trace Output, select File, and accept the defaults.

      6. Click OK and save your configuration.

      7. Restart the Application Server.

      8. Reproduce the problem.

      9. Send the resulting trace output file.

  11. 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.

  12. Follow instructions to send diagnostic information to IBM support.

  13. For a listing of all technotes, downloads, and educational materials specific to connection pooling, search the WebSphere Application Server support site.
 
Related information
Submitting information to IBM
Steps for getting support
MustGather: Read first
Troubleshooting guide
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 6.1
Software edition:
Reference #: 1254645
IBM Group: Software Group
Modified date: Jun 24, 2008