ISQL Sessions

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

I've found that all ISQL sessions created by STRISQL are stored in the
userid's library in a file table called QSQLSESS.   One of the ways you
can find any object of this type is to use a query like:

SELECT                                                                 
      
-- Columns                                                             
      
      A.TABLE_OWNER, A.TABLE_NAME, A.TABLE_TYPE, A.COLUMN_COUNT,
A.ROW_LENGTH,
      A.TABLE_TEXT, A.LONG_COMMENT, A.TABLE_SCHEMA,
A.LAST_ALTERED_TIMESTAMP, 
      A.SYSTEM_TABLE_NAME, A.SYSTEM_TABLE_SCHEMA, A.FILE_TYPE,         
      
      A.BASE_TABLE_SCHEMA, A.BASE_TABLE_NAME, A.BASE_TABLE_MEMBER      
      
-- Tables                                                              
      
      FROM "QSYS2"/"SYSTABLES" A                                       
      
-- Row Selection                                                       
      
      WHERE (A.TABLE_NAME  LIKE '%SQL%')                               
      
-- Sort Columns                                                        
      
      ORDER BY A.TABLE_OWNER, A.TABLE_NAME                             
      

And modify the variable selection as to TABLE_NAME or anything else as
you choose.   As you all probably know this query is looking in the DB2
SYSTABLES which is one of the many 'SYS' tables where a lot of info is
stored.  Some other tables are:  SYSINDEXES, SYSPACKAGE, SYSPROC,
SYSTRIGER, and there are more.  In a normal DB2 system, these tables are
the only place where anything truly DB2 is stored.

Take care,

Dave
Arizona