ca.portal.admin

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

Discussion created by ca.portal.admin on Mar 9, 2010
then perhaps the real question becomes:

does Ms Kline need this information real time as it happens, or can
daily reports suffice

if the latter, then certainly the log can be interrogated and all
necessary information can be retrieved
if the former - good luck - even if you sat all day executing lockmon
you MIGHT see stalls building, but many deadlocks could come and go
between 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?
"not to muddy the waters further - but I believe that in some cases - a
user can walk away without logging off (but NOT in the middle of a
transaction) and STILL hold locks on data resources - in this case i think
the holder would be the LTERM - not a program

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
Cynthia Kline <cakask@AOL.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
03/09/2010 07:57 PM
Subject:
Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?
Sent by:
IDMS 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 program. =20
(since I have been able to execute a TRACE while a STALL is
happening=
and see the TRACE stop right before an OBTAIN OWNER,=20
I figured if I can determine which program is holding onto (loc=
king) the record the Stalled program needs, then I can check out THAT
prog=
ram to find out why it won't let go.)=20

Thanks,=20
Cindy Kline

Outcomes