Re: SQL sessions

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

M
Hello Stuart,

You wrote:
>Is there any way to get at the sql session transcript that a user gets when
>they STRSQL, other than signing on as that user?

Any way?  Yes.  The session information is stored in a number of spaces (type 
19, 
subtype EE) in QRECOVERY.  There are about 10 spaces created for each user.  
The name 
of each space is of the form ISQLxxUSRPROFILEDEVICENAME0000.  Where:
        xx is one of (CL, DL, EN, OB, PL, PM, PR, RL, ST, TL)
        USRPROFILE is the user profile name padded with blanks
        DEVICENAME is the device name (in use when the spaces were first 
created) 
padded with blanks
        0000 seems to be filler

The ST space is the one that contains the session information.  You can locate 
the 
appropriate space from the user profile object.

How can you access the data?
        1/ DMPSYSOBJ and parse the resulting spooled file
        2/ MI access and parse the space directly

IBM don't intend you to be messing around with this so "All hope abandon, ye 
who enter 
here!".

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175      Mobile: +61 0411 091 400           «»
«» Fax:   +61 3 9419 0175      mailto: shc@flybynight.com.au      «»
«»                                                                «»
«» Windoze should not be open at Warp speed.                      «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---