How do I collect the following DB2 connections detail using MON_GET_* views or any other methods or relevant scripts?

Hello experts,

I will a speedy help in resolving a performance issue that my management have asked for. We need this report urgently to try to justify purchasing additional cores for our servers because they maxing out in memory and CPU.

I need to create a report (table) over a period of 1 week using the following criteria:

1) Number of Store Users, that logs onto the system throughout the day
2) Number of Sysad Users, that logs onto the system throughout the day (Sysad=administrators)
3) Maximum Number of Concurrent Store Users, that logs onto the system on one day
4) Maximum Number of Concurrent Sysad Users, that logs onto the system on one day.

Can this requirement be accomplished using the MON_GET_CONNECTION/MON_GET_CNNECTION_DETAILS views? If so, how can that be used and if possible can you show example of the kind of script to use?

Do anyone kow of script or set of scripts that can provide the information that I am looking for using the criteria above?

Please help if you can...Ineed this urgently


Thanks inadvance

Enyimba
EnyimbaAsked:
Who is Participating?
 
Tomas Helgi JohannssonCommented:
Hi!

To collect information on connections during some period of time you should use Event Monitoring.
Create Event Monitor for connections which logs the info to file, pipe or table.
Logging into table would give you better control to search through and manage the data  using SQL.  You could count and sum connections from workstations and users easily with SQL. :)

Look at  example 3 here
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000915.html?cp=SSEPGG_9.7.0%2F2-10-6-56

And some sample output here
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.admin.mon.doc/doc/r0005991.html

Regards,
     Tomas Helgi
0
 
EnyimbaAuthor Commented:
Thank you Tomas for your response. I will check the links and see what I can do with it...will be back with the result

Enyimba
0
 
EnyimbaAuthor Commented:
Tomas Helgi ,

I have tried the MON_GET_CONNECTION view and interrogated the following columns CLIENT_WRKSTNNAME
CLIENT_USERID
CLIENT_ACCTNG
and they were all NULLS.

Is there some switch or something that I need to enable to get these fields populated?

On the other hand, when I looked at the next two columns, SYSTEM_AUTH_ID
SESSION_AUTH_ID from the same MON_GET_CONNECTION view,  I see values that correspond to a known values we use internally for system authorization id and it also fills in for a session auth_id. Is it possible for CLIENT_USERID and SYSTEM_AUTHID be different?
Under what scenario will differences occur? I suspect they can differ, otherwise why would IBM have both present?

Any help will be highly appreciated.

Thanks

Enyimba
0
 
EnyimbaAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.