Where Can I locate current db2 connections by a client

[nek]

Greetings,

We have reporting tools (Crystal Report/Cognos) that run queries and
display results on browsers through their Enterprise Servers. These
queries access DB2 in the background via stored procedures.

At some stage, we have user who could open up 10 webpages at a time
each of which could make 10 db2 connections.

Where Can I find info regarding the number of users, number of db2
connections made by each user currently accessing DB2?

Appreciate any suggestions.

[Ian]

nek wrote:

Greetings,

We have reporting tools (Crystal Report/Cognos) that run queries and
display results on browsers through their Enterprise Servers. These
queries access DB2 in the background via stored procedures.

At some stage, we have user who could open up 10 webpages at a time
each of which could make 10 db2 connections.

Where Can I find info regarding the number of users, number of db2
connections made by each user currently accessing DB2?

The command "db2 list applications" or "db2 list applications show
detail" will provide you with the info you're looking for.

You may also see the same information from the Control Center by
right clicking on the instance and choosing "Applications".
Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----