DB2 V810 NFM Locking Protocol II - Information Requested.

Tino Manganaro

DB2 V810 NFM Locking Protocol II - Information Requested.
I was hoping someone could point me to documentation on DB2 V810
NFM Locking Protocol II. I like to know if this will help reduce P type
Locks in data sharing environment and what other relief I may get.



Thanks,

Tino Manganaro

System Engineer Development and Support

Mainframe Technologies - TPS



IT Services Americas

DHL

8701 East Hartford Drive
Building A, Cube #206A
Scottsdale, AZ
85255

United States



Phone : (480) 375-7130
Fax: (480) 375-6450

Mobile: (480) 330-2418





www.dhl.com < http://www.dhl.com/ >

[login to unmask email]




The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Chad Walmer

Re: DB2 V810 NFM Locking Protocol II - Information Requested.
(in response to Tino Manganaro)
Two Redbooks describe the changes in detail: DB2 UDB for z/OS Version 8 Performance Topics (Chapter 8.2) and DB2 UDB for z/OS Version 8: Everything you Ever Wanted to Know, ... and More (Chapter 11.1). While you will not see a reduction in the amount of P-locks, you should see a large reduction in the amount of global XES contention as the parent IX L-locks are now remapped to XES S locks rather than X locks (therefore they are compatible with other IX and IS locks without the need to invoke the contention exit.) In addition, propagation of child L-locks is now tied to the page set P-Lock rather than the parent L-Lock which reduces the number of times the contention exit needs to be invoked since the page set P-lock usually lasts for a much longer time than the parent L-lock. So, while the number of child L-lock propagations will probably increase, the number of contentions for the parent L-locks will dramatically decrease (this contention and its resolution can be very costly both in terms of CPU and elapsed time to the application.)

One interesting side effect of this change is the reduction in the performance benefit of binding programs with RELEASE(DEALLOCATE) as compared to those bound with RELEASE(COMMIT).

Chad Walmer

________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Tino Manganaro (DHL US)
Sent: Thursday, December 20, 2007 12:44 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V810 NFM Locking Protocol II - Information Requested.

I was hoping someone could point me to documentation on DB2 V810 NFM Locking Protocol II. I like to know if this will help reduce P type Locks in data sharing environment and what other relief I may get.


Thanks,

Tino Manganaro

System Engineer Development and Support

Mainframe Technologies - TPS



IT Services Americas

DHL

8701 East Hartford Drive
Building A, Cube #206A
Scottsdale, AZ
85255

United States



Phone : (480) 375-7130
Fax: (480) 375-6450

Mobile: (480) 330-2418





www.dhl.com < http://www.dhl.com/ >

[login to unmask email]


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >
________________________________
Disclaimer: This e-mail message is intended only for the personal use of
the recipient(s) named above. If you are not an intended recipient, you
may not review, copy or distribute this message. If you have received this
communication in error, please notify us immediately by e-mail and delete
the original message.

This e-mail expresses views only of the sender, which are not to be
attributed to Rite Aid Corporation and may not be copied or distributed
without this statement.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms