Hi Florian,
I have WebSphere Platform 5.1
http://BASE 5.1.0.3 cf30412.02 http://JDK 1.4.1 b0344.02 and the log detail level is
com.ibm.ejs.cm.*=all=enabled:WAS.database=all=enabled:Transaction=all=enabled.
I would like to know why I open my
http://trace.log with DB Conn Pool Analyzer nothing is presented.
Here an extract of my
http://trace.log:
16/06/08 16:12:12:633 BRT 4590459 LocalTIDTable > removeLocalTID 145
16/06/08 16:12:12:665 BRT 3b1e3b1e CachedStateme < destroy
16/06/08 16:12:12:665 BRT 4590459 LocalTIDTable < removeLocalTID
16/06/08 16:12:12:665 BRT 3b1e3b1e CachedStateme > destroy
16/06/08 16:12:12:665 BRT 4590459 TransactionSt > reset
16/06/08 16:12:12:665 BRT 4590459 TransactionSt < reset
16/06/08 16:12:12:665 BRT 4590459 TransactionIm < forgetTransaction
16/06/08 16:12:12:665 BRT 4590459 TransactionIm < notifyCompletion
16/06/08 16:12:12:665 BRT 4590459 TransactionIm < commit (SPI)
16/06/08 16:12:12:665 BRT 4590459 TranManagerIm < commit (SPI)
16/06/08 16:12:12:665 BRT 4590459 TranManagerSe < commit
16/06/08 16:12:12:665 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:12:665 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:12:665 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:12:665 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:12:665 BRT 4590459 TranManagerIm > getTransaction (SPI)
16/06/08 16:12:12:665 BRT 4590459 TranManagerIm < getTransaction (SPI)
<null>
16/06/08 16:12:12:680 BRT 3b1e3b1e CachedStateme < destroy
16/06/08 16:12:12:680 BRT 3b1e3b1e StatementCach < destroy
16/06/08 16:12:12:680 BRT 4590459 UserTransacti > getStatus (API)
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm > getStatus (SPI)
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm < getStatus (SPI)
6
16/06/08 16:12:12:680 BRT 4590459 UserTransacti < getStatus (API)
no transaction
16/06/08 16:12:12:680 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:12:680 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:680 BRT 4590459 UserTransacti > getStatus (API)
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm > getStatus (SPI)
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm < getStatus (SPI)
6
16/06/08 16:12:12:680 BRT 4590459 UserTransacti < getStatus (API)
no transaction
16/06/08 16:12:12:680 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:12:680 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:12:680 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:696 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:12:696 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm > getTransaction (SPI)
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm < getTransaction (SPI)
<null>
16/06/08 16:12:12:696 BRT 4590459 UserTransacti > getStatus (API)
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm > getStatus (SPI)
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm < getStatus (SPI)
6
16/06/08 16:12:12:696 BRT 4590459 UserTransacti < getStatus (API)
no transaction
16/06/08 16:12:12:696 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:12:696 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:12:696 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.postInvoke()
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo > connectionDestroyed
com.ibm.ejs.cm.pool.ConnectO@667625419
supports2PC=false, rrsTransactional=false, DESTROYED, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo e Shrinking pool
1
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo < connectionDestroyed
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectO < destroy
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo e Shrinking pool
0
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo < connectionIdleTimeout
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectionPoo < connectionIdleTimeout
16/06/08 16:12:12:696 BRT 3b1e3b1e ConnectO < alarm
16/06/08 16:12:15:227 BRT 4590459 WebAppTransac > WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:15:227 BRT 4590459 TranManagerIm > completeTxTimeout
16/06/08 16:12:15:227 BRT 4590459 TranManagerIm < completeTxTimeout
16/06/08 16:12:15:227 BRT 4590459 WebAppTransac < WebAppTransactionCollaborator.preInvoke()
16/06/08 16:12:15:227 BRT 4590459 TranManagerIm > getTransaction (SPI)
16/06/08 16:12:15:227 BRT 4590459 TranManagerIm < getTransaction (SPI)
<null>
16/06/08 16:12:15:258 BRT 4590459 DataSourceImp > getConnection
sgmuser
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo > allocateConnection
sgmuser
16/06/08 16:12:15:258 BRT 4590459 TranManagerSe > getUOWCoord
16/06/08 16:12:15:258 BRT 4590459 TranManagerIm > getUOWCoord
16/06/08 16:12:15:258 BRT 4590459 LocalTranCurr d getLocalTranCoord: return=null
16/06/08 16:12:15:258 BRT 4590459 TranManagerIm < getUOWCoord
<null>
16/06/08 16:12:15:258 BRT 4590459 TranManagerSe < getUOWCoord
<null>
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo > findConnectionForTx
<null>
sgmuser
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo > findFreeConnection
sgmuser
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo > createOrWaitForConnection
sgmuser
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo e Expanding pool
1
2
16/06/08 16:12:15:258 BRT 4590459 ConnectionPoo > createConnection
sgmuser
16/06/08 16:12:15:696 BRT 4590459 ConnectO > 1 Phase ConnectO Constructor
16/06/08 16:12:15:727 BRT 4590459 ConnectO e Initial settings: isolattionLevel, autoCommit, 2PC, RRSTransactional, user
2
true
false
false
sgmuser
16/06/08 16:12:15:727 BRT 4590459 ConnectO < 1 Phase ConnectO Constructor
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < createConnection
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, FREE, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < createOrWaitForConnection
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, FREE, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < findFreeConnection
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, FREE, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo > allocateConnForTransaction
16/06/08 16:12:15:727 BRT 4590459 ConnectO > allocate
<null>
16/06/08 16:12:15:727 BRT 4590459 ConnectO > enlist
<null>
true
16/06/08 16:12:15:727 BRT 4590459 ConnectO d enlist(): connection enlisted in No Transanaction.
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, ALLOCATED, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:15:727 BRT 4590459 ConnectO > setAutoCommit
true
16/06/08 16:12:15:727 BRT 4590459 ConnectO < setAutoCommit
16/06/08 16:12:15:727 BRT 4590459 ConnectO < allocate
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < allocateConnForTransaction
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < findConnectionForTx
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, ALLOCATED, ENLISTED_IN_NOTRAN, RefCNT=0
16/06/08 16:12:15:727 BRT 4590459 ConnectionPoo < allocateConnection
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, ALLOCATED, ENLISTED_IN_NOTRAN, RefCNT=1
16/06/08 16:12:15:727 BRT 4590459 ConnectionPro > <init>
com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, ALLOCATED, ENLISTED_IN_NOTRAN, RefCNT=1
16/06/08 16:12:15:727 BRT 4590459 ConnectionPro < <init>
16/06/08 16:12:15:727 BRT 4590459 DataSourceImp < getConnection
com.ibm.ejs.cm.proxy.OracleConnectionProxy@1560829192
OPEN
16/06/08 16:12:15:727 BRT 4590459 Proxy > __preInvoke
false
16/06/08 16:12:15:727 BRT 4590459 Proxy d state:
OPEN
16/06/08 16:12:15:727 BRT 4590459 ConnectO > preInvoke: com.ibm.ejs.cm.pool.ConnectO@213847231
supports2PC=false, rrsTransactional=false, ALLOCATED, ENLISTED_IN_NOTRAN, RefCNT=1
false
16/06/08 16:12:15:727 BRT 4590459 ConnectO > incNumInUse()
16/06/08 16:12:15:727 BRT 4590459 ConnectO d incNumInUse: New numInUse=1
16/06/08 16:12:15:727 BRT 4590459 TranManagerSe > getUOWCoord
16/06/08 16:12:15:727 BRT 4590459 TranManagerIm > getUOWCoord
16/06/08 16:12:15:727 BRT 4590459 LocalTranCurr d getLocalTranCoord: return=null
16/06/08 16:12:15:727 BRT 4590459 TranManagerIm < getUOWCoord
<null>
16/06/08 16:12:15:727 BRT 4590459 TranManagerSe < getUOWCoord
<null>
16/06/08 16:12:15:727 BRT 4590459 ConnectO > enlist
<null>
false