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:
oes Ms Kline need this information real time as it happens, or can
ily reports suffice
f the latter, then certainly the log can be interrogated and all
cessary information can be retrieved
the former - good luck - even if you sat all day executing lockmon
u MIGHT see stalls building, but many deadlocks could come and go
tween two hits of the ENTER key
hris
"
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?
"Dang AOL.. =20
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 0000000=
3 00000001
0000000009 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 0000000=
3 00000001
0000000008 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 0000000=
3 00000001
0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00000000 00000000 0000002=
2 00000001
0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00003700 00000000 0001168=
8 00000001
0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 0000000=
3 00000001
0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 0000000=
3 00000001
0000000005 DBDC RHDCRUAL IDMSSECU 253 H 95 00000000 00000000 0000001=
0 00000006
0000000005 DBDC RHDCRUAL IDMSSECU 253 H 95 00000655 00000000 0000665=
3 00005113
0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00000049 00000000 0000081=
5 00000001
0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00012838 00000000 0022659=
9 00000001
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00000001 00000000 0000012=
1 00000025
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00001296 00000000 0026131=
4 00066480
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00000044 00000000 0000089=
8 00000361
0000000003 DBDC RHDCRUAL IDMSNWKL 253 H 95 00008680 00000000 0027711=
9 00110576
0000000002 DBDC RHDCRUAL IDMSNWK7 253 H 95 00000004 00000016 0000026=
6 00000317
0000000002 DBDC RHDCRUAL IDMSNWK7 253 H 95 00003717 00003272 0007510=
8 00089903
=20
=20
IDMS DB/DC V1 - Tasks active:17 Time: 11:58:01

=20





And W LTERM shows hundred of NOTIFY locks


















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



















Area_Name__________________=20
TRN
__NL_
__IS_
__IX_
__S__
__U__
UIX
__X__

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

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

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

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

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

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

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

Outcomes