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:
>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 /
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
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
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
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