RE: Retrieving interactive SQL session data

I've looked into STRSQL saves for one of our articles. Check out page 5,
"STRSQL Conundrum" at this link:

http://www.centerfieldtechnology.com/publications/archive/February%2006.pdf

HTH, Elvis

Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Retrieving interactive SQL session data

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