troubleshooting Question

DB2 Cache Hit Ratio

Avatar of lakers2003
lakers2003 asked on
IBM System i
8 Comments1 Solution1420 ViewsLast Modified:
Our 400 has recently slowed down quite a bit since installing a new Java application server.  Our server only has 256mb of RAM (model 250).  We are looking at adding another 256 or 512.  I come from Windows / SQL Server world, and there is a perfomance monitor for SQL that lets you see the database cache hit ratio so you can see what percentage of your queries are hitting memory instead of having to go to disk.  There has to be a similar monitor for AS/400 DB2, but I'm at a loss to discover it.  I've tried STRDBMON (also available through Ops Navigator) but that mainly gives statistics on table scans, index hits, etc.  I've also looked at STRPEX but am a little unsure of the syntax or whether it would acheive what I'm after.

Any help would be greatly appreciated.  


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros