At the beginning, I needed to access my production database quickly, especially when on call. Building this tool I was able to see what was going on in the system, what the users were doing, investigate slow performing processes including locking queries. This saved me from the tedious task of looking up snapshot syntaxes, memorizing large DB2 or Unix commands.
Today, this application does much more than its simple beginnings. Instead of using the uncomfortable tree view most of database utilities offer to get to one object, I just click the tab of the object I want to look for, and find what I need with a couple of mouse clicks.
This application is also great to get the DDL structure of any object, in large, multi, and range partitioned DB2 databases. Junior DB2 dba's and developers will find it very useful, but senior dba's will love it. You can get a day free trial of either of the paid plans. Nagios XI is a monitoring system for networks, servers, and applications. Its capabilities include the monitoring of Db2 databases.
It will also monitor your applications that access your Db2 instances and the servers that support them. It also offers network monitoring, so you get a full stack view with this tool of your entire IT system. The Db2 monitor checks on database availability and response times. It watches issues such as tablespace size, total database size, cache ratios, and database object types and numbers.
These basic metric monitors can be expanded by plugins. The Nagios system has thousands of plugins available. These are provided for free by other users and also by product vendors.
There are a number of plugins for Db2 in the community marketplace. Both of these packages run on Linux. Nagios XI is available for a day free trial. Site24x7 is a SaaS platform that provides system monitoring services. The Infrastructure package includes a range of monitoring capabilities including network and server monitoring capabilities. The ability to monitor Db2 databases is contained in a plugin, which can easily be added to the package for free.
The Site24x7 Infrastructure plan includes the capacity to monitor 10 servers. Each server is allowed one free plugin. It is possible to use more than one plugin per server for a fee.
So, if you use Db2 on one server, you only need that integration on that server and you can use different plugins on other servers. The Db2 monitor tracks a list of factors on database activities. The dashboard that shows these live statistics also provides a forecasting service that gives projections of where demand on the database is going and how database size is expected to grow.
An alternative approach to benefit from the extensibility of Site24x7 Infrastructure is to install the Nagios integration. This allows all of the plugins available for Nagios XI to be added in without actually installing Nagios. That means that a single integration allowance can be used as a conduit for thousands of free Nagios plugins that can all operate simultaneously. Site24x7 uses AI to set performance threshold levels. These thresholds trigger alerts when breached and those alerts can be forwarded by email or SMS.
While tracking the accesses to each Db2 instance, the Site24x7 service builds up an application dependency map. This is a good foundation for root cause analysis should problems arise. You can experience Site24x7 Infrastructure on a day free trial. ManageEngine Applications Manager monitors the performance of applications and the servers that support them. This is a very wide-ranging package that has the ability to monitor a long list of applications. Db2 is on that list. The service will consolidate the monitoring of many Db2 instances and centralize the monitoring of multiple sites.
The DB2 monitor has its own screens in the dashboard of the Applications Manager. It tracks database information and identifiers , information about the size of objects, tablespaces and entire instances, connection statistics, details on agent performance, transaction statistics, cache, and memory activity, buffer statistics, and tablespace statuses.
The user can nominate a particular database query for special analysis. The Applications Manager tracks the availability and response times of all Db2 instances.
Failure of connection to the database is one cause of alerts and notifications that are raised by the system. Other situations that will cause an alert to arise are resource shortages or performance deterioration. The dashboard for the Applications Manager shows live performance data in graphs and charts. These screens can be customized and so can the performance thresholds that trip alerts.
It is possible to adjust threshold levels or create composite conditions that observe conditions of several metrics. The Applications Manager includes a system discovery tool, which searches for all active applications. It then examines the interactions between these applications. This includes noting which applications access each Db2 instance. This creates an application dependency map , which provides useful source material for root cause analysis when performance problems arise in the system.
It is available in three editions: Free , Professional , and Enterprise. The Free version is limited to five monitors. The Professional edition covers a single site and the Enterprise edition will monitor multiple sites. I did find one, but not one that I can use. I just added it as an answer. Add a comment. Active Oldest Votes. Ian Bjorhovde Ian Bjorhovde This tool is very powerful, however, it works better with the most recent DB2 versions.
For the installation, you have to follow the Wiki sourceforge. Angoca, does this tool allow you to perform CRUD actions on the data? However, the live demo is configured to now change the database. At the same time, I would like to say that the initial question was for administration, not for data manipulation.
Michael Merchant Michael Merchant 1, 2 2 gold badges 17 17 silver badges 27 27 bronze badges. Thank you for your answer : ps: did the Technology Explorer work for you? No problem! I checked out the example on the website: db2mc. Try following one, configuretion is little difficult but after that working fine.
Gopalch Gopalch 1 1 silver badge 7 7 bronze badges.
0コメント