|
View previous topic :: View next topic
|
| Author |
Message |
vicky10001
Warnings : 1
Active User
.jpg)
Joined: 13 Jul 2005
Posts: 136
|
|
|
|
I am review Db2 omegamon reports. Here's the report
#THREADS #COMMITS AVG EL.TIME IN-DB2 EL.TIME
#DISTRIB #ABORT AVG CPUTIME IN-DB2 CPUTIME
-------- -------- -------------- --------------
28 331 0.620768 0.036358
0 0 0.030076 0.011676
AVG EL.TIME IN-DB2 EL.TIME AVG SYNC.I/O
AVG CPUTIME IN-DB2 CPUTIME OTH.READ TIME
----------- -------------- --------------
0.620768 0.036358 0.031992
0.030076 0.011676 0.440922
AVG EL.TIME IN-DB2 EL.TIME AVG SYNC.I/O
AVG CPUTIME IN-DB2 CPUTIME OTH.READ TIME
----------- -------------- --------------
0.620768 0.036358 0.031992
0.030076 0.011676 0.440922
Please let me know the meaning of the variables and use? How to start tunning the same |
|
| Back to top |
|
 |
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
|
|
|
|
Vicky10001 said -
| Quote: |
| Please let me know the meaning of the variables and use? How to start tunning the same |
This will require research on your part, using the Omegamon documentation. It's all there. You need to look for it.
If you're going to use the Product to tune DB2 (as you've indicated), then you need to familiarize yourself with it.
Bill |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
As you have been here for more than 5 years, you should alredy be quite familiar with the "Code" tag. What you posted is nearly unreadable because the Code tag was not used. . . |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
I could give a tuning course, it only takes 5 days and 3000$.
I guess if you don't know what #threads or avg SYNC IO. means, it would take 20 days and 10.000$
(with a minimum of 5 students enlisted ) |
|
| Back to top |
|
|
|
|
