DB2 Version 10.1 for Linux, UNIX, and Windows

Managing your data and applications with the right tools

IBM® Data Studio and the IBM InfoSphere® Optim™ tools can help you in managing your data and applications throughout their entire life cycle. Understanding of the tool functionality can help you choose the right tool for the right task.

The following table shows the main functions contained by IBM Data Studio and the Optim tools:

Table 1. Functions in the Optim tools
IBM tool included with DB2® products or complimentary tools	Function and related references
IBM Data Studio	Administering databases with task assistants Connecting to databases Creating and altering data objects with the Data Object editor Copying database objects Managing data Managing cluster members in DB2 pureScale® environments. See Overview of database administration Modifying privileges Analyzing impact and dependency for data objects Making basic database object changes with a change plan Creating SQL and XQuery statements in the SQL and XQuery editor. See SQL and XQuery statement creation in the SQL and XQuery editor Modifying SQL and XQuery statements in the SQL and XQuery editor Using templates for SQL and XQuery. See Templates for SQL and XQuery Validating SQL and XQuery statements Editing commands manually with the SQL and XQuery editor Generating DDL scripts Diagramming access plans with Visual Explain Collecting statistics for database objects using the Statistics Advisor. See Generating and acting on recommendations for collecting statistics for database objects that are in the access path for an SQL statement Creating or modifying indexes that improve the performance of single SQL statements using the Index Advisor. See Generating and acting on recommendations for indexes for improving the performance of single SQL statements¹ Rewriting queries to resolve the problems that are identified by the Query Advisor. See Generating and acting on recommendations for revising SQL statements for better performance¹ Job management Creating and managing jobs Managing jobs with the job manager Scheduling command scripts Federated databases Connecting to a federated database Changing federated objects. See Federated object changes Developing applications or routines Developing a Java application that uses pureQuery annotated methods. See Tutorial: Developing a Java application that uses pureQuery annotated methods Deploying routines and SQL scripts to multiple systems. See Deploying routines using deployment groups
IBM Data Studio web console	Monitoring database health and availability. See Monitoring database health and availability² Monitoring status of utilities operating on your databases. For more information, see Use the Current health views. See Use the Current health views Opening Data Studio web console from within the workbench
IBM InfoSphere Data Architect	Working with physical and logical data models. See Logical, physical, and dimensional data modeling Estimating database size Integrating data across data sources
IBM InfoSphere Optim Configuration Manager	Exploring clients and servers Track changes to configurations Acting on clients by using rules
IBM InfoSphere Optim Performance Manager	Monitoring database performance. See Monitoring database performance with the IBM InfoSphere Optim Performance Manager web console Accessing more advanced performance monitoring functionality in IBM InfoSphere Optim Performance Manager 4.1.0.1 or later. See Advanced performance monitoring in Optim Performance Manager (4.1.0.1). Configuring and monitoring DB2 workload manager Finding buffer pools with a low hit ratio and high activity Monitoring profiles and system template descriptions. See Profiles and system templates for monitoring Reporting with InfoSphere Optim Performance Manager
IBM InfoSphere Optim Performance Manager Extended Insight	End-to-end database monitoring for applications (Extended Insight Analysis dashboard). See Overview of InfoSphere Optim Performance Manager and Extended Insight³
IBM InfoSphere Optim Query Tuner	Capturing SQL statements from Optim Performance Manager Creating and deploying optimization profiles for SQL statements that run on DB2 for Linux, UNIX, and Windows Use the following advisors to generate and act on recommendations for: Collecting statistics for database objects using the Statistics Advisor. See Generating and acting on recommendations for collecting statistics for database objects that are in the access path for an SQL statement Reviewing recommendations for improving SQL statement access paths using the Access Path Advisor. See Generating and acting on recommendations for changing the access paths for SQL statements Creating or modifying indexes that improve the performance of single SQL statements using the Index Advisor. See Generating and acting on recommendations for indexes for improving the performance of single SQL statements Rewriting queries to resolve the problems that are identified by the Query Advisor. See Generating and acting on recommendations for revising SQL statements for better performance
IBM InfoSphere Optim Query Workload Tuner	Tuning SQL statements and query workloads
Note: The Index Advisor and Query Advisor require an active license for IBM InfoSphere Optim Query Workload Tuner. IBM InfoSphere Optim Performance Manager contains some of the same basic functionality provided by IBM Data Studio web console, plus more advanced monitoring functions. IBM InfoSphere Optim Performance Manager Extended Insight is a separately priced feature for IBM InfoSphere Optim Performance Manager. It is part of IBM InfoSphere Optim Performance Manager Extended Edition.

If you previously used the Control Center tools, review the mapping between the recommended Optim tools and Control Center tools is available. See Table of recommended tools versus Control Center tools.

The following table provides details about IBM tools included in DB2 database product editions:

Table 2. IBM tool by IBM product edition
IBM tool	DB2 product editions that include the IBM tool
IBM Data Studio	All DB2 database products, excluding DB2 Express-C All IBM InfoSphere Warehouse product editions
IBM InfoSphere Data Architect	DB2 Advanced Enterprise Server Edition IBM Database Enterprise Developer Edition
IBM InfoSphere Optim Configuration Manager	DB2 Advanced Enterprise Server Edition IBM Database Enterprise Developer Edition
IBM InfoSphere Optim Performance Manager Extended Edition	DB2 Advanced Enterprise Server Edition IBM Database Enterprise Developer Edition
IBM InfoSphere Optim pureQuery Runtime	DB2 Advanced Enterprise Server Edition IBM Database Enterprise Developer Edition DB2 Connect™ Unlimited Edition for System z® DB2 Connect Application Server Advanced Edition
IBM InfoSphere Optim Query Workload Tuner	DB2 Advanced Enterprise Server Edition IBM Database Enterprise Developer Edition