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" ebook.