ca.portal.admin

Re: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:=20
=20
does Ms Kline need this information real time as it happens, or can=20
daily reports suffice=20
=20
if the latter, then certainly the log can be interrogated and all=20
necessary information can be retrieved=20
if the former - good luck - even if you sat all day executing lockmon=20
you MIGHT see stalls building, but many deadlocks could come and go=20
between two hits of the ENTER key=20
=20
chris=20



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
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?
"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