IBM®
Skip to main content
    United States change      Terms of use
 
 
Select a scope:    
     Home      Products      Services & industry solutions      Support & downloads      My account     
alphaWorks  >  Information management  >  

IBM Single System View Monitor for DB2

A tool that provides a consolidated, snapshot-based, "single-system view" of a DB2 Database Partitioning Feature (DPF) system.


Date Posted: September 30, 2005
OverviewRequirements Download FAQs Forum Reviews

Update: July 20, 2007

Version 2.0: Bug fixes; improved performance and reliability; and support for more platforms.

What is IBM Single System View Monitor for DB2?

This tool was developed by IBM® technical field specialists and development labs for the purpose of quickly and efficiently monitoring a complex DB2® Database Partitioning Feature (DPF) environment. It uses simple and familiar monitoring user interfaces and combines DB2 snapshot information from all partitions in a DB2 DPF system in order to provide a unified view of the database.

How does it work?

This monitor for DB2 Universal Database is specifically designed for DPF environments. It provides a unified, "single-system view" of a multi-partition DB2 database that can be used to quickly identify either partition-specific or global problems in the system.

The user interface is character-based and is similar in nature to many UNIX® monitoring utilities.

IBM Single System View Monitor for DB2 uses the DB2 snapshot monitoring APIs to retrieve data. It uses both global as well as partition-specific monitoring information to provide aggregation as well as quick drill-down capabilities.


About the technology author(s):
Subho Chatterjee is a senior technical manager at the IBM Toronto Software Lab; he has more than ten years of software development and consulting experience with relational database technologies. Over the course of his career at IBM, Mr. Chatterjee has led numerous infrastructure development activities in DB2 and focused on improving the usability, performance, and "up-and-running" experience of the administration tools. He has been part of the DB2 autonomic computing effort with responsibilities for various self-monitoring and self-healing technologies. Currently, he manages the high availability development team in the DB2 kernel.

Jacques Milman is an executive IBM IT architect with more than 15 years of experience in the area of data warehousing and business intelligence. He is recognized as a thought leader in BI architecture and has led, from a technical perspective, many multi-million dollar solutions and service deals involving DB2/DPF in various countries. Using his strong experience of parallel architectures, benchmarks and performance analysis, and optimization, Mr. Milman designed IBM Single System View Monitor for DB2 in order to simplify the monitoring of large DB2/DPF databases in large and complex production environments. He is currently a member of the IBM WW BI Best Practice Architecture Team and works for IBM Information Management, Software Group, in France.


UNIX is a registered trademark of The Open Group in the United States and other countries.
IBM and DB2 are trademarks of IBM Corporation in the United States, other countries, or both.
Other company, product, or service names may be trademarks or service marks of others.

Download now Download now

Related technologies

For platform(s):
Linux, Intel, AIX V5.x, Sun Solaris/SPARC

For topics:
analysis, Databases and data management, IBM DB2 monitor, monitoring, performance


Related resources

Press Articles

 

    About IBM Privacy Contact