Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 omegamon reports

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Thu Jan 20, 2011 7:22 pm    Post subject: DB2 omegamon reports
Reply with quote

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
View user's profile Send private message

Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Thu Jan 20, 2011 7:36 pm    Post subject: Reply to: OMEGAMON
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 20, 2011 9:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Fri Jan 21, 2011 3:55 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts OMEGAMON to see In-DB2 times and Wait... Archana89 IBM Tools 4 Fri Mar 04, 2016 11:28 am
No new posts Create runtime members (DB2 related) ... Manshadi IBM Tools 1 Sat Jan 10, 2015 9:27 pm
No new posts Validation of reports generated in As... deb_parthas PL/I & Assembler 3 Wed Jul 30, 2014 3:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us