Bookmark and Share
RSS

Recent Posts

The Latest on Data Server Manager

February 13, 2018

I'm just back a week at the Db2 for z/OS Silicon Valley Lab (SVL), where we discussed z Analytics products. One of the sessions I really enjoyed was the hands-on lab for Data Server Manager (DSM). This recently updated solution has lots of new features to help administer, monitor, manage and optimize not just Db2 for z/OS, but the entire Db2 family (Db2 for z/OS, Db2 for LUW, Db2 on Cloud, Db2 Warehouse on Cloud, Db2 Warehouse Private).

The latest DSM release is version 2.1.5. I've gleaned information about the new features and enhancements:

Object Management

  • In addition to the New, Modified, and Deleted columns displayed on the DSM Tracking changes page, a new Base column now displays the number of objects recorded for the first time by DSM, as well as those that have not changed, during the specified time frame. This new column enables users to set a baseline for changes made to any database objects during a time frame.
  • When administering schemas, users can now generate DDL statements for all the objects in a single schema.
SQL Editor
Users can now run one set of SQL statements against multiple databases simultaneously, using a new Run menu option.

DSM Utilities
Users can now administer connections or user information by using the following new batch processing commands:

  • Administer connection profiles with tags, using the upddbprofile command.
    NOTE: Users can only tag connections from within the DSM console.
  • Update the password for multiple connection profiles with specific tags and the same user ID, using the upddbcredential command.
  • Create multiple user IDs, using the usermgt command.
  • Export user privileges for a group of connection profiles that share the same tags, or all users and their mapping privileges, to a .csv file, using the privilegemgmt command.
Enhancement for Index Advisor (for QWTz users)
QWTz has improved the usability of its Index Advisor tool, by providing users with more information from which to evaluate index recommendations:
  • The advisor now displays existing index information
  • The advisor now supports access plan comparison, and the ability to review a revised access plan for Test Candidate Index analysis
  • The advisor now supports index impact analysis for Test Candidate Index recommendations. Test Candidate Index analysis allows you to test your own custom hypotheses for index recommendations, on single queries or workloads. By integrating index impact analysis support on Test Candidate Index recommendations, you can test the impact of the Test Candidate Index analysis at the packages/plan level, Dynamic Statement Cache level, or against a custom defined workload.
Accelerator Management
  • Users can view the status of all their Accelerators from a single dashboard.
  • Users can drill-down to any Accelerator to view detailed diagnostics, monitoring information, and trace configurations, and perform the following table and query management tasks:
    • Add/Load Tables from IBM Db2 for z/OS to the Accelerator
    • Remove table references from the Accelerator
    • Alter distribution/organizing keys
    • Synchronize table data between IBM Db2 for z/OS and the Accelerator
    • Archive/Restore partitions between IBM Db2 for z/OS and the Accelerator
    • List and cancel long running tasks.
  • Users can monitor accelerated queries from the query dashboard for an Accelerator. Supported query monitoring functions include:
    • View the SQL
    • Re-run a query
    • Post explain graph view
    • List and/or cancel executing queries
There's much more at the link above, including information about previous DSM 2.1.x releases. Incidentally, if you'd like to suggest a new feature be brought to DSM, use the official RFE (Request for Enhancement) system. You can also vote on other suggestions. This feedback will help determine priorities for future development.

Analytics Platform RFE Community
One feature that has yet to make it into DSM is the capability to manage stored procedures (something that was in Data Studio). Numerous customers have told me that they can't move off of Data Studio until this feature is delivered in DSM. So if you're in this situation, you should definitely use the RFE system to register your opinion.

Posted February 13, 2018 | Permalink