Managing your data and applications with the right tools

IBM® Data Studio, IBM InfoSphere® Data Architect, and IBM Data Server Manager (DSM) 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.

Explore the links in the table below for information on specific solutions:

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 Performance tuning Capturing SQL statements from Optim Performance Manager Creating and deploying optimization profiles for SQL statements that run on Db2 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 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 Data Server Manager (DSM) Attention: Support for IBM Data Server Manager (DSM) is ending on April 30th 2021. Users are asked to migrate from DSM to the IBM Data Management Console (DMC).	Migrating from Optim tools to DSM Migrating from IBM Optim Performance Manager Migrating workloads from Optim Query Workload Tuner (OQWT) Monitoring your databases Setting up historical monitoring Monitoring events Monitoring a Db2 HADR configuration Generating performance alerts Performance tuning Tuning queries and workloads Viewing and analyzing tuning recommendations
IBM Data Management Console (DMC)	Overview of DMC What's New Upgrading Upgrading Data Server Manager (DSM) to DMC Setting up and configuring DMC Planning the setup System requirements Setting up DMC Monitoring Monitoring utility (dmctop) Monitoring events Setting up monitoring profile Generating alerts