IBM DB2 client problem

[Database Administrator]

I am having some problems with the IBM DB2 client for Windows. When I first installed the IBM DB2 client, the Client Configuration Assistant had the Database Aliases of DWCTRLDB and SATCTLDB. I then imported two configurations for my application that I exported from another machine's Client Configuration Assistant.

When I imported the configurations, the DWCTRLDB disappeared. On my other machine, DWCTRLDB is there. And the configurations I exported were originally created on that other machine(they were not imported). Which leads me to believe that there is something wrong with the import utility in the Client Configuration Assistant.

I have tried to export the DWCTRLDB from the working other machine, and import it onto the non-working machine but it doesn't work. It doesn't even show up! I tried to create the DWCTRLDB from scratch, matching the attribute with the working other machine. Still doesn't work.

I use WSAD to connect to DB2. So when i try to run a stored procedure, I get:

[11/2/07 12:47:24:187 EST] 402b402b J2CXAResource E J2CA0036E: An exception occurred while invoking method setDataSourceProperties on com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl used by resource DSNT : java.lang.reflect.InvocationTargetException
Caused by: com.ibm.ws.exception.WsException: DSRA0023E: The DataSource implementation class "COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource" could not be found.
at java.lang.Throwable.(Throwable.java)
at java.lang.Throwable.(Throwable.java)
at com.ibm.ws.exception.WsException.(WsException.java:106)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.(DataStoreAdapterException.java:244)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.(DataStoreAdapterException.java:171)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAd apterException(AdapterUtil.java:208)
at com.ibm.ws.rsadapter.DSConfigurationHelper.createD ataSource(DSConfigurationHelper.java:557)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource$1.run(WSR dbDataSource.java:784)
at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:111)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.createNew DataSource(WSRdbDataSource.java:780)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.(WSRdbDataSource.java:389)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactor yImpl.setDataSourceProperties(WSManagedConnectionF actoryImpl.java:895)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java)
at java.lang.reflect.Method.invoke(Method.java)
at com.ibm.ejs.j2c.J2CXAResourceFactory.createMCFEntr y(J2CXAResourceFactory.java:371)
at com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl.creat eMCFandPM(ConnectionFactoryBuilderImpl.java:1414)
at com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl.getOb jectInstance(ConnectionFactoryBuilderImpl.java:120 1)
at javax.naming.spi.NamingManager.getObjectInstance(N amingManager.java:313)
at com.ibm.ws.naming.util.Helpers.processSerializedOb jectForLookupExt(Helpers.java:873)
at com.ibm.ws.naming.util.Helpers.processSerializedOb jectForLookup(Helpers.java:680)
at com.ibm.ws.naming.jndicos.CNContextImpl.processRes olveResults(CNContextImpl.java:1712)
at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(C NContextImpl.java:1567)
at com.ibm.ws.naming.jndicos.CNContextImpl.doLookup(C NContextImpl.java:1480)
at com.ibm.ws.naming.jndicos.CNContextImpl.lookupExt( CNContextImpl.java:1187)
at com.ibm.ws.naming.jndicos.CNContextImpl.lookup(CNC ontextImpl.java:1067)
at com.ibm.ws.naming.util.WsnInitCtx.lookup(WsnInitCt x.java:132)
at javax.naming.InitialContext.lookup(InitialContext. java:360)
at com.pwj.fwa.jdbcmanager.PwConnPoolingJdbcConnectio n.createDataSource(PwConnPoolingJdbcConnection.jav a:104)
at com.pwj.fwa.jdbcmanager.PwConnPoolingJdbcConnectio n.getDataSource(PwConnPoolingJdbcConnection.java:1 16)
at com.pwj.fwa.jdbcmanager.PwConnPoolingJdbcConnectio n.createConnection(PwConnPoolingJdbcConnection.jav a:86)
at com.pwj.fwa.jdbcmanager.PwConnPoolingJdbcConnectio n.(PwConnPoolingJdbcConnection.java:32)
at com.pwj.fwa.jdbcmanager.PwJdbcConnection.getPwJdbc Connection(PwJdbcConnection.java:207)
at com.pwj.fwa.conman.GatewayConnection.getConnection (GatewayConnection.java:332)
at com.pwj.fwa.conman.GatewayConnection.(GatewayConnection.java:60)
at com.pwj.tools.DB2Classes.DB2.DBConnection.openConn ection(DBConnection.java:57)
at com.pwj.crdb.services.client.ClientEmailDataAccess .Execute(ClientEmailDataAccess.java:104)
at com.pwj.crdb.services.client.ClientEmailManager.fe tchEmail(ClientEmailManager.java:38)
at com.pwj.crdb.services.client.TelephonesClientInfoC ICS.lookupShort(TelephonesClientInfoCICS.java:1448 )
at com.pwj.crdb.services.client.ClientCICS.performLoo kupShort(ClientCICS.java:7658)
at com.pwj.crdb.services.client.ClientCICS.performLoo kupShort(ClientCICS.java:6870)
at com.pwj.crdb.services.client.ClientCICS.lookup(Cli entCICS.java:307)
at com.pwj.crdb.services.client.ClientManager.lookupC lient(ClientManager.java:410)
at com.pwj.crdb.web.client.ClientUtilities.getClient( ClientUtilities.java:176)
at com.pwj.crdb.web.client.ViewClientAction.doAction( ViewClientAction.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java)
at java.lang.reflect.Method.invoke(Method.java)
at com.pwj.crdb.web.CRDBControllerServlet.service(CRD BControllerServlet.java:523)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:974)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:555)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.Cacheable InvocationContext.invoke(CacheableInvocationContex t.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava)


If anyone knows how to fix this, please let me know. I would greatly appreciate it.