IDMS

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

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

    Posted Mar 10, 2010 06:58 AM
    not to muddy the waters further - but I believe that in some cases - a user
    an walk away without logging off (but NOT in the middle of a
    ransaction) and STILL hold locks on data resources - in this case i think
    he holder 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=
    er program. =20
    (since I have been able to execute a TRACE while a STALL is happening=
    nd see 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=
    am to find out why it won't let go.)=20
    Thanks,=20
    indy Kline