Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2007-03-07T13:09:05Z by SystemAdmin
SystemAdmin
SystemAdmin
2583 Posts
ACCEPTED ANSWER

Pinned topic Connecting to a new DB instance

‏2007-03-07T12:12:34Z |
Hi

I need some help from you in DB migration in WCS2.5.1,

I have WCS installed on RHEL AS 3.0 update 6, which is configured with remote DB2 database (instance db2inst1 with database db2SRV1 on server 50000) and remote IDS 5.1 LDAP,

I am now tryng to connect WCS to another instance (db2inst2) of database (db2SRV2 on server 50001) which is a backup of DB2SRV1, Both of my DB instances are on same machine.

To connect WCS to the copy of database, these are the steps we followed -

1) created a new instance(db2inst2) on remote DB2 machine
2) backup database from db2inst1 and restored it for db2inst2

on client side (WCS mc)

uncataloged node corresponding to 50000
uncataloged database db2srv1

cataloged new node
cataloged database db2srv2

list tables
list db directory

which is showing the WCS tables.

Now do I need to do some additional steps on my WCS side for connecting to new DB instance .. connect to DB in configwizard.. .
as if I start the server after cataloging with new database I am getting exceptions when i start my Portal Server

3/7/07 15:39:57:530 IST 570e213 WebGroup I SRVE0180I: http://WebSphere Portal Server 5.0 [/lwp] http://Servlet.LOG: ServiceManager: NamingService http://com.ibm.wps.services.naming.NamingServiceImpl done.
3/7/07 15:39:57:558 IST 570e213 WebGroup I SRVE0180I: http://WebSphere Portal Server 5.0 [/lwp] http://Servlet.LOG: ServiceManager: DataStoreService http://com.ibm.wps.services.datastore.DataStoreServiceImpl initializing...
3/7/07 15:39:57:830 IST 570e213 ServletInstan E SRVE0100E: Did not realize init() exception thrown by servlet portal: javax.servlet.UnavailableException: Initialization of one or more services failed.
at com.ibm.wps.engine.Servlet.init(Servlet.java:191)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doInit(StrictServletInstance.java:82)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._init(StrictLifecycleServlet.java:147)
at com.ibm.ws.webcontainer.servlet.PreInitializedServletState.init(StrictLifecycleServlet.java:270)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.init(StrictLifecycleServlet.java:113)

3/7/07 15:40:03:050 IST 570e213 ApplicationMg A WSVR0221I: Application started: wps
3/7/07 15:40:03:060 IST 570e213 ApplicationMg A WSVR0200I: Starting application: WPCP_Runtime
3/7/07 15:40:03:089 IST 570e213 EJBContainerI I WSVR0207I: Preparing to start EJB jar: BRBeans.jar
3/7/07 15:40:03:249 IST 570e213 BeanMetaData E CNTR0075E: The user-provided class "<null>" needed by the EnterpriseBean could not be found or loaded.
3/7/07 15:40:03:262 IST 570e213 EJBContainerI E WSVR0209E: Unable to prepare EJB jar BRBeans.jar http://class com.ibm.ws.runtime.component.DeployedModuleImpl, enterprise bean com.ibm.etools.ejb.impl.ContainerManagedEntityImpl(Rule) (reentrant: true) (version: 2.x, abstractSchemaName: null)
java.lang.UnsatisfiedLinkError: xaConnect
at COM.ibm.db2.jdbc.DB2XAConnection.<init>(DB2XAConnection.java:87)
at COM.ibm.db2.jdbc.DB2XADataSource.getXAConnection(DB2XADataSource.java:116)
at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getInstance(PortabilityLayerImpl.java:1012)
at com.ibm.ejs.cm.portability.PortabilityLayerFactory.getPortabilityLayer(PortabilityLayerFactory.java:66)
at com.ibm.ejs.cm.JDBC2PhaseRF.createConnectionFactory(JDBC2PhaseRF.java:58)
at com.ibm.ejs.cm.JDBC2PhaseRF.getSource(JDBC2PhaseRF.java:93)
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:151)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:149)
at com.ibm.ejs.persistence.EJSJDBCPersister.initialize(EJSJDBCPersister.java:438)
at com.ibm.ejs.persistence.EJSJDBCPersister.create(EJSJDBCPersister.java:194)
at com.ibm.ws.cpi.JDBCPersisterFactoryImpl.create(JDBCPersisterFactoryImpl.java:102)
at com.ibm.ejs.c

Attached are the systemout log files.
Updated on 2007-03-07T13:09:05Z at 2007-03-07T13:09:05Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2583 Posts
    ACCEPTED ANSWER

    Re: Connecting to a new DB instance

    ‏2007-03-07T13:09:05Z  in response to SystemAdmin
    Kindy remove/ignore this post from this forum, I am posting this again on WCS forum, if some one has a suggestion, answers to the problem above plz respond there..

    Thanking in advance for all the help..

    Seema