Do you have version 8? If so ...


select * from table (snapshot_database('SAMPLE',-1)) as snapshot_database

where SAMPLE is your database.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Richard Flores "
<db2udbdba-ezmlms
hield-x30311738.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
09/21/2004 01:19
PM Subject
connection information










I'd like to see more information about connections into the database than
is
shown by "DB2 list applications show detail"



Specifically, I'd like to see who is logged on (client OS id, for example)
and time off connection.



I'm pretty sure this information is available, but I don't know where.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page