|
Home > Archive > WebSphere Application Server > September 2006 > How to identify DB2 application ID from Websphere connection?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to identify DB2 application ID from Websphere connection?
|
|
|
| One of our customer has a web portal running WAS and DB2. Certain applications running on WAS sometimes hang due to database connections no response. The reason that DB2 makes no response is identified that lock/deadlock and long-transaction would be the
causes.
In fact, what they really want to know is the application ID mapping from WAS to DB2. Once a problem occurs on WAS, they?d like immediately to trace the application by identifying which DB2 application ID is the corresponding agent. Unfortunately, the con
nections from WAS to DB2 are a pool. There is no way to trace which WAS application ID that the corresponding application ID on DB2 is mapping to.
Any solution? Thanks a lot.
| |
| watcher 2006-04-02, 8:04 pm |
| The uid/password for database authentication is stored in J2C Authentication
Data Entry. If the application does not pass UID/Password to
getConnection(), it will use the ID/pwd specified in the J2C data entry. You
should be able to check that out.
<linv@tw.ibm.com> wrote in message
news:494102612.1143535096843.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
> One of our customer has a web portal running WAS and DB2. Certain
> applications running on WAS sometimes hang due to database connections no
> response. The reason that DB2 makes no response is identified that
> lock/deadlock and long-transaction would be the causes.
> In fact, what they really want to know is the application ID mapping from
> WAS to DB2. Once a problem occurs on WAS, they?d like immediately to trace
> the application by identifying which DB2 application ID is the
> corresponding agent. Unfortunately, the connections from WAS to DB2 are a
> pool. There is no way to trace which WAS application ID that the
> corresponding application ID on DB2 is mapping to.
>
> Any solution? Thanks a lot.
>
| |
| Charly Oz 2006-09-24, 7:46 pm |
| To extend the previous response, if you are using a single datasource, and
your container is passing on the authentication details, (one config in the
same vm) then you may need to use separate datasources (with separate J2C
Auth Aliases) to be able to track down, on the DB2 end, which user, and
therefore which application, opened the connection to DB2.
Hope this helps.
Charly.
"watcher" <redloft2003@yahoo.com> wrote in message
news:e0bni3$v83c$1@news.boulder.ibm.com...
> The uid/password for database authentication is stored in J2C
> Authentication Data Entry. If the application does not pass UID/Password
> to getConnection(), it will use the ID/pwd specified in the J2C data
> entry. You should be able to check that out.
>
>
> <linv@tw.ibm.com> wrote in message
> news:494102612.1143535096843.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
>
>
|
|
|
|
|