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 information about how to upgrade or install the latest modification, go to Installing and upgrading IBM Data Server Manager.
List of fixed APARs in IBM Data Server Manager:
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 184.108.40.206 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 v220.127.116.11. 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.
More support for:
IBM Data Server Manager
Software version: 2.1, 2.1.1, 2.1.2, 2.1.3, 2.1.4
Operating system(s): AIX, Linux, Windows
Reference #: 7048195
Modified date: 22 June 2017
Translate this page: