Re: Need to recover SQL session

On 2/17/06, Simon Coulter <shc@xxxxxxxxxxxxxxxxx> wrote:
>
> 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?


They had never had anyone report this before.  *I* was the first!  (Yee-hah)


So, IBM had our systems manager install the latest SQL product PTFs over the
weekend in the hopes it would fix my problem.  It didn't.  There were two
PTFs applied in the QSQL library: SI15474 (temp applied) & SI08966 (perm
applied), plus a slew of MF* PTFs which may or may not have been directly
tied to the SQL problem (I saw a few for Service Director).

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


How do I delete the session object?  I'm not even seeing the screen that
lets me choose between recovering or discarding the session anymore.  On one
of my other lesser-used profiles, I was able to use ISQL for a few days
before it, too, started crashing.  I tried the "discard" option once, and it
didn't help.

The word I received was that, if this PTF didn't fix things, that IBM wanted
us to do a trace on the failure and report it to them.  We'll probably do
that tonight.

- Dan