How to determine long running DB2 threads thru JCL



IBM's flagship relational database management system

How to determine long running DB2 threads thru JCL

Postby Avinash Kumar » Fri Sep 08, 2017 4:43 pm

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
You do not have the required permissions to view the files attached to this post.
Avinash Kumar
 
Posts: 2
Joined: Fri Sep 08, 2017 4:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to determine long running DB2 threads thru JCL

Postby Robert Sample » Fri Sep 08, 2017 5:47 pm

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.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: How to determine long running DB2 threads thru JCL

Postby Avinash Kumar » Tue Sep 12, 2017 4:44 pm

Thanks Robert.
Avinash Kumar
 
Posts: 2
Joined: Fri Sep 08, 2017 4:25 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post