Introduction

This article gives an overview of the InfoSphere Optim solutions for database development, administration, and performance management. The product descriptions help you understand which databases are supported, how to differentiate between the no-charge capabilities and the additional capabilities that are available for purchase, and how to download no-charge and trial products. The article does not list and fully describe every feature of each product. For more in-depth information, use the links provided in Resources.

Summary of July 2011 changes

This update includes new products, new releases, and fix packs for all referenced products. The updates are summarized in the following developerWorks blog entries (see Resources for links):

• New Optim and Data Studio Fix Packs and mod releases – Check them out! (July 2011)
• DB2 Advanced Recovery Solution for Linux, UNIX and Windows (June 2011)
• New Optim fixpacks with cool function added (April 2011)

A number of the offerings are now also included in DB2 and InfoSphere Warehouse editions. Refer to these links to view entitled Optim software (see Resources for links):

• DB2 features and functions by edition
• Components of InfoSphere Warehouse

The following bundled offerings were removed from market in June 2011:

• IBM Optim Performance Acceleration Edition for DB2 for Linux, UNIX, and Windows
• IBM Optim Database Management Professional Edition

Exploring InfoSphere Optim solutions for data lifecycle management

InfoSphere Optim is the family name of a portfolio of products that delivers on the IBM vision of managing data across your data's lifecycle (see Table 1). This portfolio 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. InfoSphere Optim offerings help you manage and optimize tasks in each phase of the application life cycle from a data management viewpoint. This article focuses on an overview of some of these offerings and how the products are packaged.

The following list gives a high-level description of the products highlighted in Table 1.

• InfoSphere Data Architect: Simplifies data modeling and integration design, enabling architects to discover, model, relate, and standardize diverse and distributed data assets.
• Optim Development Studio: Provides a complete development and testing environment for building database objects, queries, database logic, and Java™ pureQuery applications.
• Optim pureQuery Runtime: Delivers a high-performance data access platform that provides the capability to visualize, optimize, and lock down SQL without modifying the application. Complements Optim Development Studio by enabling pureQuery support in production systems, including support for static execution of .NET and Java applications.
• Optim Database Administrator: Manages complex structural changes while preserving data, privileges, dependent objects, and application bindings.
• Optim High Performance Unload: Formerly known as DB2 High Performance Unload, provides a high-speed unload utility as an alternative to the export feature. Whether used alone or with Optim Database Administrator, this product significantly reduces the time required to migrate databases.
• DB2 Merge Backup: Shortens recovery time on production servers, ensures full backups are available as needed, and enables organizations to reduce resources and outages for full backups.
• DB2 Recovery Expert: Localizes recovery processes to impacted objects in order to reduce outages without having to resort to full database recovery.
• Optim Performance Manager offerings: Provides a comprehensive and proactive performance-management solution to help you identify, diagnose, solve, and prevent database performance issues for applications that access DB2 databases on Linux®, UNIX®, or Windows®.
• Optim Query Tuner offerings: Includes single-query tuning for both DB2® for z/OS® and DB2 for Linux, UNIX, and Windows. For DB2 for z/OS, you can extend the capability to entire SQL workloads using Optim Query Workload Tuner for DB2 for z/OS (formerly DB2 Optimization Expert for z/OS). These products provide a set of advisors and tools to help make it easier to tune SQL.

While there are more products that are part of the lifecycle management portfolio, including InfoSphere Optim Test Data Management solutions and InfoSphere Optim Data Growth solutions, this article focuses only on the listed products.

Back to top

Viewing supported databases

Optim is the family name for a portfolio of products used to deliver a modular, integrated data management environment for managing data across its lifecycle. As part of this definition, IBM considers providing heterogeneous solutions a must to ensure that you can get the highest levels of productivity. While not all the InfoSphere Optim products currently provide full heterogeneous support, the strategic vision for InfoSphere Optim products is to provide heterogeneous support in the future. Table 2 shows which database servers each product in this article supports.

¹Only supported for Java

²ASE 15 only

Back to top

Understanding the packaging

IBM Data Studio is a downloadable product that contains no-charge capabilities and supports the DB2 family and Informix® database servers. It provides database developers and DBAs with the basic set of required tools for database development and administration, including an Eclipse-based client (known as Data Studio) and a server-based monitoring application (known as Data Studio Health Monitor).

The Data Studio Eclipse-based client is available in two different packaging options (see Resources for links to the downloads):

• The stand-alone package is a lighter-weight offering designed specifically for administrators to get up and running quickly and easily. This package is a proper subset of its sibling as of the 2.2.1 release.
• The integrated development environment (IDE) package targets developers or DBAs who require an integrated (shell sharing) Eclipse development environment for Java, XML, and web services. (All of these capabilities are also available in Optim Development Studio.) Also, this package is designed for anyone who wants to shell-share this package with compatible Eclipse-based products, such as InfoSphere Data Architect, Optim Query Tuner, or Rational Application Developer. See the Technote in Resources for compatibility information regarding Eclipse offerings.

The capabilities of the stand-alone package compared to the IDE package (as of Version 2.2.1.1) are shown in Table 3.

The Data Studio Health Monitor provides database health monitoring, notification, and status displays for monitored databases. Health monitoring is focused on assuring that there are no blocking conditions in the database, such as out-of-storage conditions, that would prevent applications from running. Performance monitoring capabilities are provided by purchasable offerings, including Optim Performance Manager

Back to top

Exploring additional capabilities

The rest of this article focuses on the additional capabilities you get over the IBM Data Studio no-charge capabilities. For example, although SQL scripts and stored procedure development are included in Data Studio, pureQuery development capabilities are included only in Optim Development Studio. Basic schema management is in Data Studio, but you need Optim Database Administrator for handling complex schema changes.

Back to top

InfoSphere Data Architect

Overview

Although not named Optim, IBM InfoSphere Data Architect 7.5.3 plays a key role in managing data across its lifecycle. It provides enterprise data modeling and integration design modeling to help data architects to understand information assets and their relationships, to design federated databases, and to 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 capability 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

Table 4 shows some of the key features of InfoSphere Data Architect as of 7.5.3. For basic visualization of physical databases, the no-charge option in Data Studio does include physical overview diagrams.

Getting the product

InfoSphere Data Architect is a priced offering. If you are already an InfoSphere Data Architect or Rational Data Architect customer, you are automatically entitled to download the 7.5.3 version (of InfoSphere Data Architect) from Passport Advantage. InfoSphere Data Architect is now included with select versions of InfoSphere Data Warehouse (see the InfoSphere Warehouse Advanced Enterprise Edition announcement letter in Resources).

If you are not a current customer, you can download a 30-day trial from developerWorks (see Resources). After the trial 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, contact an authorized IBM Business Partner, or purchase online (see Resources).

Changes in V7.5.3 and 7.5.3.1

• Enhanced multi-dimensional modeling, including automatic discovery and notation of facts, measures, dimensions, and outriggers. The new release also includes the automatic de-normalization of operational data for designing warehouses.
• Lossless integration with InfoSphere Warehouse and Cognos® Framework Manager.

Back to top

Optim Development Studio and pureQuery Runtime

Overview

IBM Optim Development Studio provides an integrated development environment for creating and testing database and Java applications that access DB2, Informix, Oracle, or Sybase databases. Combined with pureQuery Runtime, Optim Development Studio provides a data access layer for Java-based applications to ease development coding and to 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 that access DB2, IDS, or Oracle databases.
• Develop and debug stored procedures using SQL/PL and PL/SQL.
• 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 by directing you to the relevant place in the source code.
• Eliminate SQL injection risk by allowing only approved SQL to be executed.
• Deploy efficient SQL by examining new SQL metrics, including number of executions, aggregated elapsed time, and minimum and maximum execution times, to help identify hot spots in the application.
• Integrate with Optim Performance Manager for problem SQL identification and improved problem isolation.
• Replace poorly performing SQL with a more optimal SQL statement without modifying the program source code.
• Use the SQL Repository Perspective to manage the work flow of static SQL, and manage captured SQL by application using the SQL Repository.
• Deploy procedures, functions, and SQL scripts across multiple databases to facilitate keeping development and test databases synchronized.

Optim pureQuery Runtime also supports the capability to run existing .NET and CLI applications against DB2 using static SQL, which can lead to reduced CPU and enhanced performance over dynamic access.

Features

Table 5 shows some of the key features of Optim Development Studio and pureQuery Runtime and how they complement the basic capabilities in Data Studio.

Getting the product

If you are already an Optim Development Studio and Optim pureQuery Runtime customer, you are automatically entitled to download the 2.2.1 versions of those products from Passport Advantage. Optim Development Studio is now included with select versions of DB2 for Linux, UNIX, or Windows, InfoSphere Data Warehouse, DB2 Connect, and Informix. You can download Optim Development Studio from the Windows or Linux eAssembly of the most recent version of those products on Passport Advantage. A 30-day trial of Optim Development Studio is also available (see Resources). When downloading the Optim Development Studio 2.2.1, you also receive the Optim pureQuery Runtime to use only on your workstation.

To purchase Optim pureQuery Runtime for production use, contact your IBM sales representative, authorized IBM Business Partner, or purchase online (see Resources).

Changes in V 2.2.0.3, V2.2.1, and V2.2.1.1.

Optim Development Studio and Optim pureQuery Runtime now include the following features:

• Improved application SQL management with the SQL repository, as described in the article on fix pack 3 listed in Resources.
• Capability to convert SQL scripts into pureQuery capture files.
• Easier synchronization of application logic across development and test databases using a deployment manager to deploy procedures, functions, and SQL scripts.
• Integration with Optim Performance Manager Extended Edition in order to import performance metrics for problem SQL identification and to export application metadata to facilitate problem isolation to specific Java source code.
• Support for Sybase and the ANTs Software product IBM DB2 SSacSA.

Back to top

Optim Database Administrator

Overview

If your job involves managing database changes, you can make good use of the expanded change management functions now included in Optim Database Administrator. Although the no-charge Data Studio can provide simple DDL functionality, you need the full Optim Database Administrator to perform extended alters (those alters that require a drop and recreate) and to compare and synchronize test databases to production databases. Optim Database Administrator does the following:

• Manages complex structural changes while preserving data, privileges, dependent objects, and application binding.
• Compares and synchronizes schemas with custom mapping features.
• Migrates database objects, data, and privileges and generates maintenance utility commands
• 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

Features

Table 6 shows some of the key features of Optim Database Administrator as of Version 2.2.3 when compared with no-charge Data Studio. Popular functions from the DB2 Control Center are included in Data Studio. The full Optim Database Administrator product expands on basic DDL generation with features that include extended alter, migrate, and compare.

Getting the product

If you are a current Optim Database Administrator or Data Studio Administrator customer, you are automatically entitled to download the 2.2.3 version of this product from Passport Advantage. Optim Database Administrator is now included with select versions of DB2 and InfoSphere Data Warehouse (see the DB2 Advanced Enterprise Server Edition announcement letter in Resources). You can download Optim Database Administrator from an appropriate eAssembly for Windows or Linux on Passport Advantage. If you are not a current customer, you can download a 30-day trial (see Resources). When the trial license expires, 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 (see Resources).

Changes in V2.2.3 and 2.2.3.1

• Catalog navigation enhancements, including the Administration Explorer.
• Object List Editor, customization, and performance improvements.
• Enhanced compare filtering,
• Table data editor enhancements for DB2 databases

Back to top

Optim High Performance Unload

Overview

Optim High Performance Unload for DB2 for Linux, UNIX, and Windows (formerly DB2 High Performance Unload) provides high-speed unloading, extracting, and repartitioning of data. DB2 High Performance Unload remains available as a separate product for DB2 z/OS databases. It helps database administrators to work with very large quantities of data with less effort and with faster results. Optim High Performance Unload can:

• Enable creation of customizable unloads with use of SELECT syntax to filter columns and rows.
• Scale, with support for partitioned databases and the capability to unload to multiple directories in parallel.
• 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. When you purchase Optim High Performance Unload, you can also execute high-performance unload directly from the Data Studio console. See Table 7 for more details.

Getting the product

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 you would like to purchase the product (or obtain a trial license), contact your IBM sales representative or authorized IBM Business Partner. To purchase the product or obtain a trial license, contact your IBM sales representative, authorized IBM Business Partner, or purchase online (see Resources).

Changes in V4.2

The newest version of Optim High Performance Unload V4.2 provides support for the highly scalable DB2 pureScale. There are also a number of user enhancements such as the capability to unload from a schema, which gives you more options to quickly unload data than the standard approach. For more information, see the full announcement listed in Resources.

Back to top

DB2 Recovery Expert

Overview

DB2 Recovery Expert for Linux, UNIX and Windows recovers database objects safely, precisely, and quickly without having to resort to full database recovery. It can help you avoid accidental data loss or corruption by providing a faster, less costly method of recovery.

The log analysis features enable organizations to monitor database changes and to provide intelligent analysis of altered, incorrect, or missing database assets.

Database administrators can use the product to do the following:

• Get very granular with database object recovery automating the recovery even as the system remains online.
• Automate the process of rebuilding these assets to a specified point in time.
• Determine the most efficient technique for a recovery situation.
• Recover database objects without using resource intensive disaster recovery.
• Analyze and provide diagnostics of altered, incorrect, or missing database assets, including tables, indexes, or data.
• Roll back unwanted data changes precisely throughout a database.

Features

Table 8 shows some of the main features of DB2 Recovery Expert as compared to the no-charge Data Studio. You can see that many of the advanced recovery capabilities are available in DB2 Recovery Expert.

Getting the product

If you are already a DB2 Recovery Expert for MultiPlatforms V2.1 customer, you are automatically entitled to download the 3.1 version from Passport Advantage. If you are not a current customer and you would like to purchase the product, contact your IBM sales representative or authorized IBM Business Partner (see Resources). There is also a 30-day trial version of DB2 Recovery Expert available on the product website.

Back to top

DB2 Merge Backup

Overview

DB2 Merge Backup for Linux, UNIX, and Windows reduces DB2 backup times for your production system. This ensures that your backup and recovery strategy lines up with your service level agreements (SLAs) for accuracy and responsiveness.

DB2 Merge Backup merges incremental and delta backups with the latest full backup to create a new, more current full backup. You essentially never have to take a full backup again.

Database administrators can use the product to do the following:

• Ensure a complete, accurate DB2 backup even as data volumes grow.
• Provide the necessary recovery assets with low production impact.
• Perform backup processes with minimal impact on production systems to support business objectives.
• Develop a scalable approach to responding to unplanned service interruptions.

All this processing runs outside and independently of the current DB2 process. If a restore is later required, DB2 Merge Backup can help to speed the recovery.

Features

Table 9 shows some of the main features of DB2 Merge Backup as compared to the no charge Data Studio. You can see that a lot of the advanced capabilities with respect to your backup are contained in DB2 Merge Backup.

Getting the product

If you are not a current customer and you would like to purchase the product, contact your IBM sales representative or authorized IBM Business Partner (see Resources). There is also a 30-day trial version of DB2 Merge Backup (see Resources).

Back to top

Optim Performance Manager Extended Edition

Overview

IBM Optim Performance Manager Extended Edition for DB2 for Linux, UNIX, and Windows provides in-depth database monitoring, problem isolation, and trend analysis for DB2 for Linux, UNIX, and Windows databases. Database administrators can use the product to:

• Quickly identify potential problems using interactive, detailed dashboards that can detect overall environment problems or specific database or application issues. Alerts can be read more easily on a new Health Summary dashboard as well as on other diagnostic dashboards. Alerts can be sent using email or pager to the on-call administrator when problems reach warning and error thresholds.
• Gain unprecedented insight into the database transaction software stack when running Java or CLI applications, including the database client, the application server, and the network, giving immediate insight into where database workloads, transactions, and SQL requests are spending their time. The product Includes out-of-the-box configurations for SAP, WebSphere®, Cognos, InfoSphere DataStage®, and InfoSphere SQL Warehouse applications.
• Enhance Tivoli® monitoring solutions, such as ITCAM for Transactions, to provide detailed database diagnostics while remaining in the context of the overall enterprise application. This reduces the time and effort needed to diagnose and trace a problem from the application through to the database server.
• Launch into Optim Query Tuner (if installed) directly from SQL-related dashboards to do immediate tuning of problematic SQL, closing the loop on performance problem resolution.
• Prevent performance problems using out-of-the-box, interactive reports for trend analysis and growth planning using a powerful repository of historical performance metrics.
• Monitor DB2 Workload Manager (WLM) entities, statistics, and activities over time to validate WLM definitions, which can be set up and defined using integrated WLM configuration tooling.

For more details on the features and enhancements, see the developerWorks article "What’s new in Optim Performance Manager Extended Edition" listed in Resources.

Features

Optim Performance Manager is available in multiple editions: Enterprise Edition, Workgroup Edition, Content Manager Edition, and Extended Edition. The first three editions contain the same function with differing license terms reflecting the environments to which they are targeted. Those three editions replace DB2 Performance Expert for Linux, UNIX, and Windows. Optim Performance Manager Extended Edition is a superset of the others, and it includes the Extended Insight feature that provides transaction response time monitoring, Tivoli integration, and enhanced DB2 Workload Manager features. Table 10 provides a visual overview of the features available in Data Studio Health Monitor, Optim Performance Manager Enterprise Edition, Optim Performance Manager Workgroup Edition, Optim Performance Manager Content Manager Edition, Optim Performance Manager Extended Edition, and DB2 Performance Optimization Feature.

Note: Q-replication monitoring capability is available as a separate, no-charge download (see Resources).

Getting the product

• Optim Performance Manager editions are available to customers whose subscriptions are current on Passport Advantage.
• If you are a DB2 Performance Expert customer who is current on maintenance, you are automatically entitled to download the equivalent 4.1 edition of Optim Performance Manager from Passport Advantage (that is, Enterprise Edition, Workgroup Edition, or Content Manager Edition).
• If you own the DB2 Performance Expert Extended Insight Feature, you can download Optim Performance Manager Extended Edition.
• Optim Performance Manager Enterprise Edition is available as part of DB2 Advanced Enterprise Server Edition and InfoSphere Warehouse Departmental Edition. Download Optim Performance Manager from the respective e-assemblies on Passport Advantage.
• Optim Performance Manager Extended Edition is also available as part of the DB2 Performance Optimization Feature, which is included in InfoSphere Warehouse Enterprise Edition and Advanced Enterprise Edition. Download Optim Performance Manager from the respective e-assemblies on Passport Advantage.
• If you are not a current customer, to purchase the product or obtain a trial license, contact your IBM sales representative, authorized IBM Business Partner, or purchase online (see Resources).

Changes in V4.1.0.1 and V4.1.1

• Up-and-running simplification, including an integrated console server
• pureScale-specific monitoring enhancements
• More flexible partition monitoring capabilities
• Integrated health monitoring
• More flexible alert management
• Enhanced Tivoli integration
• Optim Development Studio integration to pinpoint SQL source code

Back to top

Optim Query Tuning solutions

Overview

Optim query tuning solutions provide an environment to identify and tune poorly performing SQL statements with advisors and tools to help guide you to a solution. Formerly known as DB2 Optimization Expert for z/OS, Optim Query Workload Tuner for DB2 for z/OS provides this support for both single SQL statements and for SQL workloads to help database administrators make the best decision to optimize entire workloads. A subset of functionality is available for both DB2 for z/OS and DB2 for Linux, UNIX, and Windows. Both Optim Query Tuner for DB2 for Linux, UNIX, and Windows and Optim Query Tuner for DB2 for z/OS focus on single query tuning. They can help developers and application database administrators focus on query tuning efforts early in the development cycle.

Some query tuning and query formatting capabilities are available at no charge in Data Studio for both DB2 for z/OS and for DB2 for Linux, UNIX, and Windows. For z/OS, the previous no-charge tool, Optimization Service Center, has been deprecated, which means that no new development is occurring on that product.

Features

Table 11 provides a visual comparison of Optimization Service Center for DB2 for z/OS, Data Studio, Optim Query Tuner, and Optim Query Workload Tuner.

¹OSC integrates only with Query Monitor

Getting the product

Optim Query Tuner offerings are available in the following versions:

• Optim Query workload Tuner for DB2 for z/OS provides tuning advice for single queries and query workloads.
• Optim Query Tuner for DB2 for z/OS provides tuning advice for single queries.
• Optim Query Tuner for DB2 for Linux, UNIX, and Windows provides tuning advice for single queries

If you are already a DB2 Optimization Expert for z/OS customer, you are automatically entitled to obtain Optim Query Workload Tuner for DB2 for z/OS. Optim Query Tuner for DB2 for Linux, UNIX, and Windows is now included with select versions of InfoSphere Data Warehouse (see the InfoSphere Warehouse Advanced Enterprise Edition announcement letter in Resources). Otherwise, you must purchase a license from IBM to use any of the query tuning products. See your IBM Sales Representative or see Resources for more information about purchasing this product.

Changes in V2.2.1 and 2.2.1.1

The new release includes a streamlined UI for query tuning workflow plus additional support in validating and establishing the DB2 environment to use the query tuning features. The fixpack introduces a new access plan explorer to provide textual-based explain detail to ease navigation and analysis of very large queries resulting from enhanced query captures from DB2 Query Monitor or resulting from user-defined SQL repositories.

Back to top

Conclusion

Acknowledgment

Thank you to Deb Jenson and Kathy Zeidenstein from IBM for writing, updating, and reviewing previous versions of this article.

Resources

Learn

• Start with "Integrated Data Management: Managing data across its lifecycle" (developerWorks, updated Apr 2010) for an article that explains both the vision and reality of integrated data management and how you can use Optim Solutions today to improve productivity, increase quality of service, and encourage greater alignment across IT roles.
  
  
• Check out "What’s new in Optim Performance Manager Extended Edition 4.1" (developerWorks, updated Feb 2011) for a good technical overview of this key product.
  
  
• Read "What's new and cool in Optim Development Studio, Part 2: Exploring Optim Development Studio and pureQuery Runtime Version 2.2 Fix Pack 3” (developerWorks, Jun 2010) to learn about the SQL repository to improve manageability of SQL that is captured using pureQuery Runtime.
  
  
• Watch the demo "Optim Performance Management Solution" (developerWorks, updated Jul 2011) to see how one fictional company uses Optim solutions to accelerate problem determination, performance, and development.
  
  
• Watch the demo "Integrating Optim Performance Manager Extended Edition for DB2 with ITCAM for Transactions" for a quick demonstration of the value of this integration.
  
  
• Watch the demo "Efficient backup and recovery with DB2 Advanced Recovery Solution" to see how to use DB2 Merge Backup, Optim High Performance Unload, and DB2 Recovery Expert to improve backup and recovery procedures.
  
  
• Watch Randy demonstrate in more detail "Tivoli and Optim Performance Manager Extended Edition Integration" in this 5-part series.
  
  
• Watch the demo "pureQuery for z/OS: Improve ROI for existing applications" (developerWorks, 2010 Jan) to follow along with a DBA who measures performance improvement before and after applying the nondisruptive pureQuery client optimization technology to an existing Java application.
  
  
• Watch the demo "DB2 DBA solutions by Optim" (developerWorks, Jun 2010) to see how a DB2 DBA uses the InfoSphere Optim solutions to address a variety of data management requirements and challenges.
  
  
• Watch the demo "Efficient multidimensional data modeling with InfoSphere Data Architect” (developerWorks, Nov 2010) to learn about creating a model for a new data mart.
  
  
• Refer to the following announcement letters:
  • InfoSphere Data Architect 7.5.3
  • Optim Development Studio, Optim Database Administrator, and Data Studio Administrator V2.2
  • Optim Database Administrator V2.2.2
  • Optim High Performance Unload for DB2 for Linux, UNIX, and Windows 4.2
  • Optim Performance Manager and Optim Performance Manager Extended Edition 4.1
  • Optim Query Tuner for Linux, UNIX, and Windows
  • Optim Query Workload Tuner for z/OS 2.2.1
  
  
• Refer to the IBM Support Technote Product compatibility matrix for eclipse-based products.
  
  
• Refer to DB2 Version 9.5 features and functions by edition.
  
  
• See Components of InfoSphere Warehouse.
  
  
• Explore the developerWorks Optim family page to learn more about Optim solutions. Find technical documentation, how-to articles, education, downloads, product information, and more.
  
  
• Download the 30-day trial of DB2 Merge Backup.
  
  
• Learn more about Information Management at the developerWorks Information Management zone. Find technical documentation, how-to articles, education, downloads, product information, and more.
  
  
• Stay current with developerWorks technical events and webcasts. Check out virtual technical briefings around the Optim integrated data management portfolio.
  
  

Get products and technologies

• Download the Data Studio and Optim trial and no-charge software.
  
  
• Download the no-charge Data Studio software.
  
  
• Download the Optim pureQuery Runtime as part of the Optim Development Studio trial download.
  
  
• Download the Data Studio Administrator 30-day trial download.
  
  
• Download the InfoSphere Data Architect 30-day trial from developerWorks.
  
  
• Download the 30-day trial of Optim Development Studio.
  
  
• Download the Q-replication monitoring as a separate download.
  
  
• Order products online:
  • InfoSphere Data Architect
  • Optim Development Studio
  • Optim pureQuery Runtime for Linux, UNIX, and Windows
  • Optim pureQuery Runtime for z/OS
  • Optim Database Administrator
  • Optim High Performance Unload for DB2 for Linux, UNIX, and Windows
  • DB2 Merge Backup
  • Optim Query Workload Tuner for DB2 for z/OS and other z/OS query tuning products
  • Optim Query Tuner for DB2 for Linux, UNIX, and Windows
  • Optim Performance Manager and Optim Performance Manager Extended Edition
  
  

Discuss

• Participate in the discussion forum.
  
  
• Refer to the following Holly Hayes blog entries:
  • New Optim and Data Studio Fix Packs and mod releases – Check them out!
  • DB2 Advanced Recovery Solution for Linux, UNIX and Windows
  • New Optim fixpacks with cool function added
  
  
• Check out the Managing the Data Lifecycle blog.
  
  
• Check out the developerWorks blogs and get involved in the developerWorks community.
  
  

About the authors

Holly Hayes is a Program Director for the Optim Solutions team. A 29-year IBM veteran, she has held development, strategy, marketing, and management positions working with operating systems microcode, replication technology, data warehouse infrastructure, database management, and information integration technology. She has been a prominent speaker at industry events and customer briefings and a frequent contributor to industry articles, analyst research, and other publications. She holds a U.S. patent in replication technology.

Anson Kokkat works at IBM as a Product Manager in the Optim Database Tools Group. Anson's professional career spans more than 12 years during which time he worked on application development technologies related to data servers. He has an extensive background working as a product manager for the IBM data modeling tool InfoSphere Data Architect. Now Anson concentrates on creating a marketplace for Database Backup and Recovery Tooling Solutions. He has written many articles and whitepapers related to his expertise, and he continues to work with sales, marketing, development, and especially customers out in the field.

Rate this article

Comments

Back to top

Table of contents

• Introduction
• Exploring InfoSphere Optim solutions for data lifecycle management
• Viewing supported databases
• Understanding the packaging
• Exploring additional capabilities
• InfoSphere Data Architect
• Optim Development Studio and pureQuery Runtime
• Optim Database Administrator
• Optim High Performance Unload
• DB2 Recovery Expert
• DB2 Merge Backup
• Optim Performance Manager Extended Edition
• Optim Query Tuning solutions
• Conclusion
• Resources
• About the authors
• Comments

Next steps from IBM

• Try: Data Studio
• Demo: Use Ajax with DB2
• Briefing: Virtual tech briefings on integrated data management
• Community: DB2
• Buy: Data Studio

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.

Special offers