Re: STRSQl - Recovery of Non Saved Session, can it be done?

[Kirk Goins <kirkgoins@xxxxxxxxx>]

Thanks Everyone. I'll see what I can recover for the user.




On Fri, Aug 20, 2010 at 11:21 AM, Morgan, Paul <Paul.Morgan@xxxxxxxxxxx>wrote:

> Kirk,
>
> Craig Rutledge offers a utility which can scan a user's SQL sessions which
> involves use of the DMPSYSOBJ command:
>
> http://www.jcrcmds.com/jcrdown2.html#JCRSSQL_tag
>
> You could just run the command yourself with:
>
> DMPSYSOBJ OBJ(ISQLSTxxxxxxxxxx*) CONTEXT(QRECOVERY) TYPE(19) SUBTYPE(EE)
>
> with xxxxxxxxxx as the user profile for the sessions you want to look at
> then review the print output (command pulled out of the source in Craig's
> utility).  Likely you won't see the session if it wasn't saved but maybe
> there is some trace of the previous session if they don't start another SQL
> session.
>
> Paul
>
> Principal Programmer Analyst
> IS Supply Chain/Replenishment
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kirk Goins
> Sent: Friday, August 20, 2010 1:34 PM
> To: Midrange-L
> Subject: STRSQl - Recovery of Non Saved Session, can it be done?
>
> If a person fails to 1. Save and exit session and does a 2=Exit without
> saving session, Is there anyway to recovery the previous session?
>
> Thanks
> --
> Kirk
> --
>  This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.