Posted: Fri Mar 31, 2017 1:47 am Post subject: ODBC Connections issue in IIB v10
Newbie
Joined: 31 Mar 2017 Posts: 1
Hi All,
i am experiencing the below database error log in my IIB log from past 4 days.
BIP2348E: Error detected while attempting to obtain a connection to data source 'ESBDB' of type 'ODBC' using userid 'esbproddb'.
BIP2393E: Database error: ODBC return code '-1' from data source 'ESBDB' using ODBC driver manager '/opt/IBM/iib
-10.0.0.4/ie02/lib/libodbcinterface.so'.
BIP2322E: Database error: SQL State '08001'; Native Error Code '-4'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.'.
whenever am doing mqsicvp the connections are fine. finally came to know that there is an enormous increment in database connections at that point of time.
i came to know about the database connections by using the below command
mqsireportproperties BRKR_NAME -e EG_NAME -o ComIbmDatabaseConnectionManger -r
Kindly suggest how to resolve or restrict the highest connections for a particular databaseconnected to broker.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum