IBM Support

IV64035: LDAPDependencyAgent database connection leak.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The LDAPDependency topology builder agent at times can
experience a connection leak. When this occurs, the following
error appears for DB2 users;


2014-08-25 10:05:38,821 TopologyBuilder [pool-1-thread-1]  WARN
util.ConnectionProxyHandler - CTJOT0857W Database is
unavailable. Retry
connecting to database in 1 seconds. Retry number 5/5
2014-08-25 10:05:39,825 TopologyBuilder [pool-1-thread-1]  DEBUG
util.ConnectionProxyHandler - handleSQLException
2014-08-25 10:05:39,825 TopologyBuilder [pool-1-thread-1]  ERROR
util.ConnectionProxyHandler - CTJOT0858E Fatal Error : Could not
connect
to the database.
2014-08-25 10:05:39,842 TopologyBuilder [pool-1-thread-1]  ERROR
util.JdbcConnectionFactory - [JdbcConnectionFactory.E.1] An
error
occurred, could not connect to the
jdbc:db2://10.93.15.29:60010/td
mtadd1:deferPrepares=false;, taddmlin databases.
com.ibm.cdb.topomgr.util.DatabaseConnectionException: CTJOT0858E
Fatal
Error : Could not connect to the database.


Additionally if you check the dist/log/agents log for this
agent, you will see that it is trying to create 1000's
of connections. For example;

grep "create a new connection" LDAPDependencyAgent.log* | wc -l

4625

Local fix

  • NA

Problem summary

  • The LDAPDependency topology builder agent at times can
experience a connection leak. When this occurs, the following
error appears for DB2 users;


2014-08-25 10:05:38,821 TopologyBuilder ípool-1-thread-1ù  WARN
util.ConnectionProxyHandler - CTJOT0857W Database is
unavailable. Retry
connecting to database in 1 seconds. Retry number 5/5
2014-08-25 10:05:39,825 TopologyBuilder ípool-1-thread-1ù  DEBUG
util.ConnectionProxyHandler - handleSQLException
2014-08-25 10:05:39,825 TopologyBuilder ípool-1-thread-1ù  ERROR
util.ConnectionProxyHandler - CTJOT0858E Fatal Error : Could not
connect
to the database.
2014-08-25 10:05:39,842 TopologyBuilder ípool-1-thread-1ù  ERROR
util.JdbcConnectionFactory - íJdbcConnectionFactory.E.1ù An
error
occurred, could not connect to the
jdbc:db2://1.1.2.34:60010/td
mtadd1:deferPrepares=false;, taddmlin databases.
com.ibm.cdb.topomgr.util.DatabaseConnectionException: CTJOT0858E
Fatal
Error : Could not connect to the database.

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
packages:
| Fix Pack | 7.2.2-TIV-ITADDM-FP0003
Check the IBM Software Support web site for availability of the
above maintenance packages.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IV64035
    • 

  • Reported component name
    APP DEPENDENCY
    • 

  • Reported component ID
    5724N5500
    • 

  • Reported release
    722
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-08-27
    • 

  • Closed date
    2014-10-20
    • 

  • Last modified date
    2014-10-20
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    APP DEPENDENCY
    • 

  • Fixed component ID
    5724N5500
    • 



Applicable component levels


    

  • R722  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSPLFC","label":"Tivoli Application Dependency Discovery Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"722","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            20 October 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback