Today IBM announced updates to several performance management products, all of which are available individually or as part of the DB2 Advanced Enterprise Server Edition. They include:
We all know that poorly performing applications can lead to lost revenue and customer dissatisfaction. We have made numerous improvements in all these products to make it easier to identify and resolve issues before they can impact your business. There are far too many improvements to list but some notable improvements include:
IBM InfoSphere Optim Performance Manager V5.2
We have added enhancements to better analyze stored procedure performance. Rank stored procedures and drill down to find poorly performing SQL. We have extended reporting now with scheduling, emailing, and retention management. To help you automate actions, we have provided the ability to trigger user defined jobs in response to alerts.
IBM InfoSphere Optim Query Workload Tuner for DB2 Linux, UNIX, Windows V3.2
Once you have identified SQL that could use some help, use Query Workload Tuner to provide suggestions and analyze possible improvements or use Query Workload Tuner to analyze SQL before it ever goes into production. V3.2 has many enhancements to help with "what-if" analysis. Use Query Workload Tuner and virtual indexes to analyze the impact of adding, dropping or changing an index. Use the plan comparator to see the changes to access plans.
IBM InfoSphere Optim pureQuery Runtime for Linux, Unix Windows V3.2
Suppose you have poorly performing SQL from a third party application. pureQuery Runtime can help with that. Use pureQuery to swap out poorly performing SQL. With V3.2, new configuration scripts makes it easier to deploy on WebSphere Application Server and configuration changes can go into effect immediately.
IBM Data Studio V3.2
IBM Data Studio has also been updated. Many enhancements were made to alerts and scheduling in the web console. Users can now define their own alert view preferences. The client was updated to make debugging even simpler and more robust. Debug triggers and PL/SQL anonymous blocks. You can now view global and package variables, associative arrays and array of rows in the debugger. It is also much easier to recompile a routine for debugging. It is almost automatic. Starting with V3.2 the Data Studio administration client will be available via DB2 Express-C
and refreshed as needed. The full client is available via the normal Data Studio download page
. Remember, for the full client, when using the Installation Manager option, only the options selected will be downloaded and installed on your system. If you are using the administration client, try the full client.
Finally, connection management is now easier for many of these products. IBM InfoSphere Optim Performance Manager, Query Workload Tuner, and Data Studio can now obtain and stay synchronized with connection information from the Optim Configuration Manager's database repository.
For more information, check the announcement here
We have been busy working on an update to Data Studio just in time for DB2 10.1 for Linux, Unix and Windows
. This release includes enhancements throughout the product as well as the added support for DB2® V10.1 for Linux, UNIX, and Windows databases which include the following features:
- Adaptive compression for table rows
- Special registers for temporal tables in server profiles
- Time-based data management with temporal tables
- Data management using multi-temperature storage
- Data security with row and column access control (RCAC)
These DB2® V10.1 features are fully supported by Data Studio making it easier for you to take advantage of them.
Other product enhancements include updated syntax checking, additional support for pureScale, improvements to SQL routine support, improved performance information gathering, as well as enhancements to query tuning, shell sharing, and the Data Stuido web console, here are the details:
- We updated the syntax checking in the SQL and XQuery editor for all DB2 for Linux, UNIX, and Windows Command Line Processor (CLP) commands to provide validation of your commands and utilities as well as SQL.
- For pureScale we added support to help verify DB2 Cluster Services Status and Manage DB2 Cluster Services Configuration to further assist in the use of pureScale in your enterprise.
- We have made the following improvements around SQL routine support:
- You can now use the routine editor to create, edit, deploy, run and debug routines directly from the Data Source Explorer without having to create projects, simplifying the task of routine development when there is no other need for a development project.
- Likewise, you can re-compile a routine directly from the Data Source Explorer to enable/disable debugging.
- You can now create unit routine test cases with saved parameters and pre/post SQLs and then compare the current results with a saved base line result. This helps catch regressions when editing routines.
- To make it easier to tune your SQL before deployment, there is now an improved user interface for profiling DB2 LUW routines and to simplify integration, you can invoke InfoSphere Optim Query Workload Tuner from the profiling view.
- You can now use the Configuration Checker to verify that all essential server components are in place for routine development on DB2 Z.
- We made it easier to gather database performance information for stored procedures in DB2 for Linux, UNIX, and Windows databases.
The query tuning features in Data Studio have been enhanced to include the following:
- We added a Start Tuning wizard to the Task Launcher for a better up and running experience
- Our access plan graphs can now display three new nodes:
- Show the rebalancing of rows between SMP subagents with REBAL
- Show multi-distinct processing with MGSTRM
- Show a zigzag join with ZZJOIN
In addition to the Data Studio query tuning enhancements, the client for InfoSphere Optim Query Workload Tuner is now part of the Data Studio v3.1.1 product. After you install Data Studio v3.1.1, all that you need is a license to enable InfoSphere Optim Query Workload Tuner, simplifying the install process for those of you who use both Data Studio and InfoSphere Optim Query Workload Tuner.
On top of all the new functionality, the Data Studio v3.1.1 clients are now built off of Eclipse 3.6, which means the Data Studio full client is now compatible (for shell-sharing) with newer Eclipse based offerings such as the latest IBM Rational Application Developer and Rational Developer for System z.
For the Data Studio web console, we have included the following enhancements:
- New alerts so that you can configure for the following:
- High availability disaster recovery (HADR) databases
- DB2 pureScale instance status
- When the DB2 pureScale cluster facility is not found
- For DB2 V10.1 for Linux, UNIX, and Windows databases, we also added the following enhancements:
- Your storage group information is provided in alerts both under the 'Storage' category as well as on the 'Current Table Spaces' dashboard.
- You can create and manage user-defined alert types using custom scripts so you are no longer limited to the out-of-box alerts.
- You can import existing tasks from the DB2 Task Center into the Job Manager to ease the move from the DB2 Task Center to the Job Manager in Data Studio.
- You have more control over your jobs as we have added the ability to cancel a job that has started and specify a timeout period for your jobs.
Visit the Data Studio product page
and download from developerWorks
. Data Studio is bundled with a number of IBM data servers such as DB2 for Linux, Unix and Windows, DB2 Connect and IBM Informix. For a good overview, check out the "Getting started with IBM Data Studio for DB2
I've been a development manager on database administration capabilities for Data Studio for many years, and recently took over as product manager, as well. I am very excited about our new Data Studio 3.1 release. It not only includes enhancements to the previous release of Data Studio, but, more importantly, combines the feature set of Optim Database Administrator and Optim Development Studio with Data Studio and Data Studio Health Monitor to create one comprehensive product for application development and database administration, all available at no charge! Data Studio can be found as a download from developerWorks
and soon will be bundled with a number of IBM data servers such as DB2 for Linux, Unix and Windows, DB2 Connect and IBM Informix.
Data Studio 3.1 now consists of three components:
Data Studio administration client: Reduced footprint client for administration and non-Java based development. (You may remember we referred to this previously as the stand-alone package)
Data Studio full client: Full-feature client that can shell-share with other Eclipse-based products (This was previously called the integrated development environment package) .
Data Studio web console: health monitoring and new job scheduling capability (this was formerly known as Data Studio Health Monitor)
In addition to the consolidation, we've enhanced the following areas:
The object management feature has been completely overhauled. The new UI provides for in place editing of objects and eliminates the need for a separate editor. Complex object management for Optim Database Administrator for DB2 for Linux, Unix and Windows has been incorporated into the new object management for Data Studio 3.1.
There are a number of enhancements related to navigating, monitoring and managing a DB2 pureScale environment.
There are numerous enhancements to the query editor. They include version specific validation, execution control and special register support.
You can now change the user name and password on any or all connections with one action. The Data Studio web console also provides a central place to define database connections that can be imported by the Data Studio full or admin clients.
Compare and Sync
There are enhancements to reporting and visualizing changes.
DB2 for z/OS
We added support for temporal tables and query tuning now includes set/update profile support for runstats and table data sampling
Scripts may be scheduled as jdbc or clp scripts for DB2 for Linux, Unix and Windows and jdbc scripts for DB2 for z/OS.
You can find current Data Studio product information here
. Check out and post questions, comments, or requests on our forum
or visit our information center
and information roadmap.
P.S: Today we also announced the following:InfoSphere Data Architect 7.6 InfoSphere Optim pureQuery Runtime z/OS 3.1InfoSphere Optim pureQuery Runtime LUW 3.1InfoSphere Optim Query Workload Tuner LUW 3.1 InfoSphere Optim Query Workload Tuner z/OS 3.1
We released several fix packs on June 30th and a modification release on July 1. There are a few new features and platform support worth taking time to highlight.
Optim Performance Manager – Optim Performance Manager 4.1.1 is now available. We put a lot of focus on up-and-running improvements in this release. This includes embedding a lightweight web container to simplify installation, configuration, and security, simplifying our port infrastructure for Extended Insight support, improving the out-of-the-box monitoring templates based on customer experience and more. We have added pureScale-specific monitoring enhancements including pureScale monitoring templates, group buffer pool hit ratios, cluster facility lock wait time, escalations, timeouts, etc. We provided more flexibility for monitoring large DPF environments by separating collection intervals for bufferpool versus tablespace and table statistics, which provides more comprehensive information at a lower cost. We have also included DB2 Enterprise Server Edition 9.7 for use with Optim Performance Manager. For the complete list of features and more information, see the IBM Optim Performance Manager 4.1.1 release notes.
Optim Development Studio – Optim Development Studio 184.108.40.206 now also officially supports deployment on Citrix (I know several organizations that went ahead and deployed before our formal support was announced). It also includes two very cool items:
- Integration with Optim Performance Manager – Now you can pull performance metrics into Optim Development Studio to assist in determining which SQL statements need a little more tuning and whether your tuning efforts are paying off. This integration requires Optim Performance Manager Extended Edition with Extended Insight monitoring configured.
- Support for Sybase - You can connect to a Sybase database and browse catalogs, manage objects, create and run SQL scripts, and create, deploy, run, and debug stored procedures. Plus you can use the ANTs Software product IBM® DB2 SSacSA to connect to a DB2 for Linux, UNIX, and Windows database as a Sybase database.
Remember, Optim Development Studio is available on Passport Advantage to most DB2 and Informix customers as part of their DB2 for Linux, UNIX, and Windows, DB2 Connect, or Informix investment. Find it in the Linux or Windows eAssemblies. See IBM Optim Development Studio Version 220.127.116.11 Release Notes
for a more information and download updates from Fix Central
Optim Database Administrator - Optim Database Administrator 18.104.22.168 also adds official support for Citrix deployment. It also sports a new table data editor for DB2 for LUW and z/OS databases and closed a couple gaps in the dependency analysis space for packages and procedures. It also includes catalog filtering improvements tailored to very large databases. Optim Database Administrator is available to DB2 for Linux, UNIX, and Windows customers as part of their DB2 9.7 Linux or Windows eAssembles on Passport Advantage. See IBM Optim Database Administrator Version 22.214.171.124 Release Notes for more information and download updates from Fix Central.
Data Studio – Data Studio 126.96.36.199, both stand-alone and IDE, inherit the Optim Database Administrator Citrix, table data editor, dependency analysis, and catalog filtering enhancements. In addition, this release includes some enhancements specifically for DB2 for z/OS, notably use of TABLESAMPLE keyword on statistics recommendations and catalog navigation performance improvements. For more information, see the IBM Data Studio Version 188.8.131.52 Release Notes. Download updates from Fix Central or a fresh install at developerWorks.
Check them out and post questions, comments, or requests here or on our forums
We have released an update to our popular free e-book "Getting started
with IBM Data Studio for DB2". The update covers some major new
features that were released in Data Studio 2.2.1
. The chapters covering
database administration have been completely revised for the new
Administration Explorer, which replaces the legacy Data Source
Explorer. The updates also cover usability enhancements like improved
context menus, DB2 Information Center links in the Task Assistants and
also the new Task Launcher, which has gotten great feedback from our
customers. Download the book
As part of our Control Center replacement work we are gathering information about customer usage of the Task Center. If you are using Task Center, please complete our survey about your usage and what you value most. Would love to have your input by the end of November. Link to survey here
Big news last week on the Optim tools front.
- DB2 introduced a new server, Advanced Enterprise Server Edition, that bundles up tons of tools for a phenomenal value, including Optim Performance Manager! Anyone looking at or owning Enterprise Server Edition needs to take a look at this high value offering. See the announcement here.
- All DB2 for Linux, Unix, and Windows customers with current subscriptions now get access to Optim Database Administrator and Optim Development Studio in addition to Data Studio. Use Optim Database Administrator to save time and reduce errors in administering DB2 databases. Use Optim Development Studio to accelerate application development against DB2 and Oracle. Let the downloading begin! (Links further down)
- We released mod releases and fixpacks today for several tools with great added function with more coming later in the month.
Let me take you through the highlights.
Administration and Availability
- Data Studio provides an easy to use development and administration tool. Data Studio 2.2.1, still available in either a standalone or integrated development environment (IDE) configuration, is enhanced for first time user experience, customizable catalog navigation, customizable, template-based routine development (check out the new article from Michael on this), enhanced data browsing, a new query tuning UI, a new health monitor, and updates for use with DB2 for z/OS V10. Early user feedback has given rave reviews to the new task launcher for improving the experience for first-time users, particularly those not familiar with the Eclipse environment. The new health monitor is a separately installed component with Web UI, but is seamlessly launchable from the Eclipse client to monitor DB2 for Linux, UNIX, and Windows health and view alerts, application, utilities, and storage. Download it here.
- Optim Database Administrator saves time and reduces errors associated with complex database changes for DB2 for Linux, UNIX, and Windows databases. Installable together with the Data Studio IDE, it provides copy and paste, compare and synch, and data migration features that identify and manage dependent objects automatically. It provides seamless integration with InfoSphere Data Architect for governing and accelerating the database design through deployment process. Optim Database Administrator 2.2.3 inherits most of the Data Studio enhancements and enhances compare filtering. It also improves performance for building change scripts when working with a small number of objects in very large databases. Use with Optim Test Data Management to streamline test data creation, reduce storage consumption, and manage data privacy. Download Optim Database Administrator 2.2.3 here.
- Optim High Performance Unload reduces demand on system resources, shrinks batch window requirements, accelerates database migrations, and minimizes impact on business operations by speeding up unload processes by 4X or more. Optim High Performance Unload 4.2 is enhanced with DB2 pureScale support and a new option for unloading from a schema.
Design and Development
- InfoSphere Data Architect enhances design productivity, data quality, enterprise consistency and data governance. It supports business and IT collaboration to keep IT aligned with business objectives and helps to define and enforce compliance to enterprise standards. New in InfoSphere Data Architect 7.5.3 is enhanced multi-dimensional modeling including automatic discovery and notation of facts, measures, dimensions, and outriggers, automatic de-normalization of operational data for designing warehouses, and lossless integration with InfoSphere Warehouse and Cognos Framework Manager. Watch for a demo of this new capability later this month. Download InfoSphere Data Architect 7.5.3 here.
- Optim Development Studio increases development efficiency up to 50% for Java data access and facilitates cross-system development and migration. A quick review: it supports development for DB2, Oracle, and Informix. Its SQL outline feature facilitates developer and DBA collaboration quickly isolating all the SQL for review and enabling impact analysis by correlating SQL with source code, database objects, and ALTER requests. Its application metadata can be transferred to Optim Performance Manager to pinpoint problem SQL to the Java method and line of code. Plus it positions the organization to take advantage of Optim pureQuery Runtime to enhance and lockdown performance and mitigate SQL injection risk. New in Optim Development Studio 2.2.1 is the ability to deploy SQL scripts, procedures, and functions to multiple development and test servers with a single gesture. The customer feedback has been fabulous. Clifford will have an article coming out in a couple weeks. Included with Optim Development Studio are development-only copies of Optim pureQuery Runtime and the DB2 Connect JDBC driver, so download all of these together from here.
- Optim Performance Manager provides out-of-the-box performance monitoring and management to improve quality of service and prevent impacts to business operations. Its intuitive web UI provides use-anywhere monitoring, alerting, and diagnosis of potential performance bottlenecks. Integrated tooling enables easy setup exploitation of DB2 workload manager to make sure that system database resources are applied according to business priorities. And its performance warehouse provides needed context for proactive performance management, trend analysis, and capacity planning. The new Optim Performance Manager fix pack (timed for delivery with DB2 Advanced Enterprise Server Edition) does double-duty providing health monitoring for all your other development and test systems at no additional charge providing a single integrated console for monitoring all your DB2 servers. Plus it has added more flexibility in alert management, DB2 Workload Manager configuration, more performance metrics, more reports, and more consumability improvements. Want more? Upgrade to Optim Performance Manager Enterprise Edition. It enables monitoring of end-to-end database transaction times to assure that critical workloads are meeting their response time targets. New in this delivery, tell us the response time goal for the workload and let us figure out how to make it happen. Plus there’s now support for .NET and Type 2 connection workloads, enhanced Tivoli integration, and more granular performance detail.
- Optim Query Tuner gives DBAs and developers expert advice on query structure, access paths, statistics, and indexes to improve query performance. Optim Query Tuner for Linux, UNIX, and Windows 2.2.1 sports a new user interface to streamline query tuning workflow.
- Optim pureQuery Runtime improves performance and predictability while reducing risk. Optim pureQuery Runtime 2.2.1 adds support for ODBC and CLI applications. Using pureQuery, you can configure a DB2 application to run the application's dynamic SQL statements statically. You can also convert SQL statement string literals to parameter markers to improve performance, replace poor performing SQL statements with optimized statements without changing the application, and reduce the risk of SQL injection attacks by restricting what SQL statement are allowed to run against the database.
OK, let me take a breath! As you can see, we’ve been busy. Hope you’re planning to stop in and see us in Las Vegas at the Information On Demand conference. Kimberly will post a summary of our key sessions and events soon.