Retrieving interactive SQL session data

Dan <[email protected]> Fri, 4 Jan 2008 18:08:55 -0500
Newsgroups gmane.comp.lang.as400.mi,gmane.comp.hardware.ibm.midrange
Message-ID <[email protected]>
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?

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.