Re: Retrieving interactive SQL session data

   To prevent creating an indefinitely large number of sessions, the 
algorithm to pick a session can and will choose an available session 
with a name that does not match the device being used.  Thus when signed 
on to device BIXBYA1, any of those three existing sessions will be 
chosen; unless all three are already active/in-use.  Thus if three 
separate sessions are opened, you may find the session you are looking 
for, that is, those three dumped may very well be the only three.

   Note: If another user name exists with DBIXBY as a prefix [from the 
name in the dump output, presumably that was meant; versus that the 
wrong user name was given?], the desirable dump request is:
   DMPSYSOBJ 'ISQLSTDBIXBY    *' qrecovery 19 ee

   FWiW: Because a session can not be saved and restored, I simply save 
a session into a source member, and then delete that session.  Seems a 
lot more straight-forward to get the session details that way, with a 
program that already exists, than to try to write a program to extract 
the statements from a dump.?

Regards, Chuck
-- 
  All comments provided "as is" with no warranties of any kind 
whatsoever and may not represent positions, strategies, nor views of my 
employer

Dan wrote:
> I am already aware of DmpSysObj Obj(&ObjectName) Context(QRECOVERY) Type(19)
> SubType(EE) to retrieve interactive SQL session data.  (In fact, if anyone's
> interested, I've written an app that turns the DMPSYSOBJ output into more
> readable output.)
> 
> But I discovered today that this does not recover all of the display
> sessions that I use interactive SQL on.  I've used the same user ID from the
> very beginning, so specifying an object name of 'ISQLSTBIXBY*', should, I
> expect, retrieve all of my sessions.  Unfortunately, I only see the
> following in the DMPSYSOBJ output:
> 
> NAME-        ISQLSTDBIXBY    BIXBYF1   0000
> NAME-        ISQLSTDBIXBY    BIXBYB1   0000
> NAME-        ISQLSTDBIXBY    BIXBYD1   0000
> 
> I have several other display sessions that I use interactive SQL on, notably
> BIXBYA1, which is where I usually use STRSQL, including today.  Is there any
> known reason why this isn't picking up all of the sessions?

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.