Where are the "missing" P_LOCKS?

Jose de Bedos

Where are the "missing" P_LOCKS?

Hi list,

This is in a 4-way Data Sharing in V9.
In System Statistics , I add P_LOCKS (A)
and consider P_LOCKS registrated in GBP (B).
The "missing" P_LOCKS (A > B) are the Row level locks?


I can't find where did they go !



(A)

DATA SHARING LOCKING QUANTITY


--------------------------- --------

GLOBAL CONTENTION RATE (%) 1.30


P/L-LOCKS XES RATE (%) 1.48





LOCK REQUESTS (P-LOCKS) 18272.8K


UNLOCK REQUESTS (P-LOCKS) 17078.4K

CHANGE REQUESTS (P-LOCKS) 77437.00




SYNCH.XES - LOCK REQUESTS 6563.7K

SYNCH.XES - CHANGE REQUESTS 244.8K

SYNCH.XES - UNLOCK REQUESTS 72897.9K

ASYNCH.XES - RESOURCES 6236.00





SUSPENDS - IRLM GLOBAL CONT 599.9K

SUSPENDS - XES GLOBAL CONT. 23544.00

SUSPENDS - FALSE CONTENTION 422.8K

INCOMPATIBLE RETAINED LOCK 0.00





NOTIFY MESSAGES SENT 200.0K


NOTIFY MESSAGES RECEIVED 498.4K


P-LOCK/NOTIFY EXITS ENGINES 2000.00

P-LCK/NFY EX.ENGINE UNAVAIL 0.00


PSET/PART P-LCK NEGOTIATION 129.7K

PAGE P-LOCK NEGOTIATION 382.3K


OTHER P-LOCK NEGOTIATION 55834.00

P-LOCK CHANGE DURING NEG. 532.2K






(B)



PAGE P-LOCK LOCK REQ 13977.1K

SPACE MAP PAGES 3944.2K


DATA PAGES 576.9K


INDEX LEAF PAGES 9456.0K





PAGE P-LOCK UNLOCK REQ 16347.8K




PAGE P-LOCK LOCK SUSP 13827.1K

SPACE MAP PAGES 3837.0K


DATA PAGES 573.5K


INDEX LEAF PAGES 9416.6K





PAGE P-LOCK LOCK NEG 382.3K

SPACE MAP PAGES 365.2K


DATA PAGES 447.00


INDEX LEAF PAGES 16643.00


Thanks a lot,

Jose











_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

[login to unmask email]

Re: Where are the "missing" P_LOCKS?
(in response to Jose de Bedos)
Jose,

What is missing in your comparison, is "non-page" P_LOCK, or
page set/partition P_LOCK. And Row Level Lock is just one of
the three typical users of page P_LOCK.





Jose de Bedos <[login to unmask email]>
·¢¼þÈË: IDUG DB2-L <[login to unmask email]>
2010-11-13 03:39
Çë´ð¸´ ¸ø
IDUG DB2-L <[login to unmask email]>


ÊÕ¼þÈË
[login to unmask email]
³­ËÍ

Ö÷Ìâ
[DB2-L] Where are the "missing" P_LOCKS?






Hi list,

This is in a 4-way Data Sharing in V9.
In System Statistics , I add P_LOCKS (A) and consider P_LOCKS registrated
in GBP (B).
The "missing" P_LOCKS (A > B) are the Row level locks?

I can't find where did they go !

(A)
DATA SHARING LOCKING QUANTITY
--------------------------- --------
GLOBAL CONTENTION RATE (%) 1.30
P/L-LOCKS XES RATE (%) 1.48

LOCK REQUESTS (P-LOCKS) 18272.8K
UNLOCK REQUESTS (P-LOCKS) 17078.4K
CHANGE REQUESTS (P-LOCKS) 77437.00

SYNCH.XES - LOCK REQUESTS 6563.7K
SYNCH.XES - CHANGE REQUESTS 244.8K
SYNCH.XES - UNLOCK REQUESTS 72897.9K
ASYNCH.XES - RESOURCES 6236.00

SUSPENDS - IRLM GLOBAL CONT 599.9K
SUSPENDS - XES GLOBAL CONT. 23544.00
SUSPENDS - FALSE CONTENTION 422.8K
INCOMPATIBLE RETAINED LOCK 0.00

NOTIFY MESSAGES SENT 200.0K
NOTIFY MESSAGES RECEIVED 498.4K
P-LOCK/NOTIFY EXITS ENGINES 2000.00
P-LCK/NFY EX.ENGINE UNAVAIL 0.00
PSET/PART P-LCK NEGOTIATION 129.7K
PAGE P-LOCK NEGOTIATION 382.3K
OTHER P-LOCK NEGOTIATION 55834.00
P-LOCK CHANGE DURING NEG. 532.2K


(B)

PAGE P-LOCK LOCK REQ 13977.1K
SPACE MAP PAGES 3944.2K
DATA PAGES 576.9K
INDEX LEAF PAGES 9456.0K

PAGE P-LOCK UNLOCK REQ 16347.8K

PAGE P-LOCK LOCK SUSP 13827.1K
SPACE MAP PAGES 3837.0K
DATA PAGES 573.5K
INDEX LEAF PAGES 9416.6K

PAGE P-LOCK LOCK NEG 382.3K
SPACE MAP PAGES 365.2K
DATA PAGES 447.00
INDEX LEAF PAGES 16643.00

Thanks a lot,
Jose







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv