许多应用程序处于编译状态 [英] Many applications in Compiling status
问题描述
环境：DB2 V7 + FP 14运行Linux。
我的一个系统性能很差。 CPU 100％忙碌。
我激活了一个事件监视器，由
应用程序发送的预准备语句执行时间很长。在PREPARE期间，我可以看到一个瓶颈
。当应用程序发出OPEN时，响应是快速的b $ b。
当我运行list applications show detail时，我可以看到几十个
应用程序处于编译状态。
Diaglevel 3，DFT_QUERYOPT = 5，DFT_DEGREE = ANY
任何人都可以提出任何建议可以看一下来解决这个问题吗？
谢谢，
Environment: DB2 V7 + FP 14 running Linux.
One of my systems is performing poorly. CPU is 100% busy.
I activated an Event Monitor and the prepared statements sent by
applications are taking very long to execute. I can see a bottleneck
during the PREPARE. When the application issues an OPEN, response is
quick.
When I run a "list applications show detail", I can see dozens of
applications in Compiling status.
Diaglevel 3, DFT_QUERYOPT = 5, DFT_DEGREE= ANY
Can anyone suggest anything that can be looked at in order to fix this
issue?
Thanks,
推荐答案
在文章< 11 ********************** @ z14g2000cwz.googlegroups .com> ;,
Michel Esber（mi****@us.automatos.com）说...
In article <11**********************@z14g2000cwz.googlegroups .com>,
Michel Esber (mi****@us.automatos.com) says...
环境：运行Linux的DB2 V7 + FP 14.
我的一个系统表现不佳。 CPU 100％忙碌。
我激活了一个事件监视器，
应用程序发送的预处理语句执行时间很长。在PREPARE期间，我可以看到一个瓶颈。当应用程序发出OPEN时，响应很快。
当我运行list applications show detail时，我可以看到许多应用程序处于编译状态。
Diaglevel 3，DFT_QUERYOPT = 5，DFT_DEGREE = ANY
任何人都可以建议任何可以解决的问题以解决这个问题吗？
<谢谢，
Environment: DB2 V7 + FP 14 running Linux.
One of my systems is performing poorly. CPU is 100% busy.
I activated an Event Monitor and the prepared statements sent by
applications are taking very long to execute. I can see a bottleneck
during the PREPARE. When the application issues an OPEN, response is
quick.
When I run a "list applications show detail", I can see dozens of
applications in Compiling status.
Diaglevel 3, DFT_QUERYOPT = 5, DFT_DEGREE= ANY
Can anyone suggest anything that can be looked at in order to fix this
issue?
Thanks,
（我不认为你有同样的问题，但以防万一......）
当一些表格被更改时我已经看到了这种问题，并且
自动重新绑定发生了。重新绑定包解决了
问题。
(I don''t think you have the same problem but just in case...)
I''ve seen this kind of problem when some tables were changed and
automatic rebinding occured. Rebinding the packages solved the
problem.
我刚刚执行了db2rbind数据库，我的系统现在再次稳定。
CPU消耗回到合理水平。
感谢您的快速响应和强烈的提示。
-Michel
I just executed a db2rbind DB all and my system is now stable again.
CPU consumption is back to reasonable levels.
Thank you for your fast response and great hint.
-Michel
难以置信。在平稳运行约20分钟后，我的系统再次非常慢地再次使用
。
数百个应用程序处于编译状态。和CPU再次100％。
任何想法？
谢谢
Unbelievable. After running smooth for approx 20 minutes, my system is
again very slow.
Hundreds of applications in Compiling status. And CPU again at 100%.
Any ideas ?
Thanks
这篇关于许多应用程序处于编译状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
