64 lines
4.4 KiB
HTML
64 lines
4.4 KiB
HTML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!DOCTYPE html
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
<html lang="en-us" xml:lang="en-us">
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
<meta name="security" content="public" />
|
|
<meta name="Robots" content="index,follow" />
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
|
<meta name="DC.Type" content="reference" />
|
|
<meta name="DC.Title" content="Memory-resident database monitor external API description" />
|
|
<meta name="abstract" content="The memory-resident database monitor is controlled by a set of APIs." />
|
|
<meta name="description" content="The memory-resident database monitor is controlled by a set of APIs." />
|
|
<meta name="DC.Relation" scheme="URI" content="mbdma.htm" />
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
|
<meta name="DC.Format" content="XHTML" />
|
|
<meta name="DC.Identifier" content="memresapidescription" />
|
|
<meta name="DC.Language" content="en-us" />
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|
<!-- US Government Users Restricted Rights -->
|
|
<!-- Use, duplication or disclosure restricted by -->
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
|
<title>Memory-resident database monitor external API description</title>
|
|
</head>
|
|
<body id="memresapidescription"><a name="memresapidescription"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Memory-resident database monitor external API description</h1>
|
|
<div><p>The memory-resident database monitor is controlled by a set of
|
|
APIs.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><caption>Table 1. External API Description</caption><thead align="left"><tr valign="bottom"><th valign="bottom" width="50%" id="d0e20">API</th>
|
|
<th valign="bottom" width="50%" id="d0e22">Description</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td align="left" valign="top" width="50%" headers="d0e20 "><a href="../apis/qqqssdbm.htm"><span class="apiname">Start SQL Database Monitor (QQQSSDBM)</span></a></td>
|
|
<td align="left" valign="top" width="50%" headers="d0e22 ">API to start the SQL monitor</td>
|
|
</tr>
|
|
<tr><td align="left" valign="top" width="50%" headers="d0e20 "><a href="../apis/qqqcsdbm.htm"><span class="apiname">Clear SQL Database Monitor Statistics (QQQCSDBM)</span></a></td>
|
|
<td align="left" valign="top" width="50%" headers="d0e22 ">API to clear SQL monitor memory</td>
|
|
</tr>
|
|
<tr><td align="left" valign="top" width="50%" headers="d0e20 "><a href="../apis/qqqdsdbm.htm"><span class="apiname">Dump SQL Database Monitor (QQQDSDBM)</span></a></td>
|
|
<td align="left" valign="top" width="50%" headers="d0e22 ">API to dump the contents of the SQL monitor
|
|
to table</td>
|
|
</tr>
|
|
<tr><td align="left" valign="top" width="50%" headers="d0e20 "><a href="../apis/qqqesdbm.htm"><span class="apiname">End SQL Database Monitor (QQQESDBM) API</span></a></td>
|
|
<td align="left" valign="top" width="50%" headers="d0e22 ">API to end the SQL monitor</td>
|
|
</tr>
|
|
<tr><td align="left" valign="top" width="50%" headers="d0e20 "><a href="../apis/qqqqsdbm.htm"><span class="apiname">Query SQL Database Monitor (QQQQSDBM)</span></a></td>
|
|
<td align="left" valign="top" width="50%" headers="d0e22 ">API to query status of the database monitor </td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="mbdma.htm" title="The Memory-Resident Database Monitor is a tool that provides another method for monitoring database performance. This tool is only intended for SQL performance monitoring and is useful for programmers and performance analysts. The monitor, with the help of a set of APIs, takes database monitoring information and manages them for the user in memory. This memory-based monitor reduces CPU overhead as well as resulting table sizes.">Monitoring your queries using memory-resident database monitor</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |