ca.portal.admin

Access to Lock Data Used in PMRM?

Discussion created by ca.portal.admin on Mar 9, 2010
Latest reply on Mar 9, 2010 by ca.portal.admin
Hi, =20

I have been looking at a bunch of DEADLOCK and STALL issues in some CAS
code. =20
=20
I have a couple programs that are stalling quite often. One in
partiuclar appears,based on the last command displayed in the Log (using
ADS TRACE), that the next command that SHOULD be executed is a OBTAIN
OWNER - which SHOULD get the PURCHASE-ORDER (owner of an activity
junction record). =20
I am assuming that another program is locking the record (and it seems
like this data stays locked for quite a long time - stalls leading to
aborts)=20

They do not have PMRM which I would think would help identify what
program might be holding onto the record the stall program is not
getting (the example below is from a presentation on dealing with
Deadlocks.)=20
Is there some other way to see this data (which programs are holding a
lock) - be it the Network (IDMSNWKA) or some kind of journal report?=20
=20
From a presentation on Deadlocks: (My apologies to the author for not
knowing who wrote it)
PMRM - Active User Task Detail
PM-R16.0 TECHDC99 Computer Associates Intl. V545 04.112
CMD--> 02 Active User Task Detail
Task Task Current Waited_On Dbkey
Number Code Program Dbkey Holder
109414 ADS2 DBCRUPD 680037: 13 VL500006
109887 ADS2 DBCRUPD 680021: 13 VL500035
109923 ADS2 DBCRUPD 680022: 1 VL500025
109917 ADS2 DBCRUPD 680039: 13 VL500003
109797 ADS2 DBCRUPD 680019: 11 VL500018
109700 ADS2 DBCRUPD
109827 ADS2 DBCRUPD 680047: 1 VL500024
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Access to Lock Data Used in PMRM?
"I don't know how this will look on IDMS-L.
It's a standard 132 byte report from SMF data via Perfmon, a
custom-written report just using wait records (like PMARPT36, but just
for DBKEY Waits)

REPORT NO. 89 LISTDBKW - TASK
DBKEY WAITS 03/09/10 PAGE 1
CV DATE TIME WAIT PROGRAM TASK GRP PAGE LINE
AREA TYPE HOLD1 HOLD2 3

20 03/08 00:00 00000.2170 OPS-D186 3590594 030 04439390 0015
OPERDB.OPER-AREA-SGEN8 NL IMPD021A 03590694 T
20 03/08 00:00 00000.0163 OPS-D186 3590594 030 04439390 0015
OPERDB.OPER-AREA-SGEN8 NL EDI-D991 03590734 T
20 03/08 00:01 00000.0090 OPS-D102 3594312 030 03939641 0004
OPERDB.OPER-AREA-SGEN28 NL EDI-D991 03594319 T
20 03/08 00:01 00000.0063 OPS-D104 3594678 030 05907089 0036
OPERDB.OPER-AREA-SGEN X COS-D020 03594668 T
20 03/08 00:01 00000.0046 IMPD021A 3597729 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T
20 03/08 00:01 00000.0029 IMPD021A 3597729 030 05834991 0073
OPERDB.OPER-AREA-SGEN S IMPC0010 03597358 T
20 03/08 00:01 00000.3538 IMPD021A 3597773 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T
20 03/08 00:01 00000.0049 IMPD021A 3597773 030 06004232 0045
OPERDB.OPER-AREA-SGEN S IMPC0010 03597358 T
20 03/08 00:02 00000.1964 IMPD150A 3597788 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T

Just to show you what ""autopsy"" type data is out there. . .
Regards,
dem

Outcomes