ca.portal.admin

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

Discussion created by ca.portal.admin on Mar 11, 2010
The Journal Analyzer ABORT COINCIDENCE report also might give you a
lue.
Dick
Richard Pierce
617) 973-8911
ichard.pierce@state.ma.us

----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
n Behalf Of Tommy Petersen/NYLIC
Sent: Thursday March 11, 2010 4:17 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?

he best you can do is pray that it is not a keep longterm that causes
he
roblem.
Have you used LOCKMON when the problem happens. W LTERM should show the
ong term locks.
RELEASE ALL will let it go, but you till need to find out where it
appens and when, in order to issue the release at the correct time.
Since a longterm lock is held by the lterm, it can be very difficult to
ind out what program it comes from.
n implicit lock, or a keep (without longterm) only lasts for the length
f
he run-unit so those are much easier to find, if they cause trouble you
ill be able to see the executing program and the many locks held by
hat
rogram.
The keep longterm exclusive is especially problematic as it is usually
sed
or protecting data from being updated in between run-units, otherwise
n
btain keep exclusive would be just as good.
f something unexpected happens between the two run-units and the user
tarts on something completely different, the release may not happen, or
t
east not for a while.
Tommy Petersen
10 Cokesbury Rd
oom 542H
ebanon, NJ 08833
Phone:
Internal 200 - 3699
External (908) 236-3699
ax: (908) 236-3692


Cynthia Kline
<cakask@AOL.COM>
Sent by: IDMS
o
Public Discussion IDMS-L@LISTSERV.IUASSN.COM
Forum
c
<IDMS-L@LISTSERV.
IUASSN.COM>
Subject
Re: [IDMSVENDOR-L] Access to Lock
Data Used in PMRM?
03/11/2010 01:29
PM

Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>



don't know - as I wrote it is in TSTLCK95 - and this looks like rather
ld code (don't know whether it was custom?)
(and in something like ADDPOITM, then I really don't ""get it"")
Question - how long do locks hold?
Meaning - like an implicit lock vs an explicit lock vs a KEEP
ONGTERM ( and perhaps a KEEP LONGTERM xx UPDGRADE EXCLUSIVE'


f the KEEP LONGTERM UPGRADE EXCLUSIVE is the problem - should a RELEASE
LL make it let go?
(Because it appears the locks involved in the stalls seem awfully
ersistent.)
Thanks!!
indy Kline
SK
40-829-9275

Outcomes