db2 怎样清空缓存 - 问答 - twt企业IT交流平台

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

开朗的麻辣香锅 · 水晶透明KT猫适用绿联t3 T6 ...· 5 月前 ·

帅气的登山鞋 · 杭城高中今年将招收5736名分配生，名额怎么 ...· 5 月前 ·

飘逸的冰淇淋 · 海阳市政府海阳大事记 2014年大事记· 5 月前 ·

体贴的板凳 · PayPal Community Blog ...· 6 月前 ·

逃跑的棒棒糖 · 基于Matlab怎么绘制小提琴图 - ...· 7 月前 ·

<i class="icon-read"><i class="icon-write"><i class="icon-faxian"><div class="actionBar clearfix"><div class="aB_item"><button class="btn btn-primary" onclick="location.href='/Login'">回答</button></div><div class="aB_item"><button class="btn btn-primary btn_tishi" onclick="location.href='/Login'">邀答</button></div><div class="aB_item js_pid" tid="266231" pname="wenda"><a href="javascript:" onclick="location.href='/Login'">关注<span class="count js_count">1</span></a></div><div class="aB_item"><a href="javascript:;" id="show_q_comment" onclick="show_comment_box($(this))" data-item="question" data-original_parent_id="0" data-id="1733967">评论<div class="arrow"><div id="question_1733967_arrow_up"/></div></a></div><div class="aB_item">参与<span class="count">14</span></div><button class="basicShareBtn btn btn btn-default pull-right" data-shareurl="https://www.talkwithtrend.com/Question/266231" data-sharetitle="db2 怎样清空缓存" data-sharepic="" style="padding: 0 5px"><i class="icon-fenxiang"/> 分享</button></div><div id="huida_box" class="yaoda_page" style="display: none"/><div class="quickCommon hide" id="quickCommonbox_1733967"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1733967" data-original_parent_id="0" data-id="1733967" data-item="question" class="text-muted">添加评论</a></li></ul></div><input type="hidden" id="twt_publish_fid" value="12"/><input type="hidden" id="twt_publish_app" value=""/><input type="hidden" id="twt_publish_relate_id" value=""/></div><div class="answerModle"><a name="answerlist"/><h2 class="columnTitle borderBottom"><span>13</span><span>同行回答</span><div class="btn-group pull-right" role="group"><div class="btn-group" role="group"><a type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">全部行业<span class="caret"/></a><ul class="dropdown-menu"><a href="/Question/266231#answerlist" class="list-group-item">全部行业</a><a href="/Question/266231?industry=金融-银行#answerlist" class="list-group-item">银行</a><a href="/Question/266231?industry=IT-软件开发#answerlist" class="list-group-item">软件开发</a><a href="/Question/266231?industry=IT-互联网服务#answerlist" class="list-group-item">互联网服务</a><a href="/Question/266231?industry=政府-政府机关#answerlist" class="list-group-item">政府机关</a><a href="/Question/266231?industry=IT-IT咨询服务#answerlist" class="list-group-item">IT咨询服务</a></ul></div><div class="btn-group marginLR5 text-muted">|</div><div class="btn-group" role="group"><a type="button" class="btn btn-xs grey_button" href="/Question/266231?order=rec">按赞同排序</a></div><div class="btn-group" role="group"><a type="button" class="btn btn-xs btn-default" href="/Question/266231?order=date">按时间排序</a></div></div></h2><div class="commonList"><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=939767"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=939767&size=small&v=1707390389" class="avatar32 img-rounded" alt="xinyongzhi123"/></a><a class="name" target="_blank" href="/home/space.php?uid=939767" title="xinyongzhi123">xinyongzhi123</a> 
							数据库管理员									, 宇信易诚<div class="fLI_voters"/></div><div id="answer_1734189"><div class="cLI_text summary hide">db2 deactivate db dbname  是可以缓存的<a href="javascript:;" id-data="answer_1734189" class="jsShow">显示全部</a></div><div class="cLI_text showTop editor-html-preview">db2 deactivate db dbname  <br/>是可以缓存的<a href="javascript:;" id-data="answer_1734189" class="jsHide">收起</a></div><span class="timestamp">互联网服务 · </span><span class="timestamp"><a href="/Question/266231-1734189">2015-03-13</a></span></div></div><textarea id="editor_answer_box" class="hide"/><div class="actionBar clearfix"><div class="aB_item"><button id="a_pid_1734189" onclick="window.location.href='/Login';" class="btn blue_button btn-xs">赞同</button></div><div class="aB_item">浏览<span class="count">2653</span></div><div class="aB_item"><a href="javascript:;" onclick="show_comment_box($(this))" data-item="answer" data-original_parent_id="0" data-id="1734189">评论<div class="arrow"><div id="answer_1734189_arrow_up"/></div></a></div></div><div class="quickCommon hide" id="quickCommonbox_1734189"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1734189" data-original_parent_id="0" data-id="1734189" data-item="answer" class="text-muted">添加评论</a></li></ul></div></div><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=939767"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=939767&size=small&v=1707390389" class="avatar32 img-rounded" alt="xinyongzhi123"/></a><a class="name" target="_blank" href="/home/space.php?uid=939767" title="xinyongzhi123">xinyongzhi123</a> 
							数据库管理员									, 宇信易诚<div class="fLI_voters"/></div><div id="answer_1734185"><div class="cLI_text summary hide">db2 deactivate db dbname  是可以缓存的<a href="javascript:;" id-data="answer_1734185" class="jsShow">显示全部</a></div><div class="cLI_text showTop editor-html-preview">db2 deactivate db dbname  <br/>是可以缓存的<a href="javascript:;" id-data="answer_1734185" class="jsHide">收起</a></div><span class="timestamp">互联网服务 · </span><span class="timestamp"><a href="/Question/266231-1734185">2015-03-13</a></span></div></div><textarea id="editor_answer_box" class="hide"/><div class="actionBar clearfix"><div class="aB_item"><button id="a_pid_1734185" onclick="window.location.href='/Login';" class="btn blue_button btn-xs">赞同</button></div><div class="aB_item">浏览<span class="count">2656</span></div><div class="aB_item"><a href="javascript:;" onclick="show_comment_box($(this))" data-item="answer" data-original_parent_id="0" data-id="1734185">评论<div class="arrow"><div id="answer_1734185_arrow_up"/></div></a></div></div><div class="quickCommon hide" id="quickCommonbox_1734185"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1734185" data-original_parent_id="0" data-id="1734185" data-item="answer" class="text-muted">添加评论</a></li></ul></div></div><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=41162"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=41162&size=small&v=1707390389" class="avatar32 img-rounded" alt="张东焕"/></a><a class="name" target="_blank" href="/home/space.php?uid=41162" title="张东焕">张东焕</a> 
							技术总监									, IBM官方授权讲师<div class="fLI_voters"/></div><div id="answer_1734127"><div class="cLI_text summary hide"><img src="http://www.db2china.net/club/images/common/back.gif"/>这个也是写脏数据的，而不是清空缓冲区的吧zyclove2008 发表于 2015-3-13 10:04 
Option -flushbp is added into db2pdcfg tool to allow usersmanaully flush dirty pages in bufferpool to disk<a href="javascript:;" id-data="answer_1734127" class="jsShow">显示全部</a></div><div class="cLI_text showTop editor-html-preview"><div class="quote"><blockquote>这个也是写脏数据的，而不是清空缓冲区的吧<br/>zyclove2008 发表于 2015-3-13 10:04 <a href="/Question/41445-295849"><p><a href="http://www.db2china.net/club/images/common/back.gif" class="example-image-link" data-lightbox="example-set"/><a class="example-image-link" href="http://www.db2china.net/club/images/common/back.gif" data-lightbox="example-set"><img class="example-image" src="http://www.db2china.net/club/images/common/back.gif"/></a></p></a></blockquote></div>
<br/>Option -flushbp is added into db2pdcfg tool to allow usersmanaully flush dirty pages in bufferpool to disk<a href="javascript:;" id-data="answer_1734127" class="jsHide">收起</a></div><span class="timestamp">IT咨询服务 · </span><span class="timestamp"><a href="/Question/266231-1734127">2015-03-13</a></span></div></div><textarea id="editor_answer_box" class="hide"/><div class="actionBar clearfix"><div class="aB_item"><button id="a_pid_1734127" onclick="window.location.href='/Login';" class="btn blue_button btn-xs">赞同</button></div><div class="aB_item">浏览<span class="count">2674</span></div><div class="aB_item"><a href="javascript:;" onclick="show_comment_box($(this))" data-item="answer" data-original_parent_id="0" data-id="1734127">评论<div class="arrow"><div id="answer_1734127_arrow_up"/></div></a></div></div><div class="quickCommon hide" id="quickCommonbox_1734127"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1734127" data-original_parent_id="0" data-id="1734127" data-item="answer" class="text-muted">添加评论</a></li></ul></div></div><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=940139"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=940139&size=small&v=1707390389" class="avatar32 img-rounded" alt="chenxw_mail"/></a><a class="name" target="_blank" href="/home/space.php?uid=940139" title="chenxw_mail">chenxw_mail</a> 
							项目经理									, 123<div class="fLI_voters"/></div><div id="answer_1734115"><div class="cLI_text summary hide">理解楼主的意思，不过印象中没有这样的方法，以前内存资源没这么充足的时候，可以通过查询大表把缓存数据替换掉的方法(缓冲池此时缓存的全是这张大表的数据)，现在服务器内存普遍很大就不太好操作了。...<a href="javascript:;" id-data="answer_1734115" class="jsShow">显示全部</a></div><div class="cLI_text showTop editor-html-preview">理解楼主的意思，不过印象中没有这样的方法，以前内存资源没这么充足的时候，可以通过查询大表把缓存数据替换掉的方法(缓冲池此时缓存的全是这张大表的数据)，现在服务器内存普遍很大就不太好操作了。<a href="javascript:;" id-data="answer_1734115" class="jsHide">收起</a></div><span class="timestamp">互联网服务 · </span><span class="timestamp"><a href="/Question/266231-1734115">2015-03-13</a></span></div></div><textarea id="editor_answer_box" class="hide"/><div class="actionBar clearfix"><div class="aB_item"><button id="a_pid_1734115" onclick="window.location.href='/Login';" class="btn blue_button btn-xs">赞同</button></div><div class="aB_item">浏览<span class="count">3038</span></div><div class="aB_item"><a href="javascript:;" onclick="show_comment_box($(this))" data-item="answer" data-original_parent_id="0" data-id="1734115">评论<div class="arrow"><div id="answer_1734115_arrow_up"/></div></a></div></div><div class="quickCommon hide" id="quickCommonbox_1734115"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1734115" data-original_parent_id="0" data-id="1734115" data-item="answer" class="text-muted">添加评论</a></li></ul></div></div><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=928417"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=928417&size=small&v=1707390389" class="avatar32 img-rounded" alt="zyclove2008"/></a><a class="name" target="_blank" href="/home/space.php?uid=928417" title="zyclove2008">zyclove2008</a> 
							数据库运维工程师									, xsw<div class="fLI_voters"/></div><div id="answer_1734109"><div class="cLI_text summary hide">这个也是写脏数据的，而不是清空缓冲区的吧<a href="javascript:;" id-data="answer_1734109" class="jsShow">显示全部</a></div><div class="cLI_text showTop editor-html-preview">这个也是写脏数据的，而不是清空缓冲区的吧<a href="javascript:;" id-data="answer_1734109" class="jsHide">收起</a></div><span class="timestamp">软件开发 · </span><span class="timestamp"><a href="/Question/266231-1734109">2015-03-13</a></span></div></div><textarea id="editor_answer_box" class="hide"/><div class="actionBar clearfix"><div class="aB_item"><button id="a_pid_1734109" onclick="window.location.href='/Login';" class="btn blue_button btn-xs">赞同</button></div><div class="aB_item">浏览<span class="count">2994</span></div><div class="aB_item"><a href="javascript:;" onclick="show_comment_box($(this))" data-item="answer" data-original_parent_id="0" data-id="1734109">评论<div class="arrow"><div id="answer_1734109_arrow_up"/></div></a></div></div><div class="quickCommon hide" id="quickCommonbox_1734109"><ul class="qCList"><li><a href="javascript:;" onclick="show_comment_box($(this))" id="comment_add_1734109" data-original_parent_id="0" data-id="1734109" data-item="answer" class="text-muted">添加评论</a></li></ul></div></div><div class="cL_item"><div class="jcH"><div class="cLI_author clearfix"><a href="/home/space.php?uid=41162"><img src="https://www.talkwithtrend.com/ucenter/avatar.php?uid=41162&size=small&v=1707390389" class="avatar32 img-rounded" alt="张东焕"/></a><a class="name" target="_blank" href="/home/space.php?uid=41162" title="张东焕">张东焕</a> 
</i></i></i>