We are using IBM System Director 6.2 version. When we hit https://<server-name>:8422/ibm/console URL into the browser, connection is getting timed out & nothing is shown on a page. When we check the the director log, we found following entries into the log:
2012/05/28 08:13:25.152 SEVERE Exception on query: SELECT DCM_OBJECT1.GUID,DCM_OBJECT1.TYPE_ID,DCM_OBJECT1.NAME,DCM_OBJECT1.Id FROM DCM_OBJECT DCM_OBJECT1 WHERE (DCM_OBJECT1.TYPE_ID = ?) ::class.method=com.ibm.sysmgmt.resource.caching.db.DBResourceCachingService.getResourceReferences() ::thread=GroupPollerTimer ::loggername=com.ibm.sysmgmt.resource.caching
org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
Caused by: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: jcc1033510366http://3.59.81 Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003
... 17 more
Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 is the catch line, we think. But when we manually tried to connect to the database using db2 console, we are successfully able to connect to it.
From the abobe errorcode 4470 - it is clear that connection is getting timesout. And from the SQLSTATE - 08003, it is clear that connection does not remain open.
Also after some googling, we found that there is some problem in data conversion between Java & Db2 code.
What is the exact problem, we are unable to make out. Is there a problem at System Director side, so that we should open a PMR to resolve it or there is some other problem?
Yout help will be really helpful on the issue.
Thanks in advance
This topic has been locked.
3 replies Latest Post - 2013-03-30T09:13:51Z by MaheshHajare
Pinned topic Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-30T09:13:51Z at 2013-03-30T09:13:51Z by MaheshHajare
Venkat_GulfSoft 1100005CYS24 PostsACCEPTED ANSWER
Re: Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=080032012-05-29T22:34:20Z in response to MaheshHajareHello,
This is a TCR forum and you will have better chance of getting help by posting in appropriate forum. Having said that, I did a google search as well on this DB2 error and restarting both DB2 and IBM System Director could help. That seems to have resolved similar issues with another IBM product.
with warm regards,
Gulf Breeze Software.
Re: Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=080032012-05-31T05:49:14Z in response to Venkat_GulfSoftThanks Venkat for you reply.
As you mentioned, I restarted the IBM Db2 as well as IBM System Director, still I'm getting the same error.
Re: Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=080032013-03-30T09:13:51Z in response to MaheshHajareI was getting that error during the installation of ISD 6.3 in IDPX environment. I worked with ISD support team to sort out the issue.
The problem was that using root user I was not installing the ISD 6.3. I was using csdpuser to login & after that I was using sudo su command to become a super user.
This was causing the installation of ISD 6.3.
If one try with root user then he'll not face the error that is mentioned on the forum.