Re: Need to recover SQL session

On 18/02/2006, at 12:36 PM, Dan wrote:

> BTW, following the aforementioned thread a bit more, I tried a:
> DMPSYSOBJ OBJ('ISQLSTDAN      ISD15     0000') CONTEXT(QRECOVERY) 
> TYPE(19)
> SUBTYPE(EE)
> The printed output is one page, and towards the bottom of the report, 
> I see
> CPF2524 and the first level text of the message.  And that's it.
>
> I did this for another user not having any problems using STRSQL, and 
> his
> DMPSYSOBJ produces 20 pages, and I see all the SQL session history in 
> it.
>
> I really, really hope I can recover my session history!  Any help 
> would be
> greatly appreciated!

Sounds to me like your SQL Session object has become damaged and that 
causes an exception handler loop hence the CPF2524 exception. The 
recovery for this message is "Report this problem to IBM" so what did 
they say?

As far as I recall Craig's utility used DMPSYSOBJ to print the session 
contents and then parsed the spooled file to extract the data. If so 
then it will have the same problem.

I think your SQL session is gone. You may have to delete the session 
object to allow ISQL to start functioning again.


Regards,
Simon Coulter.
--------------------------------------------------------------------
    FlyByNight Software         AS/400 Technical Specialists

    http://www.flybynight.com.au/
    Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
    Fax:   +61 3 9419 0175                                   \ /
                                                              X
                  ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------


_______________________________________________
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.