5 Things to Know about IBM Data Server Manager
MarcelaAdanRochester 2700048UPS Visits (14052)
Data Server Manager is available in two editions:
Clients can start by trying the basic functions with the free Base Edition and upgrade to the Enterprise Edition when they are satisfied with the product and want to have access to the advanced functions.
The built-in alerting, notification, and action features enable management by exception so that you know when your database system is not performing as expected. A DBA can also define custom alerts and specify a corresponding action. Data Server Manager can be configured to collect both real-time and historical metrics for a database. You can monitor the end-to-end transaction response time for specific workloads. Data Server Manager helps you to manage the response time service level agreements (SLAs) for high priority workloads. It can issue alerts to keep the DBA abreast of database issues before they become serious. IBM Data Server Manager provides monitoring and alert services for HADR for standard configurations of IBM DB2 V10.1 (and above) for Linux, Unix and Windows. Figure 1 shows the data from the clients that are accessing the monitored database which provides end-to-end monitoring.
Figure 1. Client monitoring data dashboard
Data Server Manager Query Tuning feature allows DBAs to analyze existing queries to improve their performance. This feature helps DBAs and developers to:
Data Server Manager provides a visual graphical representation of the access plan which facilitates the analysis for tuning poorly performing statements. It also provides recommendation for BLU Table Advisor and Shadow Table Advisor and recommendations on where to use BLU Acceleration and BLU Shadow Tables. Figure 2 shows the SQL access graph, the tables statistics, and other details.
Figure 2. Access graph and table statistics data
Data Server Manager includes features for configuration comparisons and change tracking for database objects and configuration settings. DBAs can gain insight into client and server configurations and track changes that could potentially be harmful for the system and lead to unplanned outages. Data Server Manager provides a centralized way to control and manage database configuration parameters and their application to clients and servers for optimal performance. It helps to reduce the risk of outages and optimize storage by saving space. Figure 3 shows an example of comparing the configuration of two databases.
Figure 3. Configuration management: Compare Configurations
DBAs can use Data Server Manager for database management and maintenance tasks, including object, change, and authorization management, scripting, and job scheduling to automate changes to a database. Figure 4 shows an example of how a DBA can explore a monitored database.
Figure 4. Explore database objects
Data Server Manager provides a GUI to explore the database and its objects. It also provides a simple interface to create and run SQL statements. Figure 5 shows an example of how a DBA can prepare and run an SQL directly on database.
Figure 5. Create and run SQL on the database
To learn more about IBM Data Server Manager see the following resources:
Ashok Kumar is a technical lead in the IBM Analytics Platform Development in the USA. Ashok has over 10 years of experience with IBM DB2 and related tools. Ashok is a subject matter expert for IBM DB2 and Optim tools products which include a set of tools for database monitoring, query tuning, database administration, database merge and backup, and advance database migration and recovery. Ashok has taken several client facing roles and demonstrated technical leadership in a variety of assignments including product development and deployment, consultancy, business development management, and project management. Ashok is the author of the IBM Redbooks Analytics Support Web Doc