Differences

This shows you the differences between two versions of the page.

--- reference:healthcheck [2015/08/22 19:40] – mnewnham
+++ reference:healthcheck [2015/08/23 16:47] (current) – removed mnewnham
@@ Line 1: / Line 1: @@
-====== healthCheck ======
-~~NOTOC~~
-<WRAP right box>
-== Syntax ==
-  mixed healthCheck()
-</WRAP>
-===== 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 [[reference:healthcheckcli|healthCheckcli()]].
-===== Usage =====
-<code php>
-/*
-* 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
-*/
-</code>
-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> &nbsp;</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> &nbsp;</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>&nbsp;</td></tr>
-<tr><td>data cache size</td><td>8000K</td><td>&nbsp;</td></tr>
-<tr bgcolor=#F0F0F0><td colspan=3><i>Connections</i> &nbsp;</td></tr><tr><td>current connections</td><td>7</td><td>&nbsp;</td></tr>
-</table>
-</html>