SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 12:44 PM
| ||||
| ||||
 Reporting On DB2 Performance Hello, I'm posting this casually, with hope that someone can provide a bit of guidance. DB2 has many monitors, health, performance, etc. My management has asked me to provide a report on a regular basis that would show them how well, or unwell our DB2 environment may be performing. Does anyone have an example of a meaningful report, or could you guide me in creating for myself, a meaningful report, on my DB2 environment? Meaningful in this context is probably pretty wide open. Thanks for anything. I am DB2 V8.2 Enterprise on Linux I686 . Claude      |
|
02-27-2008, 12:44 PM
| |||
| |||
| Re: Reporting On DB2 Performance On Jun 7, 11:10 am, "cjs...@gov.pe.ca" <cjs...@gov.pe.ca> wrote: > Hello, I'm posting this casually, with hope that someone can provide a > bit of guidance. DB2 has many monitors, health, performance, etc. My > management has asked me to provide a report on a regular basis that > would show them how well, or unwell our DB2 environment may be > performing. Does anyone have an example of a meaningful report, or > could you guide me in creating for myself, a meaningful report, on my > DB2 environment? Meaningful in this context is probably pretty wide > open. Thanks for anything. I am DB2 V8.2 Enterprise on Linux I686 . > > Claude I'd say "management" is responsible for defining "performance." What specific measure would indicate the quality of "performance" to management? |
|
02-27-2008, 12:44 PM
| ||||
| ||||
| Re: Reporting On DB2 Performance 1) You could create a monitor on tables , connections and memory used 2) usage of db2mtrk tool for tracking memory usage 3) get the snapshot of memory frequently using tables. 4) Write a small memory applications which use memory api's of db2 Regards, Sivaswami On Jun 7, 9:10 pm, "cjs...@gov.pe.ca" <cjs...@gov.pe.ca> wrote: > Hello, I'm posting this casually, with hope that someone can provide a > bit of guidance. DB2 has many monitors, health, performance, etc. My > management has asked me to provide a report on a regular basis that > would show them how well, or unwell our DB2 environment may be > performing. Does anyone have an example of a meaningful report, or > could you guide me in creating for myself, a meaningful report, on my > DB2 environment? Meaningful in this context is probably pretty wide > open. Thanks for anything. I am DB2 V8.2 Enterprise on Linux I686 . > > Claude |
Linear Mode
