ca.portal.admin

Re:Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?

Discussion created by ca.portal.admin on Mar 9, 2010
hen perhaps the real question becomes:=20 =20 does Ms Kline need this
nformation real time as it happens, or can=20 daily reports suffice=20 =20
f the latter, then certainly the log can be interrogated and all=20
ecessary information can be retrieved=20 if the former - good luck - even
f you sat all day executing lockmon=20 you MIGHT see stalls building, but
any deadlocks could come and go=20 between two hits of the ENTER key=20 =20
hris=20

The information transmitted is intended only for the person or entity to
hich it is addressed and may contain CONFIDENTIAL material. If you receive
his material/information in error, please contact the sender and delete or
estroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Access to Lock Data Used in PMRM?
"Cynthia,

What release are you running? R17 gives you lots of information on the log=
about these types of abends. I thought that we had these messages at R16 =
as well, but don't remember for sure.

In the first example below (a deadlock), program D472OJ06 abended due to a =
lock held by program D472OJ04.

In the second example (a stall), program D479HC01 abended due to a lock hel=
d by program D479HG01.

The codes following ""R:LTXNLOCK"" are interpreted as Dan Miley explained in =
his earlier note.

------------------------------
DC001000 V26 T15 T:000265316 AP472O10 P:D472OJ04 C:DEAD WAITING ON R:LTXNLO=
CK 03F22008 00017B49
DC001000 V26 T15 T:000265317 AP472O10 P:D472OJ06 C:DEAD WAITING ON R:LTXNLO=
CK 03F22008 00017B48
DC001002 V26 T15 T:000265317 AP472O10 P:D472OJ06 C:DEAD DEADLOCKED ON R:LTX=
NLOCK 03F22008 00017B48

------------------------------
DC001007 V24 T1057384 TASK:AP479H01 PROG:D479HC01 WAITING FOR LTXNLOCK 03E9=
0008 778E5301
DC001008 V24 T1057384 TXNID:48566301 PROG:D479HC01 SUBSCHEMA:A479HU00 MODE:=
X
DC001009 V24 T1057384 TSKID:1057387 TASK:AP479H01 PROG:D479HG01 HOLDS LTXNL=
OCK 03E90008 778E5301
DC001010 V24 T1057384 TXNID:48566303 PROG:D479HG01 SUBSCHEMA:A479HR00 MODE:=
S
DC001003 V24 T1057384 TASK:ADS2 PROG:ADSOMAIN(D479HC01) STALLED WAITING FOR=
LTXNLOCK 03E90008 778E5301

Outcomes