Page 1 of 1

How to determine long running DB2 threads thru JCL

PostPosted: Fri Sep 08, 2017 4:43 pm
by 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

Re: How to determine long running DB2 threads thru JCL

PostPosted: Fri Sep 08, 2017 5:47 pm
by 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.

Re: How to determine long running DB2 threads thru JCL

PostPosted: Tue Sep 12, 2017 4:44 pm
by Avinash Kumar
Thanks Robert.