It's no secret that data volumes and workloads are growing. This is driving a hybrid data architecture where you can select the right deployment platform (cloud, private cloud or on premises) to match the data, workload and application requirements. For a hybrid data architecture ,the key question becomes … how are you going to manage it all? End-to-end visibility is essential if you are going to keep your environment in top shape.
What is IBM Data Server Manager?
IBM Data Server Manager (DSM) provides a single view across your hybrid data architecture, back through time, and across your private and public cloud. It works with variety of IBM data repositories and data servers including:
- IBM DB2 for Linux, UNIX and Windows
- DB2 for z/OS
- DB2 for Cloud
- IBM dashDB Local (private cloud data warehouse)
- dashDB for Analytics (full managed service on the cloud)
- dashDB for Transactions
- IBM BigInsights (Hadoop) including Big SQL monitoring support
This is the end-to-end visibility you need to simplify and manage complexity across a data environment that may have hundreds of data servers installed in on-premises, public cloud and private cloud deployments. Refer to the “About Data Server Manager” section below if you are not currently using Data Server Manager and would like more information or wish to download the free version.
What’s new for Data Server Manager?
Data Server Manager version 2.1.3 is now available. Here are a few highlights:
- For monitoring, you can now separate work into well-defined workloads so you can monitor performance based on business needs.
- When your database and DSM server are in different time zones you can swap between database and browser time zones.
- Security enhancements include Active Directory LDAP support and other database privilege administration improvements.
- From a development and data management perspective, using the SQL editor for multiple result sets is faster and allows connection reuse as well as enhanced support for longer-running and more complex SQL. There is also support for the latest DB2 BINARY and VARBINARY types.
- For availability, DSM now has new alerts to ensure your HADR system is ready when you need it.
- DSM now allows you to handle DB2 backup and restore from Swift and S3 repositories.
- Finally, user interface enhancements to help you learn on the fly and get tasks done more quickly
For more information on this release and to get started with an upgrade from Fix Central (for DSM Enterprise Edition customers) learn more about these enhancements here.
Three New Best Practices Guides for Data Server Manager
Three new best practices guides are also available for Data Server Manager and you should be aware of them:
- Setting up Data Server Manager as a Highly Available service – The team has created a best practices guide to help you set up Data Server Manager as a highly available service. Access this guide here.
- How to Manage Database Privileges in Data Server Manager – You can leverage these best practices to get up and running on new capabilities for administration of your database environment. Access this guide here.
- SQL Statement Monitoring: Historical Analysis– Monitoring SQL statements from a historical perspective can be critical to solving problems and improving performance. Looking at what statements were running at any point in time can provide essential information to avert these problems in the future. Also, this information can be used if you charge back business users for their access. Access this guide here.
About Data Server Manager
IBM Data Server Manager is a simple, scalable and smart solution to help administer, monitor, manage and optimize IBM databases across the enterprise.
For those who are new to DSM, there is a freely available edition that you can download and use at no charge. This free edition offers database development, administration and basic performance monitoring capabilities to the above listed platforms at no charge.
There is also the Data Server Manager Enterprise Edition that is available at a charge. It offers all of the capabilities of the free edition, plus advanced capabilities including enhanced monitoring history, centralized configuration management, refined performance management and query tuning capabilities with expert advice for DB2 for Linux, UNIX and Windows as well as a growing list of the above platforms.