RE: SQL interactive session & activity history

Dan, 

Session info is kept in internal space objects associated with a particular
workstation display id.  
You probably are signed into different or multiple workstations sessions and
are getting history for that particular session.

Easiest way to get around this is probably to sign on to the session you
want, or delete unwanted histories (space objects) by entering
STRSQL->F3->2.  Option 2 deletes the space object.

To learn more about STRSQL exit options and session object search algorithm
see:

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

page 5, article STRSQL Conundrum.

HTH

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: SQL interactive session & activity history

Anybody know why or how an SQL interactive session could lose its most
recent activity history?

I did a STRSQL this morning and, instead of seeing last week's activity, I'm
seeing activity from 2 or 3 weeks ago at the bottom of the list.

This will be a major crapola on my week if I can't recover all the work I
did last week.

TIA,
Dan