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
.com/support/docview.wss?uid=swg1PM54608
>
>
>-Original Message-
>From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
>Behalf Of Peter Hunkeler
>Sent: Monday, February 06, 2017 12:47 PM
>To: IBM-MAIN@LISTSERV.UA.EDU
>Subject: DB2 Locks and WLM Blo
Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Peter Hunkeler
Sent: Monday, February 06, 2017 12:47 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2 Locks and WLM Blocked Workload Support?
Cross-posted from DB2-L
DB2 is not my strength, so please bear with me.
I
Cross-posted from DB2-L
DB2 is not my strength, so please bear with me.
I understand that DB2 serializes access to its resources with various types of
locks. For access to data, some of them are row locks, page locks, tablespace
locks.
WLM's "blocked workload support" can help to reduce re