Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: DB2 / Websphere Portal

    Env: DB2 V8.2/AIX 5.3

    AIX Box 1(hosts) : IBM Websphere Portal, Portal's DB2 database
    AIX Box 2(hosts) : Application DB2 database (appdb)

    On the Websphere's log, SA sees SQL0911N, Reason code 68(Timeout) error message so everyone says this as application database(appdb) issue but based on my monitoring I'm pretty sure that timeout is not happening at appdb but at the portal's db2 database.

    Problem: I do not have access to Portal's DB2 database to prove it. Also the logfile doesn't say any database name (per my understanding). Is there any other way to show that this is because of portal's database issue.

    Following is the Websphere's log for reference.
    ...
    ...
    ...

    [2/25/09 16:27:48:302 EST] 00000041 StandardQuery I starting query cache at region: org.hibernate.cache.StandardQueryCache
    [2/25/09 16:27:48:304 EST] 00000041 EhCacheProvid W Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
    [2/25/09 16:27:48:486 EST] 00000030 WSMM Message E DBAttributeCache init The following SQL Exception occured during processing: "COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001

    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java(Compiled Code))
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java(Inlined Compiled Code))
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java(Compiled Code))
    at COM.ibm.db2.jdbc.app.DB2ResultSet.next(DB2ResultSe t.java:653)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java(Compiled Code))
    at com.ibm.ws.wmm.db.DBAttributeCache.init(DBAttribut eCache.java:762)
    at com.ibm.ws.wmm.db.DBAttributeCache.initialize(DBAt tributeCache.java:1163)
    at com.ibm.ws.wmm.db.DBAttributeCache.singleton(DBAtt ributeCache.java:1183)
    at com.ibm.ws.wmm.db.DatabaseRepository.initialize(Da tabaseRepository.java:3832)
    at com.ibm.ws.wmm.MemberRepositoryManager.initializeR epositories(MemberRepositoryManager.java:5093)
    at com.ibm.ws.wmm.MemberRepositoryManager.init(Member RepositoryManager.java:4945)
    at com.ibm.ws.wmm.MemberRepositoryManager.singleton(M emberRepositoryManager.java:9549)
    at com.ibm.ws.wmm.MRMWrapper.getMRM(MRMWrapper.java:8 7)
    at com.ibm.ws.wmm.MRMWrapper.singleton(MRMWrapper.jav a:104)
    at com.ibm.websphere.wmm.registry.WMMUserRegistry.get MRMWrapper(WMMUserRegistry.java:520)
    at com.ibm.websphere.wmm.registry.WMMUserRegistry.get GroupsForUser(WMMUserRegistry.java:1791)
    at com.ibm.ws.security.registry.UserRegistryImpl.getG roupsForUser(UserRegistryImpl.java:660)
    at com.ibm.websphere.security._UserRegistry_Stub.getG roupsForUser(_UserRegistry_Stub.java:813)
    at com.ibm.ws.sib.security.auth.AuthUtilsImpl.getGrou psForUser(AuthUtilsImpl.java:258)
    at com.ibm.ws.sib.processor.matching.MPPrincipal.<ini t>(MPPrincipal.java:83)
    at com.ibm.ws.sib.processor.matching.TopicAuthorizati on.checkPermissionToSubscribe(TopicAuthorization.j ava:308)
    at com.ibm.ws.sib.processor.impl.AccessChecker.checkD iscriminatorAccess(AccessChecker.java:355)
    at com.ibm.ws.sib.processor.impl.BaseDestinationHandl er.checkDiscriminatorAccess(BaseDestinationHandler .java:10667)
    at com.ibm.ws.sib.processor.impl.ConnectionImpl.check ConsumerAuthority(ConnectionImpl.java:5573)
    at com.ibm.ws.sib.processor.impl.ConnectionImpl.inter nalCreateConsumerSession(ConnectionImpl.java:1442)
    at com.ibm.ws.sib.processor.impl.ConnectionImpl.creat eConsumerSession(ConnectionImpl.java:4535)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaListener.creat eSession(SibRaListener.java:633)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaListener.<init >(SibRaListener.java:241)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessL istener.<init>(SibRaSingleProcessListener.java:165 )
    at com.ibm.ws.sib.ra.inbound.impl.SibRaMessagingEngin eConnection.createListener(SibRaMessagingEngineCon nection.java:609)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaStaticDestinat ionEndpointActivation.createListener(SibRaStaticDe stinationEndpointActivation.java:719)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaStaticDestinat ionEndpointActivation.createListener(SibRaStaticDe stinationEndpointActivation.java:689)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaStaticDestinat ionEndpointActivation.<init>(SibRaStaticDestinatio nEndpointActivation.java:239)
    at com.ibm.ws.sib.ra.inbound.impl.SibRaResourceAdapte rImpl.endpointActivation(SibRaResourceAdapterImpl. java:321)
    at com.ibm.ejs.j2c.ActivationSpecWrapperImpl.activate Endpoint(ActivationSpecWrapperImpl.java:308)
    at com.ibm.ejs.j2c.RAWrapperImpl.activateEndpoint(RAW rapperImpl.java:937)
    at com.ibm.ejs.j2c.RALifeCycleManagerImpl.activateEnd point(RALifeCycleManagerImpl.java:1375)
    at com.ibm.ejs.container.MessageEndpointFactoryImpl.a ctivateEndpoint(MessageEndpointFactoryImpl.java:25 6)
    at com.ibm.ws.runtime.component.EJBContainerImpl.inst all(EJBContainerImpl.java:2946)
    at com.ibm.ws.runtime.component.EJBContainerImpl.star t(EJBContainerImpl.java:3616)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:1263)
    at com.ibm.ws.runtime.component.DeployedApplicationIm pl.fireDeployedObjectStart(DeployedApplicationImpl .java:1076)
    at com.ibm.ws.runtime.component.DeployedModuleImpl.st art(DeployedModuleImpl.java:547)
    at com.ibm.ws.runtime.component.DeployedApplicationIm pl.start(DeployedApplicationImpl.java:754)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl.st artApplication(ApplicationMgrImpl.java:920)
    at com.ibm.ws.runtime.component.ApplicationMgrImpl$Ap pInitializer.run(ApplicationMgrImpl.java:2105)
    at com.ibm.ws.runtime.component.ComponentImpl$_Asynch Initializer.run(ComponentImpl.java:304)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1475)
    ".
    [2/25/09 16:27:48:491 EST] 00000030 SystemOut O < WMM-UR: getMRMWrapper() EXIT
    [2/25/09 16:27:48:492 EST] 00000030 SystemOut O WMM-UR: WMM initialzation failed, using Direct Access
    [2/25/09 16:27:48:492 EST] 00000030 SystemOut O > WMM-UR-DirectAccess-File: getGroupsForUser ENTRY
    [2/25/09 16:27:48:498 EST] 00000030 SystemOut O < WMM-UR-DirectAccess-File: getGroupsForUser EXIT
    ...
    ...
    ...

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    diaglevel 4 will capture the -911 error. It will show the sql that received the timeout and db name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •