0

Yue Wu (2●2●3) | asked Oct 23 '13, 8:03 a.m. edited Oct 23 '13, 8:07 a.m. Hello there, I didn't see any similar case on JAZZ.net so why i am going to post this topic and asking for a solution, hope anyone interested will solve together. I have installed RRDI 2.0.4 and setup the RRDI' JTS successfully, and also fine with copying the db2 drivers and setting up the RICM and the problem came here, the RIDW. I have input all the fields with correct informations, actually it's as same as the RICM values, but i have encountered an error after clicked the Verify Button: com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory I have enabled the trace log and you may find it below, hope someone would help and i am appreciated with it.  *i am using a db user "db2inst1" to authenticate with the database DW, i have tested the db2set command is able to run on db2inst1 session *General Exception from GUI: CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory'.   Environment Details: RHEL 6.3 WAS/IHS/PLG 8.5.0.2 CLM 4.0.4 RRDI 2.0.4 DB2 10.1 Exception in DEBUG MODE:  10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : RRDIDWDB2Parameters("RRDIDBConnection("DB2", "www.xxx.com", "DW", 50001)") 10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : OS Name: Linux; OS User: wasadmin 10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : validateDB2Param(StringBuilder message) 10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : islocalDBServer() 10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : validateDB2DBSETParams("DB2_SKIPDELETED", "ON", "SE") 10/23/2013 19:04:37,216 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory 10/23/2013 19:04:37,217 DEBUG com.ibm.rational.rrdi.setup.db.common.RRDIDBException : SQL Statement: db2set DB2_SKIPDELETED class com.ibm.rational.rrdi.setup.db.common.RRDIDBException com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2DBSETParams(RRDIDWDB2Parameters.java:603) com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2Param(RRDIDWDB2Parameters.java:165) com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.validateDBParams(RRDIDWStorageAndMemoryValidation.java:1097) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:423) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:718) com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:732) com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176) com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:281) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120) com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133) com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:736) 10/23/2013 19:04:37,217 ERROR com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory at com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2DBSETParams(RRDIDWDB2Parameters.java:603) at com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2Param(RRDIDWDB2Parameters.java:165) at com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.validateDBParams(RRDIDWStorageAndMemoryValidation.java:1097) at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:423) at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:718) at com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222) at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:732) at com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176) at com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:281) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120) at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133) at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:736)

Accepted answer

---

One other answer

---

Register or log in to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.