db2cert7014-2-5.html

第一次上传 这是考试得时候收集得 有关DB2701认证得教程

<TD bgcolor="#ffffff" height="1" width="150"><IMG src="../i/c.gif" width="150" height="2"></TD>
</TR>
</TABLE>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><font face="Verdana, sans-serif" size="-1"><a href="/developerWorks/cn/index.shtml">developerWorks 中国网站</a> : 
							<a href="/developerWorks/cn/dmdd/index.shtml">DB2 开发者园地</a> ： 
							<a href="/developerWorks/cn/cndmdd.nsf/dmdd-onlinecourse-bynewest?openview&count=20">教学 - 在线教程</a></font>
<br>
<img alt="监控 DB2 活动" src="imagemaster/masthead.jpg"></td><td width="*" valign="bottom" align="right"><a border="0" href="db2cert7014.zip"><img alt="下载 ZIP 文件" border="0" src="../i/icon-zip.gif"></a><a target="_blank" href="../tutorial_eng/index.html" border="0"><img alt="英文原文" border="0" src="../i/icon-source.gif"></a>
					&nbsp;&nbsp;&nbsp;
				</td>
</tr>
<tr>
<td height="2" colspan="2"><img height="2" width="1" src="../i/c.gif"></td>
</tr>
</table>
<TABLE border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD width="150" height="1" bgcolor="#000000" colspan="6"><IMG alt="" height="1" width="150" src="../i/c.gif"></TD>
</TR>
<TR>
<TD background="../i/sw-gold.gif"><a border="0" href="index.html" onMouseOver="iOver('topmain'); iOver('bottommain'); self.status=mainblurb; return true;" onMouseOut="iOut('topmain'); iOut('bottommain'); self.status=''; return true;"><img alt="主菜单" border="0" src="../i/main.gif" name="topmain"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topsection'); iOver('bottomsection'); self.status=sectionblurb; return true;" onMouseOut="iOut('topsection'); iOut('bottomsection'); self.status=''; return true;" href="index2.html"><img alt="章节菜单" border="0" src="../i/section.gif" name="topsection"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topfeedback'); iOver('bottomfeedback'); self.status=feedbackblurb; return true;" onMouseOut="iOut('topfeedback'); iOut('bottomfeedback'); self.status=''; return true;" href="db2cert7014-7-3.html"><img alt="给出此教程的反馈意见" border="0" src="../i/feedback.gif" name="topfeedback"></a></TD><TD width="100%" background="../i/sw-gold.gif"><img src="../i/c.gif"></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topprevious'); iOver('bottomprevious'); self.status=previousblurb; return true;" onMouseOut="iOut('topprevious'); iOut('bottomprevious'); self.status=''; return true;" href="db2cert7014-2-4.html"><img alt="上页" border="0" src="../i/previous.gif" name="topprevious"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topnext'); iOver('bottomnext'); self.status=nextblurb; return true;" onMouseOut="iOut('topnext'); iOut('bottomnext'); self.status=''; return true;" href="db2cert7014-2-6.html"><img alt="下页" border="0" src="../i/next.gif" name="topnext"></a></TD>
</TR>
</TABLE>
<table bgcolor="ffffff" cellspacing="0" cellpadding="2" border="0" height="400" width="100%">
<tr valign="bottom">
<a name="navskip"></a><td height="25" colspan="4"><img alt="2.捕获快照" src="imagemaster/titlebar2.jpg" border="0" height="25" width="562"></td>
</tr>
<tr>
<td bgcolor="ffffff" width="15">&nbsp;</td><td bgcolor="ffffff" width="12">&nbsp;</td><td valign="top" align="left" bgcolor="ffffff" width="*">
<p>
<br>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="90%"><font size="4" face="Verdana, Arial, Helvetica"><b>数据库快照</b></font></td><td width="200" align="right"><font size="1" face="Verdana, Arial, Helvetica"><nobr>   第 5 页（共12 页）</nobr></font></td>
</tr>
</table>
<br>
<br>
</p>
<font size="2" face="Verdana, Arial, Helvetica">
<p>根据对象的不同，可以将快照划分为不同的主题，但是每个主题中仍然有许多重复信息。最常用的快照是数据库和动态 SQL 快照。（有关后者的更多信息，请参阅<a href="db2cert7014-2-10.html">动态 SQL 快照</a>。）</p>
<p>
<i>数据库</i>快照捕获有关数据库的摘要信息。该快照中的信息几乎包含了所有其它快照中所有数据的聚集。该快照的数据是从监视器开关上一次被复位以来的摘要。</p>
<p>数据库快照是最常用的快照，通过该快照中的信息，可以清楚地了解大多数性能问题。数据库快照包含下列信息：</p>
<ul>
<li>连接</li>
<li>DB2 代理程序</li>
<li>锁</li>
<li>排序</li>
<li>缓冲池活动总数</li>
<li>SQL 活动</li>
<li>SQL 语句数量</li>
<li>日志使用情况</li>
<li>高速缓存使用情况</li>
<li>散列连接</li>
</ul>
<p>
下面是获取这种快照的命令</p>
<pre>
<code style="font-family: Courier New, Courier, monospace; font-size: 12">
db2 get snapshot for database on databaseName
</code>
</pre>
<p>下面是一些典型输出：</p>
<pre>
<code style="font-family: Courier New, Courier, monospace; font-size: 12">
<b>Connection Information</b>
High water mark for connections         = 1
Application connects                    = 1
Secondary connects total                = 0
Applications connected currently        = 1

<b>DB2 Agents</b>
Appls. executing in db manager currently	= 0
Agents associated with applications		= 1
Maximum agents associated with applications	= 1
Maximum coordinating agents		= 1

<b>Locks</b>
Locks held currently                    = 0
Lock waits                              = Not Collected
Time database waited on locks (ms)      = Not Collected
Lock list memory in use (Bytes)         = 792
Deadlocks detected                      = 0
Lock escalations                        = 0
Exclusive lock escalations              = 0
Agents currently waiting on locks       = 0
Lock Timeouts                           = 0

<b>Sorting</b>
Total Private Sort heap allocated       = 0
Total Shared Sort heap allocated        = 0
Shared Sort heap high water mark        = 0
Total sorts                             = 0
Total sort time (ms)                    = 0
Sort overflows                          = 0
Active sorts                            = 0

<b>Total Bufferpool Activity</b>
Buffer pool data logical reads          = 25
Buffer pool data physical reads         = 8
Asynchronous pool data page reads       = 0
Buffer pool data writes                 = 0
Asynchronous pool data page writes      = 0
Buffer pool index logical reads         = 43
Buffer pool index physical reads        = 23
Asynchronous pool index page reads      = 0
Buffer pool index writes                = 0
Asynchronous pool index page writes     = 0
Total buffer pool read time (ms)        = 162
Total buffer pool write time (ms)       = 0

<b>SQL Activity</b>
Commit statements attempted		 = 0
Rollback statements attempted		 = 0
Dynamic statements attempted           	 = 0
Static statements attempted            	 = 0
Failed statement operations            	 = 0
Select SQL statements executed         	 = 0
Update/Insert/Delete statements executed	 = 0
DDL statements executed                	 = 0

<b>SQL statement volume</b>
Rows deleted                             = 0
Rows inserted                            = 0
Rows updated                             = 0
Rows selected                            = 0
Rows read                                = 9

<b>Log Usage</b>
Log space available to the database (Bytes) = 7140000
Log space used by the database (Bytes)      = 0
Maximum secondary log space used (Bytes)    = 0
Maximum total log space used (Bytes)        = 0
Secondary logs allocated currently          = 0
Log pages read                              = 0
Log pages written                           = 0

<b>Cache Usage</b>
Package cache lookups                   = 0
Package cache inserts                   = 0
Package cache overflows                 = 0
Package cache high water mark (Bytes)   = 118968
Application section lookups             = 0
Application section inserts             = 0
Catalog cache lookups                   = 2
Catalog cache inserts                   = 2
Catalog cache overflows                 = 0
Catalog cache high water mark           = 0

<b>Hash Joins</b>
Number of hash joins                    = 0
Number of hash loops                    = 0
Number of hash join overflows           = 0
Number of small hash join overflows     = 0
</code>
</pre>
<br>
</font></td>
</tr>
</table>
<TABLE border="0" cellpadding="0" cellspacing="0" width="100%">
<TR>
<TD background="../i/sw-gold.gif"><a border="0" href="index.html" onMouseOver="iOver('topmain'); iOver('bottommain'); self.status=mainblurb; return true;" onMouseOut="iOut('topmain'); iOut('bottommain'); self.status=''; return true;"><img alt="主菜单" border="0" src="../i/main.gif" name="bottommain"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topsection'); iOver('bottomsection'); self.status=sectionblurb; return true;" onMouseOut="iOut('topsection'); iOut('bottomsection'); self.status=''; return true;" href="index2.html"><img alt="章节菜单" border="0" src="../i/section.gif" name="bottomsection"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topfeedback'); iOver('bottomfeedback'); self.status=feedbackblurb; return true;" onMouseOut="iOut('topfeedback'); iOut('bottomfeedback'); self.status=''; return true;" href="db2cert7014-7-3.html"><img alt="给出此教程的反馈意见" border="0" src="../i/feedback.gif" name="bottomfeedback"></a></TD><TD width="100%" background="../i/sw-gold.gif"><img src="../i/c.gif"></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topprevious'); iOver('bottomprevious'); self.status=previousblurb; return true;" onMouseOut="iOut('topprevious'); iOut('bottomprevious'); self.status=''; return true;" href="db2cert7014-2-4.html"><img alt="上页" border="0" src="../i/previous.gif" name="bottomprevious"></a></TD><TD background="../i/sw-gold.gif"><a border="0" onMouseOver="iOver('topnext'); iOver('bottomnext'); self.status=nextblurb; return true;" onMouseOut="iOut('topnext'); iOut('bottomnext'); self.status=''; return true;" href="db2cert7014-2-6.html"><img alt="下页" border="0" src="../i/next.gif" name="bottomnext"></a></TD>
</TR>
<TR>
<TD width="150" height="1" bgcolor="#000000" colspan="6"><IMG alt="" height="1" width="150" src="../i/c.gif"></TD>
</TR>
</TABLE>
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<TR>
<TD width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><img alt="" height="1" width="1" src="../i/c.gif"></td>
</tr>
<tr valign="top">
<td class="bbg" height="21">　<a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/index.shtml">关于 IBM</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/privacy/index.shtml">隐私条约</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/legal/index.shtml">法律条款</a><span class="divider">　| </span><a class="mainlink" href="/developerWorks/cgi-bin/click.cgi?url=http://www-900.ibm.com/cn/ibm/contact/index.shtml">联系 IBM</a></td>
</tr>
</table>
</TD>
</TR>
</TABLE>
<script src="//www.ibm.com/common/stats/stats.js" language="JavaScript1.2" type="text/javascript"></script>
<noscript>
<img border="0" alt="" height="1" width="1" src="//stats.www.ibm.com/rc/images/uc.GIF?R=noscript"></noscript>
</body>
</html>