This is an old revision of the document!
healthCheck
Syntax
mixed healthCheck()
Description
The function healthCheckCli
executes a single database health check pass and writes the information to an html format table. A valid performance monitoring The output provided is the same as that returns by healthCheckcli().
Usage
/* * Connection to DB2 database */ $perf = newPerfMonitor($db); echo $perf->healthCheckCli(); /* -- Ratios -- data cache hit ratio => 0 -- Data Cache -- data cache buffers => 1000 cache blocksize => 8192 data cache size => 8000K -- Connections -- current connections => 7 */
The following HTML is returned:
<html> <table border=1 bgcolor=white><tr><td colspan=3><h3>db2</h3></td></tr><tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr><tr bgcolor=#F0F0F0><td colspan=3><i>Ratios</i> </td></tr><tr><td>data cache hit ratio</td><td>0</td><td><font color=red><b>Cache ratio should be at least 90%</b></font></td></tr> <tr bgcolor=#F0F0F0><td colspan=3><i>Data Cache</i> </td></tr><tr><td>data cache buffers</td><td>1000</td><td>See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.</td></tr> <tr><td>cache blocksize</td><td>8192</td><td> </td></tr> <tr><td>data cache size</td><td>8000K</td><td> </td></tr> <tr bgcolor=#F0F0F0><td colspan=3><i>Connections</i> </td></tr><tr><td>current connections</td><td>7</td><td> </td></tr> </table> </html>