Understand IBM Data Studio Version 2 software packaging

Getting IBM integrated data management capabilities on your desktop is only a download away

This article provides a brief overview of the functionality and packaging of some of the key Data Studio products from the IBM® integrated data management portfolio. The portfolio includes Data Studio Developer and Data Studio pureQuery Runtime, Data Studio Administrator, DB2® High Performance Unload, InfoSphere™ Data Architect, DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature, and DB2 Optimization Expert for z/OS®.

Deb Jenson (dejenson@us.ibm.com), Product Manager, IBM

Author Photo: Deb JensonDeb Jenson joined IBM in 2004 to drive strategic marketing for the DB2 data server. As Product Manager for DB2, she is responsible for market strategies that drive incremental growth and increase market awareness for the DB2 data server. Deb has over 12 years experience in the commercial software industry with extensive experience developing database products and driving market execution strategies that drive growth. Deb joined IBM from Quest Software and prior to Quest, held various positions at Platinum Technology focused on the database management product family. Deb can be reached at: dejenson@us.ibm.com..



05 February 2009

Also available in Chinese Vietnamese

This article applies only to Data Studio 2.1 and earlier. For information about the latest versions of the products discussed in this article, please refer to the article Understanding the packaging of Optim Solutions for database development, administration, and performance management.

Introduction

This article provides you with an overview of the Data Studio family and brief descriptions of the capabilities of each Data Studio product. The product descriptions help you differentiate between the no-charge capabilities and the additional capabilities that are available for purchase. You can also learn how to download and install the no-charge functionality as well as how to obtain trial versions that include the additional capabilities that are available for purchase.

The article does not fully describe and catalog every feature of each product. For more in-depth information, use the links provided within the individual product descriptions and in the Resources section.

What is Data Studio?

Data Studio is the family name for a portfolio of products used to deliver on IBM’s vision of a modular, integrated data management environment. This environment is designed to increase productivity for all roles throughout the data life cycle and to help reduce the complexity and cost of managing database applications.

Each Data Studio offering is designed to address tasks found in each phase of the application life cycle from a data management viewpoint. This article focuses on describing each of the products that manage various phases of the application life cycle and how those products are packaged.

Figure 1. Integrated data management capabilities in Data Studio
Data Studio wheel diagram

Following are high level descriptions of the products shown in the figure above:

Quicklinks for DB2 for z/OS DBAs and developers

For many years, IBM has had a great set of tools for managing DB2 for z/OS data and applications. Over time, more capabilities for z/OS will be delivered in these products, as well as other integrated data management and heterogeneous data solutions. Of the products described in this article, the following are all enabled for z/OS databases today:

Although not described in this article, the IBM Optim set of solutions also has great support for z/OS for managing data growth, protecting data privacy, and streamlining test data.

  • InfoSphere Data Architect: Simplifies data modeling and integration design, enabling architects to discover, model, relate, and standardize diverse and distributed data assets.
  • Data Studio Developer: Provides a complete development and testing environment for building database objects, queries, database logic, and pureQuery applications.
  • Data Studio pureQuery Runtime: Delivers a high performance data access platform that provides the ability to optimize and lock down SQL without modifying the application.
  • Data Studio Administrator: Manages complex structural changes while preserving data, privileges, all dependent objects, and application binding.
  • DB2 High Performance Unload: Provides a high speed unload utility as an alternative to the export feature. Whether stand-alone or used in conjunction with Data Studio Administrator, this feature significantly reduces the time required to migrate databases.
  • DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature: Provides a comprehensive and proactive performance management solution for database applications that access DB2 databases on Linux®, UNIX®, and Windows®. The Extended Insight Feature complements Performance Expert by delivering end-to-end database transaction monitoring for Java database applications.
  • DB2 Optimization Expert for z/OS: Provides an environment for performing workload and query monitoring and tuning tasks when accessing DB2 for z/OS databases.

There are additional products that are part of the integrated data management portfolio, such as Optim™ Test Data Management Solutions, however, this article will only focus on the products described above.

What's new in Data Studio 2.1 packaging

The latest release of the Data Studio portfolio (2.1) made the following packaging changes:

  • InfoSphere Data Architect Developer packaging has not changed in terms of its functionality. However, the product was re-branded from Rational® Data Architect to InfoSphere Data Architect to reflect this product’s key role in IBM InfoSphere Foundation Tools and the IBM InfoSphere Warehouse.
  • Data Studio Developer has added significant capability for developers and DBAs (see the Channel DB2 video series and the Resources section for links to more information). Most of the enhancements have been made in the functionality that is available for purchase, but you can download the 30-day trial download and experiment with the full capabilities of this offering. When the Data Studio Developer trial license expires, you will still be able to use the no-charge functions of the product. Alternatively, you can choose to install the no-charge capability without installing the trial capabilities (DB2 and Informix® customers would be fully supported with that download). As in the previous release, the Data Studio pureQuery Runtime is not available as a separately downloadable trial, but it is included with the Data Studio Developer trial download for use on the same machine as the Data Studio Developer trial.
  • Data Studio Administrator has added many new capabilities to make day-to-day administration tasks easier. A key set of capabilities that were formerly found in DB2 Control Center are now part of the no-charge functionality and remain in use after expiration of the 30-day trial download. Alternatively, you can choose to install the no-charge features separately without the trial capabilities.
  • IBM DB2 Performance Expert for Linux, UNIX, and Windows now includes a no-charge, restricted use license of DB2 Enterprise Server Edition to serve as the performance warehouse where DB2 Performance Expert can store key metrics. The inclusion of this no-charge DB2 database license encourages organizations to scale up their performance databases to capture and retain more performance data, which yields both quicker problem determination and more accurate trend analysis.
  • IBM DB2 Performance Expert Extended Insight Feature provides end-to-end database transaction monitoring for Java database applications. This is an add-on feature to DB2 Performance Expert. It provides a response time-based monitor that enables quick and accurate problem resolution by intuitively breaking down how time is spent in the application server, database server, and the network between them.
  • IBM DB2 Optimization Expert for z/OS is now available on an Eclipse platform and shell shares with the other Data Studio products. This is the first key step to integrating query tuning more closely with other tasks, such as application development. DB2 Optimization Expert identifies poorly performing SQL and offers a comprehensive set of expert advisors that can help improve system performance and lower total cost of ownership. Visual Explain is a new no-charge function that provides access path and related statics for SQL and XQuery statements.

Data Studio no-charge capabilities

The no-charge capabilities in Data Studio provide a foundation upon which you can add features and functions as needed. This foundational packaging has evolved from the 1.1 release, when it was first made available. The following review of the evolution from 1.2 to 2.1 should help provide a full understanding as to what’s changed in this packaging.

Eclipse-based offerings

In Data Studio 1.2, all Eclipse-based no-charge capabilities were combined with the capabilities that you had to purchase and could be obtained by downloading the 30-day trial. After the 30-day trial period expired, you were only able to use the no-charge capabilities.

With Data Studio 2.1, the same type of packaging is in place; however, what has changed is the installation process. To obtain either the features you must purchase or the no-charge features, you must download the 30-day trial package. During installation, you can pick which components to install. If you choose, you can install only the no-charge components. The two packages available in the 30-day trial that contain no-charge functionality are Data Studio Developer and Data Studio Administrator. The features contained in these two products are described in the corresponding overview sections later in this article.

If you wish to install only the no-charge features of Data Studio Developer, you must download the 30-day Data Studio Developer trial. During installation, you can uncheck Advanced Features (see Figure 2) to indicate you want to install only the no-charge features.

Figure 2. Installing Data Studio Developer
Installation manager screen for Data Studio Developer

(See a larger version of Figure 2.)

Data Studio Administrator also provides the ability to only install certain components. If you choose to only install the no-charge functionality, you must uncheck the Database Change Management component, as shown in Figure 3.

Figure 3. Installing Data Studio Administrator
Data studio administrator installation screen

(See a larger version of Figure 3.)

By selectively installing certain components, you can reduce the storage footprint for the product and eliminate functions not applicable to your environment. You can also choose to install only the no-charge functionality.

Web-based offerings

The no-charge complement to DB2 Performance Expert is the Data Studio Administration Console. This console allows you to monitor your data servers from any Web browser. You can monitor the health and availability of databases, view dashboard metrics, investigate alert details, and troubleshoot problems using expert recommendations. You can also monitor Q replication and event publishing, generate replication health reports, and perform basic replication operations.

The rest of this article focuses on the additional capabilities you get when you purchase Data Studio. For example, although basic database development capabilities are included in the Eclipse-based no-charge package, additional capabilities for pureQuery development are included only in Data Studio Developer. Similarly, basic health and availability monitoring is available in the Data Studio Administration Console, but you need DB2 Performance Expert to get the rich statistics and graphical interfaces that help you drill down and find the cause of a performance issue.


InfoSphere Data Architect 7.5.1

Overview

Although not branded Data Studio, IBM InfoSphere Data Architect 7.5.1 is a key part of an integrated data management workflow. It provides enterprise data modeling and integration design modeling to help data architects understand information assets and their relationships, design federated databases, and streamline database projects. InfoSphere Data Architect provides advanced features to help data architects discover, model, visualize, relate, standardize, and develop heterogeneous data assets. It gives data professionals the ability to:

  • Intelligently design a relational or federated database
  • Perform impact analysis across models
  • Compare and synchronize models to deployed databases
  • Create enterprise data standards, verify compliance, and generate compliant models

Features

Figure 4 shows some of the key features of InfoSphere Data Architect. For basic visualization of physical databases, the no-charge option in Data Studio includes physical overview diagrams.

Figure 4. InfoSphere Data Architect features
InfoSphere Data Architect features

Databases supported

  • Derby Versions 10.0, 10.1, 10.2
  • Generic JDBC Version 1.0
  • DB2 for Linux, UNIX, and Windows Versions 8.2 (FP 11 or higher), 9.1, and 9.5
  • DB2 for iSeries® V5R3 and V5R4
  • IBM DB2 for z/OS Versions 7.1, 8.1, 9.1 (compatibility mode), and 8.1 and 9.1 (new function mode)
  • IBM Informix Dynamic Server Versions 9.4, 10.0, 11.1 and 11.5. (Select 11.0 in the connection wizard to connect to either 11.1 or 11.5)
  • Microsoft® SQL Server Enterprise 2005
  • MySQL Versions 4.0, 4.1, 5.0, and 5.1
  • Oracle Versions 9, 10, and 11
  • Sybase Adaptive Server Enterprise Versions 12.0, 12.5, 12.x, 15.0
  • Teradata 2.x

How do I get it?

InfoSphere Data Architect is a priced offering. If you are already a Rational Data Architect customer, you are automatically entitled to download InfoSphere Data Architect 7.5.1 from Passport Advantage.

If you are not a current customer, you can download a 30-day trial from developerWorks. After the trial license expires, you can reactivate the product by purchasing the product and downloading a product activation kit from Passport Advantage.

To purchase the product, contact your IBM Sales Representative, authorized IBM Business Partner, or purchase online.

What's changed in 7.5.1?

There are few functional enhancements in 7.5.1 over that provided in 7.5, which was released in September, 2008. See the announcement letter for more details, including the integration with Optim Test Data Management and Data Privacy solutions.


Data Studio Developer and pureQuery Runtime

Overview

IBM Data Studio Developer provides an integrated development environment for creating and testing database and Java applications. Combined with pureQuery Runtime, Data Studio Developer provides a data access layer for Java-based applications to ease development coding and provide superior performance and manageability. These offerings:

  • Provide an easy-to-use data access layer within Java applications to assist in development of Java database applications
  • Deploy static SQL within new or existing Java applications to improve application performance, manageability, and security within your applications
  • Correlate SQL to original Java source code for quicker problem diagnosis
  • Prevent errors by enabling you to understand the impact that changing a database object has on the application and directing you to the relevant place in the source code
  • Eliminate SQL injection risk by only allowing approved SQL to be executed
  • Deploy efficient SQL by examining new SQL metrics, such as, number of executions, aggregated elapsed time, and minimum and maximum execution times, to help identify hot spots in the application
  • Replace poor performing SQL with a more optimal SQL statement without modifying the program source code

Features

Figure 5 shows some of the key features of Data Studio Developer and pureQuery Runtime. The chart indicates which features you get when you select only Data Studio no-charge capabilities.

Figure 5. Data Studio Developer and pureQuery Runtime features
Data Studio Developer features

Note: pureQuery now supports .Net. See the Optimizing queries in .NET applications using pureQuery topic in the DB2 Information Center for more information.

Databases supported

  • DB2 for Linux, UNIX, and Windows Versions 8.2 (FP 11 or higher), 9.1, and 9.5
  • DB2 for iSeries V5R3 and V5R4
  • IBM DB2 for z/OS Versions 7.1, 8.1, 9.1 (compatibility mode), and 8.1 and 9.1 (new function mode)
  • IBM Informix Dynamic Server Versions 9.4, 10.0, and 11.1, and 11.5

How do I get it?

If you are already a Data Studio Developer and pureQuery customer, you are automatically entitled to download the 2.1 version of those products from Passport Advantage.

If you are not a current customer, you can download a 30-day trial of Data Studio Developer from either the ibm.com Web site or from developerWorks. When downloading the Data Studio Developer 2.1 trial, you also receive the Data Studio pureQuery Runtime for use only on your workstation. After the trial license expires, you can modify the package in Installation Manager to remove the trial features. This ensures that you are able to use the no-charge functionality without any error messages. If you choose to purchase the trial functionality, you can reactivate that functionality by purchasing the product and downloading a product activation kit from Passport Advantage.

To purchase the product, contact your IBM Sales Representative, authorized IBM Business Partner, or purchase online: Data Studio Developer, Data Studio pureQuery Runtime

What's changed in 2.1?

This release focuses on providing more control and management over the SQL and providing pureQuery support for .Net applications. For details about these new enhancements, see the announcement letter or "What’s new and exciting in IBM Data Studio Developer 2.1".


Data Studio Administrator 1.2

Overview

If part of your job is managing database changes, you'll be able to make good use of the expanded change management functions now included in Data Studio Administrator. Although the no-charge installation of Data Studio Administrator can provide simple DDL functionality, you need the full Data Studio Administrator to perform extended alters (those alters requiring a drop and recreate) and to compare and synchronize test databases to production databases. Data Studio Administrator:

  • Manages complex structural changes while preserving data, privileges, all dependent objects, and application binding
  • Reports on the impact of proposed changes to identify dependencies and mitigate risk
  • Documents a complete history of changes, including scripts, models, logs, and reports to capture the entire change from start to finish
  • Integrates with InfoSphere Data Architect for seamless transition from logical to physical design and deployment
  • Generates utilities for day-to-day maintenance such as reorg, backup/restore, etc.
  • Generates common commands such as start and stop of databases, quiesce, etc.

Features

Figure 6 shows some of the key features of Data Studio Administrator. The chart indicates which features you get when you install Data Studio Administrator without the Change Management feature. Popular functions from Control Center are included in this release as no-charge functionality. The full Data Studio Administrator product expands on basic DDL generation with features like extended alter, migrate, and compare.

Figure 6. Data Studio Administrator features
Data Studio Administrator features

Databases supported

  • DB2 for Linux, UNIX, and Windows Versions 8.2 (FP 11 or higher), 9.1, and 9.5

How do I get it?

If you are a current DB2 Change Management Expert or Data Studio Administrator customer, you are automatically entitled to download the 2.1 version of this product from Passport Advantage.

If you are not a current customer, you can download a 30-day trial from the ibm.com Web site or from developerWorks. After the trial license expires, you can modify the package in Installation Manager to remove the trial features. This ensures that you are able to use the no-charge functionality without any error messages. If you choose to purchase the trial functionality, you can reactivate that functionality by purchasing the product and downloading a product activation kit from Passport Advantage.

To purchase the product, contact your IBM Sales Representative, authorized IBM Business Partner, or purchase online.

What's changed in 2.1?

Data Studio Administrator 2.1 contains a number of enhancements that enable more support for day-to-day DBA tasks that were typically contained in the DB2 Control Center. For more details and for information on the enhancements, see the announcement letter.


DB2 High Performance Unload 4.1

Overview

DB2 High Performance Unload for Multiplatforms is a high-speed tool for unloading, extracting, and repartitioning data in DB2 for Linux, UNIX, and Windows databases. DB2 High Performance Unload is also available as a separate product for DB2 z/OS databases. This product can help DBAs work with very large quantities of data with less effort and with faster results. It can:

  • Enable creation of customizable unloads with use of SELECT syntax to filter columns and rows
  • Scale, with support for partitioned databases and ability to unload to multiple directories in parallel
  • Recover single tables within your production system by unloading from a backup
  • Reduce the risk of impacting online production by unloading from a backup rather than the "live" table
  • Recover from single table failures or accidental table drops by extracting a single table from a backup for restoration
  • Easily migrate data to a partitioned database or warehouse using the splitter function to unload into pre-split files ready for parallel loading

Features

Data Studio provides a number of data management features to facilitate unloading, editing, and loading data. These features are all available as no-charge features accessible from the Data Studio Eclipse console. If you purchase DB2 High Performance Unload, you can also execute high performance unload directly from the Data Studio console.

Figure 7. Data management features of Data Studio
DB2 High Performance Unload features

Databases supported

  • DB2 for Linux, UNIX, and Windows Version 8 or later

How do I get it?

If you are already a DB2 High Performance Unload for Multiplatforms customer, you are automatically entitled to download the 4.1 version from Passport Advantage. If you are not a current customer and would like to obtain a trial version, contact your IBM Sales Representative or authorized IBM Business Partner.

To purchase the product, contact your IBM Sales Representative, authorized IBM Business Partner, or purchase online.

What changed in 4.1?

One of the key new features in DB2 High Performance Unload V4.1 for Multiplatforms is the ability to migrate data directly (unloading, transferring, and loading) from one database to another by using pipes, without the need for intermediate disk storage. This capability delivers the fastest way to migrate your data from one location to another. The new release also has other usability improvements and now supports Windows 64-bit platforms. See the announcement letter for more details.


DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature 3.2

Overview

IBM DB2 Performance Expert V3.2 for Linux, UNIX, and Windows provides in-depth database monitoring, problem isolation, and trend analysis for DB2 for Linux, UNIX, and Windows databases. It gives DBAs the ability to:

  • Monitor and analyze multiple DB2 instances running a wide variety of workloads — OLTP, data warehouse, and enterprise content management — all from a single control point
  • Analyze real time data to troubleshoot existing performance problems or analyze data offline to reduce resources in your "live" system
  • Leverage historical data in the performance warehouse to analyze trends, and plan for growth
  • Identify resource shortages and exceptional conditions in DB2 and the underlying operating system
  • Alert administrators by email or page when events occur to find and fix problems before they affect the business
  • Monitor Workload Management (WLM ) entities statistics, and activities over time to validate WLM definitions

By extending DB2 Performance Expert with the Extended Insight Feature, DBAs get unprecedented insight into the database transaction software stack when running Java applications — the database client, the application server, and the network — giving them immediate insight into where database workloads, transactions, and SQL requests are spending their time.

Features

Figure 8 provides a visual overview of the features available in the no-charge Data Studio Administration Console, DB2 Performance Expert, and the add-on extended insight feature of DB2 Performance Expert.

Figure 8. Features of performance management
Performance Management features

Databases supported

  • DB2 for Linux, UNIX, and Windows Version 8 or later (Data Studio Administration Console also supports DB2 for z/OS).

How do I get it?

You can download the Data Studio Administration Console from the ibm.com Web site.

DB2 Performance Expert for Linux, UNIX, and Windows is a priced offering. If you are already a DB2 Performance Expert customer, you are automatically entitled to download the 3.2 version of the product from Passport Advantage. You can purchase the new Extended Insight Feature as an add-on to Performance Expert. If you are not a current customer and would like to obtain a trial version of the product, contact your IBM Sales Representative or authorized IBM Business Partner.

To purchase the product, contact your IBM Sales Representative, authorized IBM Business Partner, or purchase online: DB2 Performance Expert, and DB2 Performance Expert Extended Insight Feature.

What changed in 3.2?

DB2 Performance Expert for Linux, UNIX, and Windows now includes no-charge, restricted-use licenses for DB2 Enterprise Server Edition to store and manage captured performance statistics within the PE Server. The other major enhancement is the ability to extend this product with the new DB2 Performance Expert Extended Insight Feature described in the Overview. See the announcement letters for more information: DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature.


DB2 Optimization Expert for z/OS 2.1

Overview

DB2 Optimization Expert provides an environment to identify and tune poor performing SQL statements. By monitoring your DB2 workload, DB2 Optimization Expert can quickly pinpoint SQL statements that may be causing performance problems. Comprehensive expert advisors not only tune that particular SQL statement, they also recommend tuning activities that improve the overall performance of an entire DB2 SQL workload.

Features

Data Studio Developer provides Visual Explain as a no-charge feature for DB2 data servers. Optimization Service Center is a part of the DB2 z/OS Accessories Tools Suite, and while not a part of Data Studio, it does provide some SQL tuning capabilities and is worth noting in this article. Figure 9 provides a visual comparison between Data Studio Visual Explain, Optimization Service Center for DB2 for z/OS, and DB2 Optimization Expert.

Figure 9. Features of query tuning
SQL tuning features

Databases supported

DB2 for z/OS Version 8.1 and DB2 Version 9.1 for z/OS (Visual Explain also supports other members of the DB2 family).

How do I get it?

If you are already a DB2 Optimization Expert for z/OS customer, you are automatically entitled to obtain the new release. If you are not a current customer, you must purchase a license from IBM to use the product. See your IBM Sales Representative or ShopzSeries for more information about obtaining a trial version or purchasing this product.

What changed in 2.1?

DB2 Optimization Expert for z/OS v2.1 is now integrated with the rest of the Data Studio products and can be invoked in the same Eclipse shell as Data Studio Developer. This makes it easier for developers to invoke and use query tuning capabilities. For more information on the new features of DB2 Optimization Expert, see the announcement letter.

Resources

Learn

Get products and technologies

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=368369
ArticleTitle=Understand IBM Data Studio Version 2 software packaging
publish-date=02052009