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.