Re: How can I determine "hit rate" for a set of files in

Hi Dave

Glad you had a good Thanksgiving - as did I - gotta love a niece that knows how to go to Boston Market for all the kit to have a great dinner!

As to DBMON - is there somewhere I/we can find out what it is in, say, the Z/OS version of DB2 that you want to see? I'm not sure my statement of the limitations of the iSeries DBMON fit your question - and I'm certainly not expert in what else would be needed there - the kinds of information are wide - you might take a look at the www.iseries.ibm.com/db2 site and dig around to see what STRDBMON provides - optimizer stuff, index suggestions, all that. It might offer more than I know, more of what you are looking for.

PEX - Performance Explorer - is great stuff - a veritable cacophony of information. The site www.iseries.ibm.com/perfmgmt has links - there is a tool there, PTDV (Performance Trace Data Visualizer), that is a free tool for analyzing PEX data. There is also a link from the Performance Management page for Performance Explorer that should get you started in that very deep complex world. There are reports on the green screen side, if you have Performance Tools installed, but you don't need Performance Tools licensed product to collect the data and use PTDV.

HTHAL (HTH a little)
Vern

At 12:00 PM 11/23/2007, you wrote:

Vern,

Someone did respond with info on DBMON but as they and you point out it if falls short for providing the comprehensive data and info I'm looking for as it only provides SQL activity and in a true RDBMS, like the real DB2s, it might have all of what I want. But, alas, the i5 is a pseudo-DB2; a good start to be sure and going in the direction of the real DB2s and ORACLE, etc., but not there yet despite what Rochester and those only focused on i5/OS believe.

You have brought something new to help solve my quest for detailed I/O data, a Performance Explorer. No one else has mentioned that. I'd like to know more so if you can point me in the right direction I'd appreciate it. It is disappointing however, that it takes a special invocation to get what I want (probably more than what I want) and it takes so much resources. What i'm looking for should be in the SYS tables or somewhere like. For now, I guess I'll have to use DSPFD.

I also respect a lot of what you have to say but I'm not sure to what "doesn't wash" is referring. I've read some of Codd's and Date's works and had a chance to talk with Chris and the developers of DB2 at Santa Teresa Lab and the ORACLE development folks and, clearly, what they say and have implemented as a UNIVERSALLY accepted implementation of Codd's rules and Chris's thoughts, is not DB2/400. To turn your analogy around... If it doesn't look like "the" ducks(universally accepted RDBMSs) and doesn't...(you get it), it must not be a universally accepted "duck"; and DB2/400 isn't. If I were wrong about that, the world would seriously consider DB2/400 in the same duck family... and it doesn't. I REALLY wish it weren't so but it is.

Hope you had a good Thanksgiving as I did and I look forward to trading thoughts and ideas in the future.

Take care,

Dave
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.