AW: Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread Peter Hunkeler
Excellent! Exactly the information I was looking for. Thank you, Horst and Greg. -- Peter Hunkeler -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message:

AW: Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread Peter Hunkeler
>If you have not done so, you might also want to post to the DB2 List who may >have more experience. First line of my post gives you the answer ;-) >>Cross-posted from DB2-L -- Peter Hunkeler -- For IBM-MAIN subscribe /

Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread Horst Sinram
Peter, DB2 has the most comprehensive support to interact with WLM to address contention. DB2 will try to notify WLM about resource contention to extent it knows about dependencies. Based on such notifications DB2 and WLM support - Regular "enqueue promotion" and short term promotion . Both pro

Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread Greg Dyck
On 2/6/2017 11:46 AM, Peter Hunkeler wrote: - Are the "DB2 latches" implemented as GRS latches? - Are row, page, tables space locks actually DB2 latches? In other words, would WLM be able to recognize a low priority job holding some DB2 locks is causeing delay so it can promote it? - What have

Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread Lizette Koehler
Subject: Re: DB2 Locks and WLM Blocked Workload Support? > >Quick search yielded the following, which might help with some of your >questions: >https://www.toadworld.com/platforms/ibmdb2/b/weblog/archive/2013/04/22/db2-locking-part-3-locks-versus-latches >and >http://www-01.ibm

Re: DB2 Locks and WLM Blocked Workload Support?

2017-02-06 Thread van der Grijn, Bart (B)
Quick search yielded the following, which might help with some of your questions: https://www.toadworld.com/platforms/ibmdb2/b/weblog/archive/2013/04/22/db2-locking-part-3-locks-versus-latches and http://www-01.ibm.com/support/docview.wss?uid=swg1PM54608 -Original Message- From: IBM Mai