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.