Bookmark and Share

Recent Posts

How Data Server Manager Fits with z/OS

April 19, 2016

I’ve written a lot about Data Server Manager (DSM) since its release in October and the announcement of DB2 for z/OS support in January.

DSM initially caught my eye back because its unique new architecture provides the capability to access development tools from any web browser, including browsers on mobile devices. Since DSM's availability I’ve learned how it fits with IBM's z/OS strategy of bringing a simple web-based interface to support database administration, utility management, performance, etc. The idea is that you’ll be able to capitalize on your investment in the DB2 tools space with DSM as the driver.

IBM is updating the base edition of DSM every 3-6 months, and plenty of the new features are designed for those of us who work in z/OS environments. With the latest round of enhancements, IBM is delivering greater integration with additional core products such as DB2 Query Workload Tuner, DB2 Query Monitor and the DB2 Utilities Solution Pack. There is continued focus on program development with the capability to write, test and tune SQL as well as stored procedures.

Highlights include:
  • The capability to migrate workloads from DB2 Query Workload Tuner 4.1.x to DSM.
  • First stage of integration on z/OS with DB2 Query Monitor.
  • The capability to tune single SQL statements or workloads with DB2 Query Monitor CAE Web Client.
    • After examining monitored SQL statements with the DB2 Query Monitor Consolidation and Analysis Engine (CAE) Web Client and storing them in generic staging tables, you can now capture a query workload and transfer it to DSM with complete metadata and no size limitations. DSM can retrieve problematic statements programmatically for query workload tuning. Query Monitor and Query Workload Tuner can also be used to tune single SQL statements.
  • New Improved Access Plan Graph (APG).
    • The UI has been optimized, the toolbar has been redesigned, and all the view-switch buttons are replaced by icons and placed in the right corner. The integrated panel has also been redesigned (it's now hidden by default) and can be displayed on demand. The graphic view toolbar has been refined with a brand new vertical layout.
  • The user experience has been greatly improved around editing, executing and displaying results from SQL and Stored Procedure.

DSM continues to expand and provide a common web-based UI as seen with the integration with the Utilities Solution Pack. Features include:
  • Customizable profiles for identifying object situations and generating resolving JCL (reorg, copy, runstats, etc.).
  • Automatic prioritization of object situations and their resolving actions.
  • The capability to define maintenance windows for enabling active autonomics, allowing DB2 to self-manage utility runs.
  • Notification support (email, text, WTO) on selected autonomic events.
  • Graphical trend analysis of historical RTS.
  • Capture of utility history, recording utility output, time, duration, etc.

Go to the Release Notes page to learn more and to download the latest release.

Also note that IBM is hosting a DSM webinar on May 3. “IBM Data Server Manager on z/OS” is presented by the internationally known Saghi Amirsoleymani. Register here.

Posted April 19, 2016| Permalink

comments powered by Disqus