Runaway Websphere DDF Threads

Mick Graley

Runaway Websphere DDF Threads
Hi All,
Occasionally we get looping websphere threads which clock up a lot of
resource until they are discovered and cancelled.
The application is supported offshore by another company so the chances of
them fixing this at their end are nil.
I was hoping to use RLF to kill these threads but I believe RLF only works
at the statement level rather than the thread level.
Any ideas as to how we could automatically detect and cancel these threads?
We have CA-Insight for DB2 as the performance monitor.
Cheers,
Mick.

Chris Tee

Runaway Websphere DDF Threads
(in response to Mick Graley)
Mick


Couldn't you set up a profile in CA Thread Terminator to detect and cancel the threads?


regards


Chris


________________________________
From: Mick Graley <[login to unmask email]>
Sent: 11 January 2017 15:12
To: [login to unmask email]
Subject: [DB2-L] - Runaway Websphere DDF Threads

Hi All,
Occasionally we get looping websphere threads which clock up a lot of resource until they are discovered and cancelled.
The application is supported offshore by another company so the chances of them fixing this at their end are nil.
I was hoping to use RLF to kill these threads but I believe RLF only works at the statement level rather than the thread level.
Any ideas as to how we could automatically detect and cancel these threads?
We have CA-Insight for DB2 as the performance monitor.
Cheers,
Mick.


-----End Original Message-----

Steen Rasmussen

Runaway Websphere DDF Threads
(in response to Mick Graley)
Mick,
You can create an IQL Exception definition in Insight that invokes a PTT CANCEL command if the threshold is exceeded.

Steen

From: Mick Graley [mailto:[login to unmask email]
Sent: Wednesday, January 11, 2017 9:12 AM
To: [login to unmask email]
Subject: [DB2-L] - Runaway Websphere DDF Threads

Hi All,
Occasionally we get looping websphere threads which clock up a lot of resource until they are discovered and cancelled.
The application is supported offshore by another company so the chances of them fixing this at their end are nil.
I was hoping to use RLF to kill these threads but I believe RLF only works at the statement level rather than the thread level.
Any ideas as to how we could automatically detect and cancel these threads?
We have CA-Insight for DB2 as the performance monitor.
Cheers,
Mick.


-----End Original Message-----

Denis Tronin

RE: Runaway Websphere DDF Threads
(in response to Mick Graley)

Mike,

The easiest way to address this is to create an IQL exception and associate it with the CANCEL action. If you come across any difficulties with creating and setting it up, feel free to reach out to me directly or by opening CA support ticket.

Also you can also probably do some tricks with DB2 profiles - but I have not touched those for a while..

Thank you,
Denis Tronin
CA SYSVIEW for DB2 (Insight) product owner

Mick Graley

Runaway Websphere DDF Threads
(in response to Denis Tronin)
Thanks for the answers Chris, Steen and Denis.
Any pointers to the relevant doc or info on how to set this up would be
very welcome.
BTW, Denis I couldn't work out your email address from my gmail web client.
My email address is mick.graley with some character that used to be used to
show rates followed by gmail.com if you want to give me yours.
Cheers,
Mick.


On 12 January 2017 at 08:34, Denis Tronin <[login to unmask email]> wrote:

> Mike,
>
> The easiest way to address this is to create an IQL exception and
> associate it with the CANCEL action. If you come across any difficulties
> with creating and setting it up, feel free to reach out to me directly or
> by opening CA support ticket.
>
> Also you can also probably do some tricks with DB2 profiles - but I have
> not touched those for a while..
>
> Thank you,
> Denis Tronin
> CA SYSVIEW for DB2 (Insight) product owner
>
> -----End Original Message-----
>

Steen Rasmussen

Runaway Websphere DDF Threads
(in response to Mick Graley)
Mick, [login to unmask email]<mailto:[login to unmask email]> will do it.

Steen Rasmussen

From: Mick Graley [mailto:[login to unmask email]
Sent: Friday, January 13, 2017 9:21 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Runaway Websphere DDF Threads

Thanks for the answers Chris, Steen and Denis.
Any pointers to the relevant doc or info on how to set this up would be very welcome.
BTW, Denis I couldn't work out your email address from my gmail web client. My email address is mick.graley with some character that used to be used to show rates followed by gmail.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__gmail.com&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=34Shipm6uNvEgyLD0GDLYRAldd7Bhg9eGHGG1-X0jZI&s=cUY4q9l02LdAPCzDk1ddhOkyEWklLQswQMudfR6Iq8M&e=> if you want to give me yours.
Cheers,
Mick.


On 12 January 2017 at 08:34, Denis Tronin <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Mike,

The easiest way to address this is to create an IQL exception and associate it with the CANCEL action. If you come across any difficulties with creating and setting it up, feel free to reach out to me directly or by opening CA support ticket.

Also you can also probably do some tricks with DB2 profiles - but I have not touched those for a while..

Thank you,
Denis Tronin
CA SYSVIEW for DB2 (Insight) product owner

-----End Original Message-----

Mick Graley

Runaway Websphere DDF Threads
(in response to Steen Rasmussen)
Thanks Steen.
Mick.

On 13 January 2017 at 15:24, Rasmussen, Steen <[login to unmask email]> wrote:

> Mick, [login to unmask email] will do it.
>
>
>
> Steen Rasmussen
>
>
>
> *From:* Mick Graley [mailto:[login to unmask email]
> *Sent:* Friday, January 13, 2017 9:21 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: Runaway Websphere DDF Threads
>
>
>
> Thanks for the answers Chris, Steen and Denis.
>
> Any pointers to the relevant doc or info on how to set this up would be
> very welcome.
>
> BTW, Denis I couldn't work out your email address from my gmail web
> client. My email address is mick.graley with some character that used to be
> used to show rates followed by gmail.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__gmail.com&d=DwMFaQ&c=_hRq4mqlUmqpqlyQ5hkoDXIVh6I6pxfkkNxQuL0p-Z0&r=8G_DmW0CTa1-mRqqCc2bPPrkruU7frF_6CmvV0GqNtc&m=34Shipm6uNvEgyLD0GDLYRAldd7Bhg9eGHGG1-X0jZI&s=cUY4q9l02LdAPCzDk1ddhOkyEWklLQswQMudfR6Iq8M&e=>
> if you want to give me yours.
>
> Cheers,
>
> Mick.
>
>
>
>
>
> On 12 January 2017 at 08:34, Denis Tronin <[login to unmask email]> wrote:
>
> Mike,
>
> The easiest way to address this is to create an IQL exception and
> associate it with the CANCEL action. If you come across any difficulties
> with creating and setting it up, feel free to reach out to me directly or
> by opening CA support ticket.
>
> Also you can also probably do some tricks with DB2 profiles - but I have
> not touched those for a while..
>
> Thank you,
> Denis Tronin
> CA SYSVIEW for DB2 (Insight) product owner
>
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>