IBM Data Server Manager V1.1.x releases: new features and enhancements
This document describes the new features and enhancements in Version 1.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.
DB2 for Linux, UNIX, and Windows
Federation Support include:
Display, create, drop for the following objects:
- User Mapping
- DB2 family data sources through the DRDA protocol
DB2 for Linux, UNIX, and Windows and DB2 for z/OS
Enhancements to the SQL editor include:
- Create/Edit SQL
- Add "Maximize" button to maximize the editor to the whole browser, provide more space for editing.
- Results panel is folded, and editor area is maximum by default.
- Support insert saved script into active editor window.
- Show connection information above the editor window, provide options to change the active connection.
- Execute SQL
- Move "Run from cursor" to "Run" drop-down list.
- Expand the result view automatically when run a script.
- Support stored procedure with INOUT/OUT parameters.
- Add auto-connection option for Command Line execution.
- Display SQL Results
- Optimize the usage of space and improve ease-of-use of the query results.
- Only display execution records on the result view, provide an easier-to-navigate result view.
- Move log information to a separate dialog box, can be launched by clicking the "Log" link in result view.
- Move data information to separate tab, can be launched by clicking the "Data" link in result view.
- Display INOUT/OUT parameters of stored procedure in a separate tab.
- Show connection name, connection type and running status in result view.
- Provide filter for results by status and connections.
- Allow user to remove existing results.
- Allow user to set the maximum number of data sets, result records, and rows to be display in "Setting" dialog.
- Allow user to persistent JDBC running result and data in repository database, so user can view the running history cross session.
- Automated Tuning services
– Including Workload Access Path Compare, Workload Index Advisor, Workload Statistics Advisor, Visual Explain, Query Annotation/Format
– Offer automatic comparisons that you can schedule to simplify the change management process.
- Optimized Access Plan Graph
- The toolbar has been redesigned, all the view-switch buttons are replaced by icons and placed in the right corner. The integrated panel has also been redesigned, now hidden by default, and can be displayed on demand. The graphic view toolbar has been refined with a brand new vertical layout.
- Tune single SQL statements or workloads with DB2 Query Monitor CAE Web Client
- After you examine monitored SQL statements with the DB2 Query Monitor CAE(Consolidation and Analysis Engine) Web Client and store them in generic staging tables，you can now capture a query workload and transfer it to Data Server Manager with no size limitations, with complete metadata. Data Server Manager can retrieve problematic statements programmatically for query workload tuning. You can also use Data Server Manager to tune single SQL statements too.
- Migrate workload from InfoSphere Optim Query Workload Tuner for DB2 for z/OS V4.1.x
- Users can now export a workload from InfoSphere Optim Query Workload Tuner for DB2 for z/OS V4.1.x, and migrate it into DB2 Query Workload Tuner for z/OS V5.1 (based on Data Server Manager) as a tuning job.
DB2 for z/OS
- Connections to DB2 for z/OS V10 and V11.
- Database object navigation, viewing object detail, and linking to related objects.
- Database object dependency display.
- Data browsing and editing.
- Basic database object operations, such as creation of tables, indexes, constraints, and tablespaces; dropping of tables, indexes and constraints; altering tables.
- Showing system privilege from the perspective of Group/User, Role, or SQL object. Choose:
- "Group/User" to see the role and the relative object privilege for a user account;
- "Role" to see the role a user account belongs to and its relative object privilege;
- "SQL object" to see a specific object and users or roles that have the relative authority.
- Validate real time syntax and execute SQL statements.
- Change the statement terminator by adding the statement --#SET TERMINATOR in a comment (for example, --#SET TERMINATOR x, where x is the statement terminator).
DB2 for Linux, UNIX, and Windows and DB2 for z/OS
In the SQL editor, you can
Data Server Manager provides full query tuning support for DB2 for z/OS. DBAs can easily perform single query tuning and workload tuning tasks. Note that the license activation kit for DB2 Query Workload Tuner for z/OS is required. For both DB2 for Linux, UNIX, and Windows and DB2 for z/OS, the major query tuning features include:
- Launching of visual explain and tune query on the SQL editor helps DBAs and application developers quickly analyze and tune a query during development or troubleshoot a problem.
- A new tuning wizard in the query tuning dashboard helps you capture SQL statements from multiple sources, tune single queries, and conduct workload tuning tasks.
- Several tuning advisors provide recommendations quickly, for example:
- Statistics advisor analyzes a problem query or workload and generates recommendations to collect necessary statistics, including missing statistics, conflict statistics and obsolete statistics. The RUNSTATs scripts are provided. A detailed report is provided to help you check all statistics problems.
- Index advisor analyzes a problem query or workload and generates recommendations to optimize indexes, including new indexes, modification of existing indexes, and dropping of unused indexes. Index DDLs and related performance gain are provided.
- IBM DB2 Analytics Accelerator (IDAA) advisor analyzes a workload and recommends tables to be offloaded to IDAA and tables to retain in DB2. A detailed report is provided to explain the recommendations for each SQL statement. You can also perform what-if analysis to evaluate the performance gain from implementing recommendations.
- Several analyzing features help you better understand a problem query or workload, and conduct tuning tasks. These features include:
- An access plan graph that provides a graphical view of the access plan for a single query. The graph can help you understand how DB2 executes the SQL statements and deeply analyze potential performance bottlenecks.
- Query formatting and annotation formats complicated queries to a readable style and associates the statistics as an annotation.
- Tuning report summarizes information for a single query or a workload, including recommended actions, access plan summary, and table/index information. You can save the report to a file and share with others.
- Test candidate indexes help you perform what-if analysis on indexes for both single queries and workloads and further evaluate index recommendations. You can also use this feature to test indexes without actually creating them.
- Access plan comparison helps you to compare access plan changes between two tuning results for a single query or a workload. This feature is very useful to evaluate tuning recommendations. You can also lock down the access plan to quickly resolve an urgent performance issue.
- Index impact analysis helps you evaluate how the recommended indexes impact the entire system, including the existing packages and dynamic SQL statements. You can also choose a specific workload to evaluate the impact on an application.
- Several sources for capturing SQL statements from a local file, dynamic statement cache, plan/package, or user-defined repository. These sources are required by internal DB2 users (such as monitoring tools) and external DB2 users (such as file system.)
- Several filters can help you target workload statements accurately. The filters include: Estimation filters, Runtime filters, Access plan filters and Object filters.
- Other serviceability enhancements include:
- A configuration report to identify configuration problems in monitored databases or subsystems.
- The ability to capture query environments such as DDLs, statistics, zParm and query tuning analysis information and send the information to IBM.
After applying a license activation kit for z/OS connectivity, Data Server Manager functions for configuration management are supported for DB2 for z/OS. This license activation kit also allows you to use a DB2 for z/OS repository. For both DB2 for Linux, UNIX, and Windows and DB2 for z/OS, you can now:
- Track configuration changes. Administrators can set the monitoring profile for a DB2 for z/OS subsystem to track configuration changes. DBAs can easily access the list of changes from Data Server Manager, filter the time frame for the changes, and drill down into specific subsystems and subsystem objects to see what changed. In addition, alerts can be set to trigger when configurations change.
- Configure zParm. Administrators can view and configure zParam parameter for a subsystem or each member.
- Compare and clone configuration. DBAs can compare the current configuration of a DB2 for z/OS subsystem to a previous configuration, or they can compare different DB2 for z/OS subsystems. A DBA can also clone its configuration to a different DB2 for z/OS subsystem.
- Manage application profile. DBAs can clone and manage their application profiles for DB2 for z/OS subsystems.
- Manage alias. DBAs can manage and add DB2 for z/OS location aliases.
- Manage clients. DBAs can view and control clients that connect remotely to your DB2 for z/OS server. A DBA can compare and enforce client application configuration for DB2 for z/OS. DBAs can view clients that connect to DB2 connect gateway server and the endpoint of those clients for DB2 for z/OS. DBAs can specify a client correlation token condition for Isolate Application Transactions and Map Workload Manager Service Classes client rules for DB2 for z/OS. DBAs can also view these correlation tokens for recorded clients on the Managed Clients page.
- Additional Monitor Database cards are available, as well as many more metrics supporting PureScale, DPF, HADR, connections, logging and more.
- You can create and apply user baselines to Monitor Database > Overview real-time metrics. In addition to the automatic baselines, you can now take a metric baseline snapshot of a period of time and compare current metrics to your baseline.
- New Monitor Database reports are available to support connections, DB/DBM configuration, SQL baselines, workload manager and more. You can generate the reports on-the-fly or schedule them to be run automatically on your schedule.
- The repository has been enhanced to include new DB2 views, allowing you to easily access the repository historical metrics and generate custom reports.
- You can create and manage custom groups to organize your database connections by categories you define. For example, you can create custom groups to manage your databases by geographic location (East, West), business unit, or database function (Production, Test).
- Monitoring support for DB2 for Solaris connections is available, allowing you to take advantage of all monitoring and administration features for your DB2 for Solaris connections.
- Support for DB2 for z/OS connections has been added, allowing you to monitor these systems using Alerts, tracking configuration and object changes, penalty boxing applications using Data Tools Runtime Client based rules, and tuning options for single queries and workloads.
- Support for loading data from a .CSV file or using the load utility is available. In addition, you can now export data into a DEL/.IXF file.
- Support for Fine-Grained Access Control (FGAC) is available, allowing you to create and administer FGAC tables.
- A new what-if analysis advisor for BLU tables allows you to test candidate table organization and evaluate the performance gains without making any changes to your tables. Once you have evaluated the results, you can easily apply the selected changes.
- Translation support for: French, German, Italian, Japanese, Portuguese Brazilian, Simplified Chinese, Spanish, Traditional Chinese.
- There are no APAR fixes in this release.
Translate this page: