| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> jiang jie bu huo IBM DB2 SQL de zhi xing kuai zhao de fang fa
 

jiang jie bu huo IBM DB2 SQL de zhi xing kuai zhao de fang fa

2008-07-09 05:37:12 编辑來源:互联网 评论
 
本文为【讲解捕获IBM DB2 SQL的执行快照的方法】的拼音翻译版
  shou xian , xian jian li yi ge jian kong qi 。
  db2 "create event monitor SQLCOST for statements write to file '/home/db2inst1'"
  zai she zhi shi wu zhuang tai wei da kai 。
  db2 "set event monitor SQLCOST state=1"
  zhu :1 wei da kai ,0 wei guan bi , shou ji shu ju zhi hou , ji de guan bi ni de jian kong qi , fou ze ……
  pao ni de ce shi hou , zai ni de /home/db2inst1 mu lu xia hui sheng cheng yi xie evm wen jian
  yong xia mian zhi ling huo qu zhen duan xin xi :
  db2evmon -db eos51 -evm SQLCOST>sqlcost1.txt
  wan cheng zhi hou shan chu ni de jian kong qi
  db2 "drop event monitor SQLCOST"
  sheng cheng de cai yang li zi , cong xia mian de li zi zhong , ni ke yi qing chu de kan dao SQL zhi xing de shi jian ,CPU xiao hao qing kuang , pai xu shi fou yi chu ,BufferPool de shi yong qing kuang , gen ju zhe xie xin xi ,SQL de zhi xing xiao lv yi mu le ran :
  26) Statement Event ...
  Appl Handle: 336
  Appl Id: C0A80421.O905.0ABDA5065446
  Appl Seq number: 0657
  Record is the result of a flush: FALSE
  -------------------------------------------
  Type : Dynamic
  Operation: Execute
  Section : 7
  Creator : NULLID
  Package : SYSSN300
  Consistency Token : SYSLVL01
  Package Version ID :
  Cursor : SQL_CURSN300C7
  Cursor was blocking: FALSE
  Text : update WFProcessInst set relateData=? where processInstID= ?
  -------------------------------------------
  Start Time: 04/25/2007 14:57:19.402248
  Stop Time: 04/25/2007 14:57:19.409622
  Exec Time: 0.007374 seconds
  Number of Agents created: 1
  User CPU: 0.000000 seconds
  System CPU: 0.000000 seconds [licl1]
  Fetch Count: 0
  Sorts: 0
  Total sort time: 0
  Sort overflows: 0 [licl2]
  Rows read: 1
  Rows written: 1
  Internal rows deleted: 0
  Internal rows updated: 0
  Internal rows inserted: 0
  Bufferpool data logical reads: 9
  Bufferpool data physical reads: 0
  Bufferpool temporary data logical reads: 0
  Bufferpool temporary data physical reads: 0
  Bufferpool index logical reads: 3
  Bufferpool index physical reads: 0
  Bufferpool temporary index logical reads: 0
  Bufferpool temporary index physical reads: 0 [licl3]
  SQLCA:
  sqlcode: 0
  sqlstate: 00000
  ------------------------------------------------------
  [licl1]SQL zhi xing shi jian he CPU xiao hao qing kuang 。
  [licl2]SQL de pai xu qing kuang , ke yi kan dao zhe ge SQL mei you pai xu , dang ran ye mei you pai xu yi chu 。
  [licl3]Bufferpool de shi yong qing kuang , luo ji du he wu li du de dui bi 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
shou xian , xian jian li yi ge jian kong qi 。 db2 "create event monitor SQLCOST for statements write to file '/home/db2inst1'" zai she zhi shi wu zhuang tai wei da kai 。 db2 "set event monitor SQLCOST state=1" zhu :1 wei da kai ,0 wei guan bi , shou ji shu ju zhi hou , ji de guan bi ni de jian kong qi , fou ze …… pao ni de ce shi hou , zai ni de /home/db2inst1 mu lu xia hui sheng cheng yi xie evm wen jian yong xia mian zhi ling huo qu zhen duan xin xi : db2evmon -db eos51 -evm SQLCOST>sqlcost1.txt wan cheng zhi hou shan chu ni de jian kong qi db2 "drop event monitor SQLCOST" sheng cheng de cai yang li zi , cong xia mian de li zi zhong , ni ke yi qing chu de kan dao SQL zhi xing de shi jian ,CPU xiao hao qing kuang , pai xu shi fou yi chu ,BufferPool de shi yong qing kuang , gen ju zhe xie xin xi ,SQL de zhi xing xiao lv yi mu le ran : 26) Statement Event ... Appl Handle: 336 Appl Id: C0A80421.O905.0ABDA5065446 Appl Seq number: 0657 Record is the result of a flush: FALSE ------------------------------------------- Type : Dynamic Operation: Execute Section : 7 Creator : NULLID Package : SYSSN300 Consistency Token : SYSLVL01 Package Version ID : Cursor : SQL_CURSN300C7 Cursor was blocking: FALSE Text : update WFProcessInst set relateData=? where processInstID= ? ------------------------------------------- Start Time: 04/25/2007 14:57:19.402248 Stop Time: 04/25/2007 14:57:19.409622 Exec Time: 0.007374 seconds Number of Agents created: 1 User CPU: 0.000000 seconds System CPU: 0.000000 seconds [licl1] Fetch Count: 0 Sorts: 0 Total sort time: 0 Sort overflows: 0 [licl2] Rows read: 1 Rows written: 1 Internal rows deleted: 0 Internal rows updated: 0 Internal rows inserted: 0 Bufferpool data logical reads: 9 Bufferpool data physical reads: 0 Bufferpool temporary data logical reads: 0 Bufferpool temporary data physical reads: 0 Bufferpool index logical reads: 3 Bufferpool index physical reads: 0 Bufferpool temporary index logical reads: 0 Bufferpool temporary index physical reads: 0 [licl3] SQLCA: sqlcode: 0 sqlstate: 00000 ------------------------------------------------------ [licl1]SQL zhi xing shi jian he CPU xiao hao qing kuang 。 [licl2]SQL de pai xu qing kuang , ke yi kan dao zhe ge SQL mei you pai xu , dang ran ye mei you pai xu yi chu 。 [licl3]Bufferpool de shi yong qing kuang , luo ji du he wu li du de dui bi 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
可爱车模崔星儿(17)
可爱车模崔星儿(16)
可爱车模崔星儿(15)
可爱车模崔星儿(14)
艳丽的海棠花
钓者
南半球的天空--天涯海角
雪之界
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有