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

On 22/11/2007, at 7:05 AM, Dave Odom wrote:

I wish I could have used a DBMON-type of function but as DB2/400 is not quite a real RDBMS, as it uses back doors with keyed sequence file access and not strictly SQL, it seems that this option is not available.

This is such a nonsense statement. There is nothing in an RDBMS definition that requires SQL. It's just that the current standard DDL and DML is SQL.

iSeries supports both SQL and non-SQL access to database files. Why? Because it *IS* a database machine. The database is implemented below both those I/O methods. That's a bonus not available to developers on other systems.

Because multiple methods of data access are supported it makes sense to store statistical information for both. Given the object nature of the system it also makes sense to store this information WITH the object containing the data.

A DBMON function is only going to show you information for the period during which is running anyway and therefore could give a skewed view of the real access statistics.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------