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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EnyimbaAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.