How to determine long running DB2 threads thru JCL

[Avinash Kumar]

Hi Team,

I searched for this and did not find much info. Please help me on this.

We have cobol DB2 stored procedures and gets invoked thru front end java application. Some times there is a deadlock with one table and all the remaining threads are waiting on this which causes the application to slow down. I'm planning to automate this.

I need your help to Identify the long running threads in DB2 thru JCL. ex: If the thread is running more than 30 mins. I have attached screen print for the issue which we are facing.


Thanks,
Avinash

[Robert Sample]

I need your help to Identify the long running threads in DB2 thru JCL

This cannot be done, period. JCL is used to allocate resources and execute batch programs. JCL cannot be used to do anything else.

Furthermore, if your site has a monitor such as OMEGAMON or MAINVIEW, use the monitor since this is the kind of thing they are written to handle.

[Avinash Kumar]

Thanks Robert.