We got a database that didn't react for minutes. How can I find out what it
is waiting for. Connection monitor shows several Connections in Compiling
state. So it seems that there is an internal lock which blocks the
compilation.

Thanks
Klemens

db2 get snapshot for locks ...
A transaction probably did not commit and still holding locks on catalog
tables.
There could also be utilities running but with the 'Compiling' hint, it is
less likely.


PM

"Klemens" <klemens.moehlenkamp@maxess.de> a écrit dans le message de news:
bhdhc5$1112fa$1@ID-155009.news.uni-berlin.de...
> We got a database that didn't react for minutes. How can I find out what
it
> is waiting for. Connection monitor shows several Connections in Compiling
> state. So it seems that there is an internal lock which blocks the
> compilation.
>
> Thanks
> Klemens
>
>

What says the db2diag.log during this long time ?

ZEB

Klemens a écrit:
> We got a database that didn't react for minutes. How can I find out what it
> is waiting for. Connection monitor shows several Connections in Compiling
> state. So it seems that there is an internal lock which blocks the
> compilation.
>
> Thanks
> Klemens
>
>

Only things like this, which it says not only in that situation:
---------------------------------------
2003-08-12-22.22.12.191000 Instance:WWS Node:000
PID:2124(db2syscs.exe) TID:2148 Appid:none
common_communication sqlcctcpconnr Probe:103
DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBUF" = "65536" is "accepted".

2003-08-12-22.22.12.191001 Instance:WWS Node:000
PID:2124(db2syscs.exe) TID:2148 Appid:none
common_communication sqlcctcpconnr Probe:108
DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBUF" = "65536" is "accepted".

2003-08-12-22.22.12.972000 Instance:WWS Node:000
PID:2124(db2syscs.exe) TID:1836 Appid:0A01646C.2B07.030812173850
oper_system_services sqloopenp Probe:120 Database:XTRADE

GetLastError: 0200 0000 ....


String Title:Path/Filename PID:2124 Node:000
K:\WWS\NODE0000\SQLDBDIR\SQL00001.BRG
-------------------------------------

Klemens


"zeb" <kariboo1@tiscali.fr> schrieb im Newsbeitrag
news:3F3CCB37.2030301@tiscali.fr...
> What says the db2diag.log during this long time ?
>
> ZEB
>
> Klemens a écrit:
> > We got a database that didn't react for minutes. How can I find out what
it
> > is waiting for. Connection monitor shows several Connections in
Compiling
> > state. So it seems that there is an internal lock which blocks the
> > compilation.
> >
> > Thanks
> > Klemens
> >
> >
>