ca.portal.admin

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

Discussion created by ca.portal.admin on Mar 10, 2010
not to muddy the waters further - but I believe that in some cases - a user can
alk away without logging off (but NOT in the middle of a
ransaction) and STILL hold locks on data resources - in this case i think the
older would be the LTERM - not a program
Chris Hoelscher
DMS/DB2 Database Architect
umana Inc
02-476-2538
hoelscher@humana.com
you only need to test the programs that you want to work correctly



From:
ynthia Kline <cakask@AOL.COM>
To:
DMSVENDOR-L@LISTSERV.IUASSN.COM
ate:
3/09/2010 07:57 PM
Subject:
e: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?
ent by:
DMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>

I have been offloading Logs - I can work with it either way.=20
What I am trying to determine is:=20
Which program is holding onto the records and causing a stall in anot= her
rogram. =20
(since I have been able to execute a TRACE while a STALL is happening= and
ee the TRACE stop right before an OBTAIN OWNER,=20
I figured if I can determine which program is holding onto (loc=
ing) the record the Stalled program needs, then I can check out THAT prog= ram
o find out why it won't let go.)=20
Thanks,=20
indy Kline

Outcomes