基于SMF的大型主机DB2数据库分析工具

Analysis tool for mainframe DB2 database based on SMF

开发了一个基于IBM大型主机SMF数据的DB2数据库分析工具。利用该工具,可以从SMF数据中提取与DB2数据库相关的实时运行状态数据,将其以图表的形式在开放平台上展示出来,可以在Web端对DB2的SQL语句执行情况、CPU利用率、TOTAL、COMMITS和ROLL BACK等参数进行查询、图表显示以及对比显示同类测试,能够帮助管理人员进行大型主机数据库系统便捷、高效地实时监控和应急处理。

An analysis tool for the DB2 database based on SMF data of IBM mainframe is developed.With this tool,the real-time data related to the DB2 database can be extracted from the SMF data and displayed on an open platform in the form of charts.The SQL statement execution of DB2,the CPU utilization ratio,the parameters of TOTAL,COMMITS,ROLL BACK,etc.,can be inquired,displayed by chart and compared with the similar tests at the Web side.It can help the administrators to carry out the convenient and efficient real-time monitoring and control,and emergency handling of the mainframe database system.