Re: SQL history lost moving to new i

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

You talking saved sessions??

On Thu, Nov 19, 2009 at 12:44 PM, Buck <kc2hiz@xxxxxxxxx> wrote:

> We moved to a new E4A a few weeks ago and everything went swimmingly.
> Even the spooled files got restored to the new machine.  Today, one of
> the developers tried STRSQL and discovered all her saved SQL statements
> are gone.  Stupidly, I tried the same thing and found mine are gone too.
>
> I say stupidly because I am well aware that they are stored in QRECOVERY
> and are accessible-ish via DMPSYSOBJ ISQLST* QRECOVERY TYPE(19)
> SUBTYPE(EE) I didn't think to dump the objects before accessing them and
> apparently on first touch they get reset.
>
> My question: How can I restore them so I can use DMPSYSOBJ?
>  --buck
> --
> 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.