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

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

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  / \
--------------------------------------------------------------------