Application hanging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

situ - 18 May 2006 08:06 GMT

i have one procedure which contains lots of logics in it. (which is one
of the largest procedure in my application)

i have 5 application(or agent) which access this procedure.
when i am accessing a particular code in it all the applications
connected to it hangs.
ultimately it leads to the restarting of the db2 server.

i even tried putting some part of the code in to a new procedure but in
vain.
can anybody help me how to improve performance

Reply to this Message

Serge Rielau - 18 May 2006 08:37 GMT

> i have one procedure which contains lots of logics in it. (which is one
> of the largest procedure in my application)
[quoted text clipped - 7 lines]
> vain.
> can anybody help me how to improve performance

Which platform and version are you on?
My first guess would be that you either have some SQL which runs forever
or you have a dead-lock.
Take a look at SNAPSHOTs or the db2pd tool to analyze.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

situ - 18 May 2006 08:48 GMT

i am working in windows xp platform
and i am using DB2 V8.1.7.445

Reply to this Message

situ - 18 May 2006 09:07 GMT

hello serge,
which parameter i have to take in to consideration in get snapshot
statement
when i say list application its showing 40 applications running on the
database

Reply to this Message