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:
does Ms Kline need this information real time as it happens, or can
aily reports suffice
if the latter, then certainly the log can be interrogated and all
ecessary information can be retrieved
f the former - good luck - even if you sat all day executing lockmon
ou MIGHT see stalls building, but many deadlocks could come and go
etween two hits of the ENTER key
chris
"
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: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?
"Dang AOL..
So this is what I see - and one of my users is currently locked out after getting the STALL


TASK ID ORIG IDMSPROG SUBSCHEM PRI STA V# PAGEREAD PAGEWRIT CALLIDMS LOCK-REQ
0000000010 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001
0000000009 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001
0000000008 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001
0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00000000 00000000 00000022 00000001
0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00003700 00000000 00011688 00000001
0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 00000003 00000001
0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 00000003 00000001
0000000005 DBDC RHDCRUAL IDMSSECU 253 H 95 00000000 00000000 00000010 00000006
0000000005 DBDC RHDCRUAL IDMSSECU 253 H 95 00000655 00000000 00006653 00005113
0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00000049 00000000 00000815 00000001
0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00012838 00000000 00226599 00000001
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00000001 00000000 00000121 00000025
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00001296 00000000 00261314 00066480
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00000044 00000000 00000898 00000361
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00008680 00000000 00277119 00110576
0000000002 DBDC RHDCRUAL IDMSNWK7 253 H 95 00000004 00000016 00000266 00000317
0000000002 DBDC RHDCRUAL IDMSNWK7 253 H 95 00003717 00003272 00075108 00089903


IDMS DB/DC V1 - Tasks active:17 Time: 11:58:01







And W LTERM shows hundred of NOTIFY locks


















Finally in LOCKMON - but again - I don't know who has the lock?



















Area_Name__________________
TRN
__NL_
__IS_
__IX_
__S__
__U__
UIX
__X__

CASSCHEM.CAS-OE-ORD-AREA
59
0
0
0
0
0
0
0

CASSCHEM.CAS-ORD-AREA
75
155
0
2
0
0
0
0

CASSCHEM.CAS-PICK-AREA
36
0
0
0
0
0
0
0

CASSCHEM.CAS-PLANT-AREA
38
7
0
0
0
0
0
0

CASSCHEM.CAS-PO-ORD-AREA
78
201
0
5
0
0
0
0

CASSCHEM.CAS-PROCDEF-AREA
2
0
0
0
0
0
0
0

CASSCHEM.CAS-REPLN-AREA
36
31
0
2
0
0
0
0

Outcomes