Re: Need to recover SQL session
Dan <[email protected]>
| Newsgroups | gmane.comp.lang.as400.mi |
|---|---|
| Message-ID | <[email protected]> |
On 2/20/06, Elvis Budimlic <ebudimlic-Ebbh53c6wcYkzXN11fiE55igCaZBIYHkAL8bYrjMMd8@public.gmane.org> 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 _______________________________________________ This is the MI Programming on the AS400 / iSeries (MI400) mailing list To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mi400 or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mi400.