IBM Data Server Manager Version 2.1.x releases: new features and enhancements
This document describes the new features and enhancements in Version 2.1.x of IBM Data Server Manager.
To download the latest modification of IBM Data Server Manager, go to Fix Central.
For new users, download IBM Data Server Manager from developerWorks or Passport Advantage.
For information about how to upgrade or install the latest modification, go to Installing and upgrading IBM Data Server Manager.
Data Server Manager supports running and scheduling different types of jobs. Those two types of jobs, Key/Value script and Data Migration, are no longer supported after DSM v2.1.5. Key / Value pairs will also no longer be kept and tracked in the repository. The Data Migration job is used to move data from one storage group to another. You can use an Executable/Shell or Db2 SQL script job to issue the ALTER TABLESPACE statement to do this. See more from Db2 Knowledge Center about how to set up data migration with multi-temperature storage groups.
The latest release of IBM Data Server Manager (DSM) contains many new features to manage, monitor and tune Db2 family databases.
DSM continues to integrate deeply with the security infrastructure and practices of your Enterprise, now supporting even more user specific scenarios and standards. Tuning now includes advances in index tuning, workload capture, and Query Monitor Integration. In addition, DSM now supports scripted connection and user management, and enterprise users of DSM can now manage Analytics Accelerators that are paired with Db2 for z/OS subsystems.
Enterprise Monitoring and Management
- For Real Time Package Cache monitoring, users can now choose to normalize captured SQL statements. Literals are replaced with a question mark (?). This consolidates common statements together and provides an additional level of data security by masking potentially sensitive data.
- Users can now get the status of remote tables when monitoring a federated database, in both real-time and history mode. Status information can include the number of rows that have been modified, inserted, updated, or read, for both in-flight or package cache statements. The detail information for remote tables can be displayed on the following views:
- Statements > In-flight executions in real-time mode
- Statements > Individual executions in history mode
- Statements > Package cache in both real-time and history mode
- Statements > Stored procedures in real-time mode
- Applications > Connections in both real-time and history mode
- Users can now change the monitoring profile used to monitor Db2 Warehouse on Cloud and Db2 on Cloud databases to suit their unique requirements.
- 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.
Users can now run one set of SQL statements against multiple databases simultaneously, using a new Run menu option.
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.
See Securing IBM Data Server Manager for more information on how to secure your DSM environment.
- DSM has withdrawn support for the TLSv1.0 and TLSv1.1 cipher suites, as they utilize the SHA-1 signature algorithm, which has been found to be prone to collision attacks. Users can, however, continue to use TLS1.2 to connect to their DSM server from a web browser.
- Users can now choose whether or not to save the operation credentials into the DSM repository database. If the value of operation.credentials.save.to.repository in the dswebserver_override.properties file is changed to false, then the Save credentials to repository check box is removed from the console. See Disabling the saving of operation credentials for more information.
- If DSM is using repository based authentication, and a Db2 for z/OS database is used as the repository database, user IDs must be explicitly added into DSM and granted with privileges before they can be used for logging into DSM.
Query Advisor and Access Path Advisor now available as tuning options
- Generate query revision recommendations: launches either the Query Advisor or Workload Query Advisor to find structures in a query that are likely to cause the optimizer to choose a sub-optimal access path. The advisors use a combination of rules and best practices to calculate their recommendations, which you can use to rewrite the query to resolve problems.
- Generate access path recommendations: launches the Access Path Advisor to examine the access plan selected by the optimizer and to identify common access path issues. The warnings that this advisor provides can help you to understand where to look for trouble in an access plan graph or in the Access Plan Explorer.
Enhancement for queries and workload capture
- A global option is now available for setting the SQLID and default Schema
- Users can now enable IFCID 316, 317, 318 traces, for collecting performance metrics from the dynamic statement cache
- Filtering by table or index object is now supported for Packages data sources, when the underlying package is bound with EXPLAIN information
- Access plan comparison is now supported for Packages data sources.
- The tuning wizard is now capable of generating JCL scripts or commands from the SQL Editor, for collecting EXPLAIN plans for Packages that did not bind with EXPLAIN YES.
Enhancement with Db2 Query Monitor (QM) integration (for QWTz users)
- Users of QM can now call IBM Db2 Query Workload Tuner for z/OS (QWTz) tuning functions for tuning both single static and dynamic SQL statements, as well as workloads. In addition, when using the DSM integration, QM users now have the option of specifying the SQLID for the EXPLAIN table, in the event that it is not the same as the connection user name.
- The enhanced Selectivity Override function (designed to helps users improve query access plans for dynamic queries with parameter markers) now supports tuning of static statements on Db2 for z/OS Version 11NFM or above. With this function, QWTz sends a selectivity override hint to the optimizer, to help improve the access plan with run-time host variable values information. This can greatly improve static SQL with skewed host variable predicates.
See Overriding predicate selectivities at the statement level in the Db2 for z/OS Knowledge Center to learn more.
- The QWTz operation credential now supports tuning services.
- The following QM APARs are prerequisite, in order to get all the latest functions: PI89058 and PI89061.
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.
Db2 for z/OS Administration support
Users of DSM can now manage IBM Db2 Analytics Accelerator for z/OS (Accelerator) installations that are paired with a given IBM Db2 for z/OS subsystem:
- 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
Enhanced IBM Db2 Automation Tool/IBM Db2 Autonomics Director for the DSM console
The following enhancements are now available:
- Basic support for manual building of automation tool job profiles.
- New DB2 Administration Task Scheduler view, from which users can see and delete tasks.
- Support for the SORTDEVT and SORTNUM to RUNSTATS utilities.
- Improved performance from making past performance window data for a specific maintenance window available for review.
- Additional column values now appear in the Utility History screen, indicating whether the utility job was submitted autonomically or manually.
- Multiple fixes and usability improvements to the Subsystem Autonomics and Subsystem Dashboard pages, including:
- Improved error reporting
- Updated help content
- Better profile filtering
- Improved usability
Enterprise Monitoring and Management
IBM Data Server Manager lets you see the status of all your IBM Db2 for Linux, UNIX and Windows and dashDB data servers from a single pane of glass. Now you can easily identify data servers that need your attention, tag and group them according to your business requirements, and create custom views to get you back to exactly what you need to see in seconds. Managing hundreds of data servers is easier than ever before.
Making sure that your database is fully protected is an important part of every DBA's job. With the new release of IBM Data Server Manager v2.1.4 we have built up the LDAP security features introduced in the last release and now support Kerberos authentication and allow DSM to support multi-factor authentication. See Securing IBM Data Server Manager.
With Db2 Version 220.127.116.11 IBM Data Server Manager lets you access data from remote IBM and non-IBM databases with a few clicks. Remote tables look and act like local tables with the help of Data Server Manager. Optimization of statements that include remote data is easy with visual explain and extensive monitoring in Data Server Manager. Data Server Manager 2.1.4 adds support for many new remote data sources.
New tuning features introduced in this release include many usability enhancements to make the tuning of individual and workload queries much simpler. New filters have been enabled to make capturing data for tuning much quicker and easier. An enhanced Compare Access Plan feature allows you to show differences between the original and new access plans after what-if index analysis. There is also an improved Index Advisor tool in this release.
Enterprise Monitoring and Management
- Read the current value, normal range, maximum and minimum value range, possible maximum and minimum value, and trend for each displayed metric. Also, the Data Sever CPU KPI metric is added into home page.
- Group databases by Name (the default view) Host: port – instance , Data server type and version, high availability status, and Cluster (for monitored databases in clustered configurations, such as Db2 pureScale).
- View all available databases, only those with critical alerts, or only those that match custom filtering rules that you define. Filter the database view by adding or removing specific metrics.
- Set the refresh period for displayed database states, alerts and metrics. Available values range from 5 to 300 seconds, with a default period of 60 seconds. User can also manually pause or refresh immediately.
- Customize the visible metrics to show only those metrics that are important to users.
- Find the databases to which you are connected by entering a name, data server type, host or port number in the search tool.
Detect problems faster from the new card view
IBM Data Server Manager (DSM) has improved the card view, utilized by the Home page, to provide users with a better way to analyze the metrics of their monitored databases. Users can easily get the health status for all databases by analyzing alerts and performance metrics for each monitored connection, all from one dashboard.
User can easily:
Filter displayed databases with tagging and favorites
- Allow users to group databases connections by tag
- Provide a flexible way to monitor multiple connections that have the same tag
- Allow users to associate different connections easily
- Provide more context for connections in alert notifications
- User can add the most important database connections to a favorites list for easy management and tracking
- A summarized overview of connections is now available in the favorites list
- Save the current databases group type, sort key and type, filter rules, and selected metrics to a new view. The user can then quickly go back to the view at any time.
- Switch between different views easily. The default view is All Connections.
- Delete a view
- Disconnected—displays metrics related to the overall status of the user's disconnected databases. Users can choose to filter the list of disconnected databases by toggling options for unavailable connections, invalid credentials, and/or invalid connections.
- Not monitored—displays metrics for those databases not being monitored. Users can choose to filter the list of not monitored databases by toggling the following filters:
- Monitoring off—show/hide those databases that have monitoring deactivated in their monitoring profile.
- Monitoring is disabled—show/hide those databases that have data collection disabled in their associated connection profile.
- Blackout active—show/hide those databases that have monitoring temporarily disabled due to a scheduled blackout.
- Monitoring profile deactivated—show/hide database connections whose monitoring profile has been deactivated.
- Unsupported server version—show/hide connections to databases whose server type or version does not support monitoring through DSM.
- With alerts—displays alert messages, by alert group type or Alert severity, for databases whose states have exceeded thresholds that you have set for alerts. Related metrics are also displayed, and users can choose which metrics to display from a drop-down menu.
Users can now filter the display of databases on the Home page views in a variety of ways:
The Create views feature allows users to customize, save, and switch between different snapshots of the Home page. User can easily:
Summary views include:
Define or alter a workload with collection activity data
When creating a workload, users can now select the collection activity data option from the Overview page, to resolve performance issues.
Improved usability of Overview dashboard controls
Users can now focus on time frames where the most database activity has occurred, using the enhanced time-slider control. Users can click the arrow controls at the extremes of the time slider to change the displayed time span, giving users the ability to move easily between different historical views.
Statement History Enhancement for MPP
Users can see individual statements for each member.
Enhanced Log full alert
Log full alert is an critical alert type directly related to availability because log full condition can block all transactions of database. When this alert generated, it's important for DBAs to pinpoint the problematic application which maybe the root cause of this problem. And now the enhancement of this alert can help to do this by displaying the handle and name of the application that holds the oldest active transaction. What's more, not only can DBAs see the application handle and name in log full alert details but also free-up log space by applying a 'Force Application' or 'Cancel Activities' operation against the problematic application.
DSM now provides two groupings for alerts, Availability and Performance. Users can choose to organize alerts by either of these groups, or create their own custom alert groups. With this feature, users can have a more meaningful and valuable summary view of the alerts in Home page.
Enhanced Alert notifications
Users can now send different alerts to specified receivers by Email, SNMP or both as they like in a more flexible way. User defined alerts notification is also supported. Besides, users can select alerts for notification easily with tree view and the search function. Through the connection's monitoring profile, users can define multiple notification rules for controlling where specific alerts are sent.
DSM now can also detects the backup pending state of the monitored database and then generate an alert to get DBAs notified and taking actions accordingly.
DSM provides users with several restful APIs for retrieving alerts information. Users can integrate DSM alerts information into their own system, or consume it in other application.
DDL generation enhancements
Support Generate DDL for bufferpool, tablespaces and storage groups.
Review and customize DSM migration DDLs at z/OS repository
The configure JCL can be downloaded from the product setup page. This makes it easier to review all DDL statements. The DDL for table spaces, buffer pools can be customized to follow company's IT standards.
Customize encryption mechanism
- Enable operation— provides the credential for the current DSM user to perform operational access to DSM (perform administration functions, tune databases and run queries against the connected database). The user can choose to save this credential to the repository database, or let it be cleared after the user logs out of DSM. For convenience, users can also update this credential through the User icon, next to the database selector, without having to go through the Connection dialog box. This operational credential will only apply to the current user and will never be shared with other users sharing the same connection profile.
- Enable data collection—provides users of the connection profile with data collection privileges for the connected database, allowing them to monitor databases on the connected server and create alerts.
DSM now provides a customized encryption option, allowing DSM administrators to better protect their DSM user's passwords.
Current DSM user passwords are encrypted by the same key across all DSM installations. DSM can now generate a new key per installation. With the encryption key now being installation-specific, the key from one DSM installation cannot be used to decrypt information from another DSM installation. A new utility allows a DSM administration to convert to this installation specific key for better protection of their encrypted content.
Separate connection profile credential for Admin/Tuning/Monitoring
DSM administrators can now create connection profiles that control a user's access to specific DSM functions. To facilitate this change, the Add Database Connection window has been augmented to include two new credential options:
When creating the connection profile, DSM administrators can choose one or both options by clicking the appropriate check boxes at the bottom of the Database Connection tab page.
DSM Authentication using a repository database to handle Kerberos Authentication
Users can now delegate DSM user authentication duties to a repository database. In this mode, any repository database user that has been assigned the DSM role can log in to DSM. For example this allows DSM users to be authenticated through Kerberos.
2FA authentication in JDBC connection - Db2 for z/OS database
DSM now provides one-time password authentication (one kind of two-factor authentication) when performing administration or tuning tasks on Db2 for z/OS databases. With one-time password authentication enabled, the underlying connection will be shared, eliminating the need to create a new connection during the operation life-cycle.
IBM LDAP Tivoli Directory Server support
DSM now supports the use of IBM TDS for LDAP authentication.
Several new data sources are added as federated data sources when connecting with latest Db2 v18.104.22.168. The complete list is shown as below:
- Apache Hive - new
- Cloudera Impala - new
- IBM BigInsights
- IBM Db2 for Linux, Unix and Windows and IBM dashDB
- IBM Db2 for z/OS
- IBM PureData System for Analytics (Netezza) - new
- Microsoft SQL Server - new
- Oracle (using ODBC client) - new
- Oracle (using NET8 client)
- JDBC (generic data sources)
- A more common method for column and row filtering
- Display tuning results by clicking a link within the JOB NAME column
- Check box controls for selecting entire rows
- A quick search tool for locating jobs by job name and connection name
- Close, Close others and Close all by right-click on the tabs
- Db2 dynamic statement cache
- Db2 packages and plans
- User-defined repository
- Users can now check statements directly affected by index recommendations, as well as corresponding statement information, such as the package name and collection name.
- Users can check the table information related to the index recommendations to quickly identify which tables and index recommendations need the most consideration.
- Users can now review how existing indexes are currently used, and compare them with new index recommendations.
Improved display of tuning results
The Tuning Jobs page now includes the following enhancements for better usability:
Enhanced data capture for the DSM Tuning Wizard
Users can now manage filters they have created for capturing data for tuning, using the DSM Tuning Wizard. By clicking the Manage Filters link, users can edit, copy, or delete existing filters, or create new ones. This option is available for the following data sources:
Compare access plans quickly and easily when optimizing tuning jobs
When optimizing an index for tuning, users may try to create multiple indexes virtually to compare the optimized access plan against the original one.
DSM now provides users with a Compare Access Plan button that, when selected from the what-if analysis result page, generates a single query access plan comparison report, identifying to the user the differences between their original query access plan and the new access plan created with virtual indexes.
Improved index advisor
DSM has improved the usability of its Index Advisor tool, by providing users with more information from which to evaluate index recommendations:
Db2 for z/OS Administration support
Enhanced IBM Db2 Automation Tool/IBM Db2 Autonomics Director for the DSM console
- Significant performance improvements when rendering large result sets, resolving search filters, and scrolling through tables. Infinite scrolling ensures that data fetching is fast and supports mobile access.
- The autonomic type for a given job is now displayed on the Utility History page, identifying whether it was run autonomically or passively.
- The action execution history within a given maintenance window is now displayed, grouped by maintenance period.
- Row counts for a given page are now available, along with the number of rows returned from an applied filter, and the total number of unfiltered rows.
- Support of the RTS Snapshot history feature within the Db2 Automation Tool object profiles, eliminating the need for LISTDEF object profiles.
- Multiple fixes and usability improvements to the Maintenance Windows, Utility History, and other Autonomic Dashboard pages, which include improved help content, better filtering, improved usability, and bug fixes.
- Step-by-step quick tours of common DSM tasks help to get users up and running with the console in a matter of minutes.
- Functional areas covered by quick tours include:
- Set up and configuration
- Monitoring databases
- Administering and configuring databases
- Executing and optimizing SQL statements
- Quick links to take users to key console pages where they can perform common tasks
- Accessible online help on each page, to provide answers when users need them
- Check each monitored database in card view.
- Find the average value and the deviation for the current value by graphic markers.
- Group databases by name (the default view) host: port – instance, data server type and version, high availability status, and cluster (for monitored databases in clustered configurations, such as DB2 pureScale).
- Filter displayed databases using tools launched from the command bar. Users can filter by database properties, critical alert types, or by adding and removing specific metrics from view.
- Set the refreshing period for displayed database states, alerts and metrics. Available values range from 5 to 300 seconds, with a default period of 60 seconds. User can also manually pause or refresh immediately.
- A Useful links menu on the command bar allows users to jump instantly to key console pages, such as Blackout Events, Monitoring Profiles, or Manage Connections.
- The addition of Notifications and Manage Clients dashboards for DB2 for z/OS to the Monitor > Database page
- The removal of the Alerts option from the Monitor menu on the navigation bar, replaced by the Notifications dashboard
- The renaming of the Workload dashboard to Throughput dashboard, to more closely associate workloads with the DB2 workload manger
- The removal of the Database Time breakdown dashboard, to reduce duplication with the Overview dashboard
- The moving of the Units of Work dashboard to the Applications drop-down menu
- Support to customize threshold for table space state and index space state, when connected to DB2 for z/OS databases
Get things done faster
IBM Data Server Manager (DSM) version 2.1.3 continues to improve the user experience with its
Download and Go design and intuitive graphic user interface (GUI).
Task oriented welcome page for high efficiency
Card view metrics
The new Card view provides users with a better way to analyze the metrics of their monitored databases. User can easily get the health status for all databases in one dashboard.
Displayed properties include database name, alerts and performance metrics.
User can easily:
Redesigned monitoring dashboards
IBM Data Server Manager has completely redesigned its database monitoring user interface. Dashboards and other labelling have been redone to improve clarity, options have been moved to more intuitive locations, and more complex workflows have been simplified.
Some specific improvements include:
- Table spaces
- Remote Tables
- Improved support for DB2 Version 12 with new or modified fields included in the RECOVER and MODIFY RECOVERY utilities.
- New profile management support for DB2 subsystems that are members of a data sharing group.
- Improved layout and simplified user experience for creating and managing profiles, as well as better search and filtering capabilities.
- Updated Action Registry and Symptom Registry screens (formerly called Action Priorities and Symptom Severities) to reflect changes and enhancements to the various autonomics options.
Admin privilege enhancement
DB2 for Linux, UNIX, and Windows (LUW) users can now manage privileges directly through the object explorer view of the following object types:
See Privileges Required for the ID used by Data Server Manager in the DSM 2.1.x Knowledge Center for more information on privilege assignment for both DB2 for LUW and DB2 for z/OS database environments.
Remote Cloud storage for database backup and restore
DSM v2.1.3 allows users of DB2 V11.1 for Linux, UNIX, and Windows(LUW) databases to manage backup and restore operations to a remote cloud-based storage service. DB2 v11.1 databases support backup and restore to remote storage on IBM® SoftLayer® Object Storage or Amazon Simple Storage Service (S3), providing users with an agile, on-demand, and economic storage option for their backup and restore operations. DSM v2.1.3 adds UI support to help users manage this functionality easily from the console.
See Accessing and using remote cloud storage services with DSM in the DSM 2.1.x Knowledge Center for more information on using DSM to configure your database for remote cloud storage.
LDAP Authentication in DSM now extends to support Microsoft Active Directory. Administrators can also configure DSM to use multiple LDAP entries. DSM supports both anonymous and simple authentication configuration on the LDAP server. See
Managing administrator accounts with LDAP in the DSM 2.1.x Knowledge Center for more information on configuring LDAP authentication with DSM.
Customized session time out
DSM server now supports customized session time out, allowing administrators to set the idle time that occurs before a DSM session time out requires users to log in again.
See Managing session time out in the DSM 2.1.x Knowledge Center for more information on how to modify the default session time out value.
Users can now use the
Workloads page to define workloads by different connection attributes, and to review existing workload definitions. They can then jump to the
Overview page to analyze the performance of their monitored database, all workloads, or individual workloads.
Query and script building
Users can now re-use a single database connection to run different statements and scripts in multiple transactions, using the SQL Editor.
Users can manage scripts with simple in-cell clicking.
Enhanced IBM DB2 Automation Tool for z/OS console
The latest release of the DB2 Automation Tool for z/OS, version 4.3, is now available as part of the DB2 Utilities Solution Pack for z/OS V4.1. The Automation Tool has been updated with the following features:
Refer to the product's Program Directory document for detailed installation instructions.
Better user experiences when capturing queries and workloads
DSM now provides a tuning wizard to facilitate the workflow of SQL and workload capturing. This new tool clearly defines the steps of capturing:
- Select a data source
- Define the scope
- Choose options
Capture SQL statements from multiple files
DSM users can now capture SQL statements from multiple files when running the tuning wizard against a DB2 on z/OS or DB2 for LUW database. By choosing Optimize > Start Tuning and selecting the Files tab from the tuning wizard, users can browse to local or network files to for tuning. Options are also available for setting a statement terminator, an encoding format (e.g. UTF8) and a default schema.
Enhanced comparison of workload access plans for displaying all non-matching statements
DSM can now display all non-matching statements in the workload access plan comparison report. With this enhancement, users can easily identify statements that are not comparable between two workload tuning jobs. Users can use this information to determine if changes were applied to SQL statements during application development.
Capture dynamic statements from a data sharing group
When tuning queries sourced from a DB2 on z/OS database, users can now capture dynamic statements from the members of a data sharing group. Using the new tuning wizard, users can enable the Capture from data sharing option and select data sharing members from a list.
This feature will run the EXPLAIN CACHE ALL command against all the selected members and consolidate all statements in each member's dynamic statement cache as the captured result
Export to J CL
DB2 for z/OS customers can now save tuning recommendations locally as Job Control Language (JCL) files. These files can then be run from a DB2 for z/OS command line console as needed. An
Export to JCL button now appears on the
Tuning Results page for any of the following job types:
- Indexes Advisor
- Workload Indexes Advisor
- Test candidate index
- Workload Test candidate index
- Statistics Advisor
- Workload Statistics Advisor
- Selectivity Override Analysis
Monitoring and alerts
- Supports dynamic switching between the local time zone or database time zone
- Remembers a user's last choices
- Applies to all GUI elements, such as the time slider, monitoring grids and monitoring charts.
- Throughput Connections Summary
- Throughput Member Summary
- Throughput WLM Workload Summary
- Throughput WLM Service Class Summary
- Instance Memory
- Database Memory
- Buffer Pool
- Table Space
- Package Cache
Toggle between local and database time zones
Users can now view monitoring data in either their local time zone or the database time zone
More historical charts added or updated
IBM Data Server Manager has added several historical charts, and updated others, to enhance historical monitoring. By analyzing the differences and commonalities between these charts at different points in time, users can better identify performance trends and the source of issues when they arise.
The following charts have been added or updated:
SNMP V3 alert notifications
Users can configure DSM to receive SNMPv3 trap notifications from a pre-configured SNMP server, providing secure user authentication and encryption support. By accessing the
Product Setup page, users can enter the host name, port, and user name associated with their SNMP server, then enable DSM to receive trap notifications, through their monitoring profile.
Specific enhancements to DPF, HADR, and PURESCALE console pages
- A new chart has been added to show key metrics, such as CPU ,IO , and SORT, with AVG, MIN, and MAX values added to enhance these values.
- New bar charts have been added to show the trend of data for DPF members, and users can view the data skew that is based on it.
Console pages have been redesigned for DPF, HADR, and PURESCALE monitoring, with additional charts and more useful metrics, to enhance usability and functionality.
IBM Data Server Manager Version 2.1.2 offers improved navigation.
- changing the order of listed databases by clicking a column heading.
- filtering displayed records using tools launched from the command bar. Users can filter by database properties, by critical alert types, or by adding and removing specific metrics from view.
- grouping database records by Name (the default view) Host:Port – Instance, Data Server Type and version, and Cluster (for monitored databases in clustered configurations, such as DB2 pureScale).
- setting the refreshing period for the displayed database status, alerts and metrics. Available values range from 5 to 300 seconds, with a default period of 60 seconds. User can also manually pause or refresh immediately.
- a new Useful links menu on the command bar that allows users to instantly jump to the Blackout Events page, the Monitoring Profiles page, or the Manage Connections page.
- The Database time breakdown chart now combines five metrics (I/O, Lock waits, SQL processing, Other processing and Other waits) into one line graph, allowing users to see how the peaks and valleys of each metric correspond to those of the others at points in time. As users hover their mouse pointer over the graph, a pop-up box provides a percentage value of each metric at that moment in time. A zoom control at the bottom of the chart allows users to focus on a smaller time frame.
- Charts for other key metrics now display their values with improved graphics. By hovering their mouse over points along each line segment, users are presented with a timestamped description of the normal range for the selected metric.
- Key metrics can now be toggled on or off from the new Metrics Filter control, located on the command bar. Users can show/hide charts for key metrics by simply selecting or clearing associated check boxes from the drop-down list.
- Two new key metrics are now available:
- Transaction rate: the number of transactions completed per second
- Average activity time: the average database response time for all activities, including SQL execution, I/O, and lock waits
New grid view for Home page
In contrast to the tile view that users of IBM Data Server Manager are used to navigating, the new grid view displays each monitored database as a row in a table. Displayed properties include the database name, current status, alerts, and performance metrics.
Features of the new grid view include:
More intuitive Overview page for Database Monitoring
The Data Server section of the Overview page is now more intuitive, providing users with an easy-to use, yet comprehensive, database monitoring experience:
- Manage DSM user credentials and DSM user privileges: In this mode, both user credentials and user privileges (Administrator or User) are managed from the LDAP side. Any new user creation or privilege assignment must be done from the LDAP side as well. DSM Administrators can choose an LDAP group to represent DSM Administrators, where membership grants administrator access to DSM.
- Manage DSM user credentials only: In this mode, only user credentials are managed in LDAP. The DSM Administrator privilege is still managed by DSM.
- View and manage the overall health of DB2 for z/OS systems across the enterprise.
- Navigate and drill down from the enterprise or system level to individual objects. You can view, understand, and access identified DB2 for z/OS symptoms and recommended actions.
- View resource dashboards that consolidate information from various sources and tools with data sharing groups and individual table space and index space partitions.
- Discover resources with the highest severity symptoms and actions, and navigate directly to those resources.
- Reduce the learning curve and get new system programmers and database administrators up and running faster.
- Data sharing groups
- Table spaces
- Table space partitions
- Indexes spaces
- Index space partitions
- Table spaces. If a table space is partitioned, charts are available only for the table space partitions.
- Index spaces. If an index space is partitioned, charts are available only for the index space partitions.
- Creating LISTDEF-based object profiles.
- Creating real-time statistics (RTS) snapshot job profiles to run RTS snapshots for LISTDEF object profiles.
- Adding schedules, if DB2 for z/OS administrative task scheduler is set up and running.
- RTS history data is captured by the snapshot job profiles and viewable on the RTS history charts on the Subsystem Dashboard.
- Create maintenance windows and specify time intervals.
- Fully manage (view, create, edit, delete) object, utility, exception, and job profiles with a new, expanded web-based interface, without having to use the ISPF interface.
- Monitor symptoms and actions from the Subsystems Dashboard page with a new widget that populates when a job profile associated with a given maintenance window is built.
- Set priorities for symptoms, to ensure those with higher priorities are processed before others.
- Set the priority of related actions, objects, and symptoms, to ensure the most important or critical conditions are resolved first.
IBM Data Server Manager can now be configured to use LDAP authentication. Credentials validation and DSM user privilege assignment can be delegated to an Open LDAP or Apache Directory server. DSM Administrators can configure DSM to use LDAP for user management in the following ways:
IBM Data Server Manager now supports the monitoring of DB2 pureScale configurations. Users can now add connections to other pureScale members and CF nodes automatically, when adding a connection to a member node in a pureScale cluster.
IBM Data Server Manager now supports the monitoring of DB2 pureScale with HADR configurations. Users can now add connections to other pureScale members and CF nodes as well as all HADR standby members and CF nodes automatically, when adding a connection to a member node in a pureScale with HADR cluster.
IBM Data Server Manager now supports DB2 Fluid Queries, a technology that allows users to connect to remote tables that look and act like local tables. Once a connection to a remote table is created, users can use the Generate DML command to create SELECT, INSERT, UPDATE, or DELETE statements that include all of the table's properties. The newly generated statement is presented in the SQL editor, allowing users to edit the statement as needed before executing it.
Users can edit the properties of their remote table connections, or remove them, as needed.
Data Server Manager can now act as the administration and monitoring console for a number of dashDB products. By establishing a connection to a dashDB Local, dashDB for Transactions, or dashDB for Analytics database, Data Server Manager automatically reconfigures its feature set to compliment the selected database type.
IBM Data Server Manager now supports the following activities for the management of DB2 for z/OS subsystems:
To enable the complete autonomic capabilities, acquire the DB2 Utilities Solution Pack for z/OS Version 4 and install and configure the following components: Autonomics Director for DB2 for z/OS; DB2 Automation Tool for z/OS; Utilities Enhancement Tool for z/OS.
Autonomics Director for DB2 for z/OS enables the following capabilities:
DB2 Automation Tool for z/OS enables the following capabilities:
The Utilities Enhancement Tool for z/OS captures the history of the utilities ran for all the resources and presents in the Utility History widget on the Subsystem Dashboard.
- Select multiple saved SQL statements, or templates, from your catalog for insertion into an open query, or to replace the contents of the SQL editor window. Check boxes in the Saved Scripts window now allow users to make multiple selections for insert and replace operations.
- Display multiple result sets from one query in the results window at one time.
- Save a script to an existing script to update the content.
Enhanced SQL editor
The SQL editor now offers users several enhancements over previous versions:
- Easily identify and review connections to databases on pureScale with HADR nodes to confirm the status of your high availability service.
- Monitor databases within both Primary pureScale cluster and Standby pureScale cluster nodes in a pureScale HADR cluster.
- Automatically add connections to all Primary and Standby nodes (and their associated CF’s) when adding a connection to a Primary member node in a pureScale HADR cluster.
- Display tiles by cluster on the Home page, using the primary member tile sorting, shown items, and Sort by controls.
- Drill down to the Monitor > Database > Overview > PureScale-HADR page to view the health status of nodes in your PureScale HADR cluster.
- See alerts of issues occurring in your PureScale/HADR cluster, as they happen, on the Monitor > Database > Overview page.
- Display tiles by cluster on the Home page, using the member tile sorting, shown items, and Sort by controls.
- Automatically add connections to all pureScale member nodes (and associated CF’s) when adding a connection to one member node in a pureScale cluster.
- Two new metrics charts are now available through the new Metrics filter drop-down list box, located on the command bar of the redesigned Monitor > Database > Overview page:
Federation rows indicates the number of rows retrieved by the Federated server from a remote server
Federation waits indicates the number of lock waits taken by an execute statement to get a result from a remote server
- Several new metrics have been added to the list of available columns on the Monitor > Database > Statements pages:
- Federation rows deleted
- Federation rows inserted
- Federation rows updated
- Federation rows read
- Federation wait time
- Federation total numbers of wait
- Average Federation rows deleted
- Average Federation rows inserted
- Average Federation rows updated
- Average Federation rows read
- Average Federation wait time
- Average Federation total numbers of wait
- Three new metrics have been added to the Top Consumers matrix on the Monitor > Database > Applications page:
- Federation rows read
- Federation wait time
- Federation waits
Collect historical data for the following utilities:
pureScale with HADR
IBM Data Server Manager now provides monitoring and alert services for pureScale with HADR configurations of IBM DB2 V10.1 (and above) for Linux, Unix and Windows:
Federated DB2 databases
IBM Data Server Manager support for DB2 Federated databases has been further enhanced to include monitoring through the Database Monitoring page.
Query and script building
- the Run menu: In addition to the Run all, Run selected and Run from cursor commands, we have added a Run and export option, allowing users to export the results of one or more queries in either CSV or Microsoft Excel (xlsx) format. This new menu also includes the Schedule, Explain, and Tune options from previous versions of DSM.
- the Script menu: Combines the following tools into one drop-down menu:
- the Syntax assistant
- Open from client
- Save and Save to client
It also includes an option that launches the new Saved Scripts pane, allowing users to review their saved scripts and insert selected scripts into the Editor window. Additional options include:
- Share/Unshare: toggle the availability of a script to other users
Users can also view the results of scripts they have run by clicking the Result tab, adjacent to the Saved Scripts tab.
- the Edit menu: Includes the Format and Find/Replace commands from previous versions, along with Undo and Redo options.
Enhanced SQL editor
IBM Data Server Manager has made creating SQL statements faster and easier. Users can now select from a list of predefined SQL statements, which they can use as templates for creating their own queries. These templates are selected from the new Favorites menu, launched from the SQL Editor command bar. Available statements include:
Users can also choose from a SQL stored procedure template and a User defined function template.
When a user saves a query it is automatically included in a list of saved scripts (see Saved Scripts below) that can be launched by expanding the hidden frame at the bottom of the edit window. From here, users can insert scripts, rename them, or choose scripts to add to the Favorites menu. Users can also change the grouping of their Favorites menu options by assigning scripts to different categories in the Saved Scripts pane.
Users can also view a history log of script executions that includes details of the success or failure of a script execution. Logs can be saved as text files.
Improvements have also been made to the grouping of tools on the SQL Editor command bar. Changes include:
A number of these SQL Editor commands can now be executed using the following hot key combinations:
CTRL + R
Control + R
CTRL + E
Control + S
Run from cursor
CTRL + G
Control + G
CTRL + ALT + F
Control + Option + F
CTRL + F
Command + F
- MQTs (materialized query tables)
- Nicknames (for federated DB2 configurations)
Generate SELECT and INSERT statements directly from database object pages
Users can now generate SELECT and INSERT statements for one or more selected DB2 (LUW) database objects, directly from within the Administer window. The supported object types are:
By selecting one or more database objects from their matrix and clicking the Generate DML button, users are presented with the SQL Editor in a new tab page, containing a draft of the SQL Statement type they selected. Each generated statement includes entries for each of the selected object types, along with all of their properties.
Now, instead of jumping back and forth between the object page and the SQL Editor, users can simply edit out any unwanted properties from their generated SQL statement and run the query.
Monitoring and alerts
- Activity type: values include:
- Workload name
- Wait time
- Executable ID
- Prepare time
Enhanced filtering for historical executions
IBM Data Server Manager has enhanced your ability to analyze historical query executions, by adding the following options to your list of available columns:
Add these columns to the Individual Executions matrix on the Monitor > Database > Statements page to sort and filter your results, based on these values.
Use the Group by control to sort your results by the new WLM Workload and Activity Type properties.
Sort or search by the full text of your SQL statements, not just a truncated segment.
- Easily identify and review connections to databases on HADR nodes to confirm the status of your high availability service.
- Monitor databases within both Primary and Standby nodes in a HADR cluster.
- Automatically add all connections to Standby nodes when adding a connection to a Primary node in an HADR cluster.
- Filter the display of tiles on the IBM Data Server Manager Home page by HADR status, using the primary tile sorting, shown items, and Sort by controls.
- Drill down to the Monitor > Database > HADR State page to view the health status of nodes in your HADR cluster.
IBM Data Server Manager now provides monitoring and alert services for standard configurations of IBM DB2 V10.1 (and above) for Linux, Unix and Windows.
- The navigation bar has been redesigned with fly-out menu options, providing more usable screen area.
- A database selector control has been added at the top of the DSM window, providing faster navigation between databases.
- Users can now easily jump from a database tile on the Home page to a specific Monitor page, by accessing the option from the drop-down menu control on the title bar of each tile.
IBM Data Server Manager Version 2.1 offers improved navigation:
- DB2 Edition: clicking the hyperlinked value allows users to manually update their license
- Capabilities: clicking the hyperlinked value displays the Enterprise license agreement
Easier migration from Base to Enterprise editions
Data Server Manager (DSM) has eliminated the need for users to download and install a License Activation Kit (LAK) to enable the DSM enterprise capabilities. By connecting to a DB2 Advanced edition database, or a DB2 edition where the Performance Management Offering has been installed, users will now automatically have access to these features.
Two new fields have been added to the Database Connections table:
NOTE: If the database you are connecting to is version 10.5.0.4 or lower, you will need to install the Performance Management Offering (PMO), along with the appropriate LAK on the database machine to enable the DSM Enterprise functionality. See DB2 Performance Management Offering for more information about the PMO, and Downloading IBM Data Server Manager for more information about downloading the LAK that's appropriate for your system.
- a CF member fails
- a database server fails or enters an unexpected state
- a member fails or enters an unexpected state and recommendations are needed to fix the problem
Query history for in-flight executions
IBM Data Server Manager Version 2.1 can now be configured to provide users with historical execution data for each in-flight query within a workload, utilizing a performance enhanced version of DB2 activity event monitoring. Users can view statements that have run in the past by choosing Monitor > Statements, selecting a time frame, and viewing the results in the Individual Executions pane. See Enabling query history for individual executions in DSM v2.1 for more information on configuring this feature.
Users can now identify queries that were active during a specific time frame, using the history mode control at the top of the window. Clicking the default state mode (Real Time) opens a drop-down list of past time frames from which to choose. Once selected, the time frame is highlighted on the time slider control, and can be dragged to filter your results.
Users can use the history mode to identify the most expensive queries running on their database system, or to identify delays (e.g., compile time, wait time) in execution for a selected query.
Export to CSV
Users can export the results of any Monitor > Database action, by clicking the Export as CSV tool, from the command bar of any results table.
Users can now view all the members and cluster caching facilities (CFs) when monitoring a pureScale cluster.
Users can now start and stop individual pureScale members and CFs from the Administer > Instance page.
Monitoring profiles now provide dedicated support for pureScale environments. Users can now configure pureScale-specific alerts for the following events:
Support for DB2 Federated database environments
When working within DB2 LUW Federated database environments, you can now modify options of Server, Wrapper, User Mapping, and Nickname objects individually.
You can now create, alter, or drop database sequences.
You can now filter the display of catalog tables by toggling the Show/Hide System Objects feature.
DB2 for LUW and z/OS
Access to the DSM Query Tuning tool has been improved. Users now select Optimize > Start Tuning to create a new tuning job, and Optimize > Tuning Jobs to view existing tuning jobs.
Query names displayed in the Query Tuning window have been truncated, to improve readability
Users can now select a single statement from a workload statement and tune the statement, or view the statement's access plan graph.
DB2 for z/OS
DSM Version 2.1 improves the support process for DB2 for z/OS environments by allowing users to capture both their query environment information and workload environment information, which can be sent to IBM support for analysis.
Users can now capture a statement from a DB2 for z/OS catalog package or package cache and create a workload tuning job from the statement.
Users can now view the access plan graph of a statement from a statement cache, using the new View Runtime Access Plan Graph feature.
Users can now view the access plan graph of a statement from a catalog package, using the new View Bindtime Access Plan Graph feature.
[2018/4/27] Revise Deprecation Announcement for the two deprecated job types after DSM v2.1.5
[2018/4/12] Add Deprecation Announcement section with an announcement for two deprecated job types after DSM v2.1.5
More support for:
IBM Data Server Manager
Software version: 2.1, 2.1.1, 2.1.2, 2.1.3, 2.1.4, 2.1.5
Operating system(s): AIX, Linux, Windows
Reference #: 7048195
Modified date: 27 April 2018
Translate this page: