Re: Need to recover SQL session

On 2/20/06, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> I am not sure if you have multiple session objects in QRECOVERY.  If you
> do,
> following might help:
>
> If you're able to enter STRSQL on any of your workstation devices, hit F3
> and select option 2 (Exit without saving session).  Keep doing this
> entry/exit procedure until you delete all of your session objects
> (permanent
> miscellaneous space objects in QRECOVERY).  When they're all gone you
> should
> end up with a fresh STRSQL session that has no history in it, i.e. only
> messages you see in the display are:
>
> -----------------------------------------------------------------------
> Type SQL statement, press Enter.
>      Current connection is to relational database <YOUR_SYSTEM_NAME>.
> -----------------------------------------------------------------------
>
> and you can't page up as there's no session history in that session.


That's kind of what I was hoping for.  But I'm not even getting past the
STRSQL command prompt anymore; no recovery/discard options are available.  I
looked for a DLTSYSOBJ, but apparently IBM didn't want to give us the gun to
shoot ourselves in the foot.

Anybody want to hazard a guess as to whether it's possible & relatively easy
to look past the last "entry" (the only "entry" that shows the CPF2524
error) in the DMPSYSOBJ, perhaps by address, to see if I can browse the
session history that is apparently lost?  I'm talking "10 minutes" kind of
"easy".

TIA,
Dan