db2划时代监控工具 (free ，open source)

字数 1764阅读 1580评论 1赞 0

<h2><u><b>dsmtop introduction</b></u><br></h2><p>You can use dsmtop to see key performance indicators in all of the same areas covered by db2top plus additional areas relevant to more recent features.  A few of the more significant views provided in dsmtop include:</p><ul><li>Sessions – see at a glance which connections are active, blocked, or idle.  You can drill down on a connection to see details of the current state of execution of SQL that is</li><li>Executed SQL – see a list of recently executed statements.  Drill down is provided to see the full SQL text or run explain on a statement.</li><li>Top Consumers – find which connections or activities are consuming the most CPU, IO or other resource.</li><li>Time spent – shows a breakdown of where the monitored database is spending time, broken down to the full granularity provided by DB2.</li><li>PureScale performance</li><li>HADR status</li></ul><h2><b><u>Comparison to db2top</u></b></h2><p>The goal of dsmtop is to improve on and extend the features that people liked in db2top.  With this is mind, it has much of the same look and feel of db2top.  It accepts the same command line arguments as db2top and recognizes hotkeys familiar to users of db2top.  There are some improvements and new features in dsmtop that people have been requesting for db2top.  Some highlights:</p><ul><li>Support for recent DB2 features including PureScale, BLU (column store tables) and workload management.</li><li>Monitor remote databases.</li><li>Limited support for Windows.  You can run dsmtop on Windows, although a few features are not implemented for Windows.  See the README file for details.</li><li>Easier navigation with menus, in addition to support for hotkeys familiar to db2top users.</li><li>Views are no longer limited to the number of rows that you can fit on your screen.  Pagination is provided to scroll up and down.</li></ul>

db2划时代数据库监控 IBM 数据库

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论1 条评论

flywiththewind其它easy world
2016-03-25 13:50

冯哥这个工具从哪下？还是新版本中自带的？

Ctrl+Enter 发表

匿名评论

db2划时代监控工具 (free ，open source)

添加新评论1 条评论

作者其他文章

相关文章

相关问题

相关资料