Sami

The commands
1) db2 list application show details
2) db2 get snapshot for database on <dbname>

should give the information you want ...

If you are on Version 8, you can use the snapshot table functions
snapshot_appl_info and snapshot_appl ..

db2 "select * from table(snapshot_appl_info('SAMPLE',-1)) a"
db2 "select * from table(snapshot_appl_info('SAMPLE',-1)) a"

HTH

Sathyaram
www.db2click.com





-----Original Message-----
From: Saminathan
[mailto:db2udbdba-ezmlmshield-x7649728.[Email address protected]
Sent: 29 July 2004 15:36
To: LazyDBA Discussion
Subject: DB2 newbie question




Hi All,

How to check the database connectivity in DB2?

For example, I would like to know how many connections are currently
connected, from which machine and what is the userid.

Like similar to v$session in oracle.

Thanks in advance,
Sami





************************************************************************
This E-mail is confidential. It may also be legally privileged. If you
are not the addressee you may not copy, forward, disclose or use any
part of it. If you have received this message in error, please delete
it and all copies from your system and notify the sender immediately
by return E-mail.

Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
************************************************************************


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



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