DB2 Version 9.7 for Linux, UNIX, and Windows

Control Center tools have been deprecated

Starting in Version 9.7, the Control Center tools have been deprecated and might be removed in a future release.

Details

You can use instead IBM® Data Studio and the IBM InfoSphere® Optim™ tools for managing DB2® for Linux, UNIX, and Windows databases and developing data-centric applications. For more information about these recommended tools, see Resolution.

The following Control Center tools and related features have been deprecated:
  • Activity Monitor
  • Command Editor
  • Configuration Assistant
  • Control Center and associated wizards and advisors
    • Add Partitions launchpad
    • Alter Database Partition Group wizard
    • Backup wizard
    • Configuration advisor
    • Configure Database Logging wizard
    • Configure Multisite Update wizard
    • Create Cache Table wizard
    • Create Database wizard
    • Create Federated Objects wizard (Also known as Create Nicknames wizard)
    • Create Table Space wizard
    • Create Table wizard
    • Design advisor
    • Drop Partition launchpad
    • Health Alert Notification
    • Health Indicator Configuration launchpad
    • Load wizard
    • Recommendation advisor
    • Redistribute Data wizard
    • Restore wizard
    • Set Up Activity Monitor wizard
    • Set Up High Availability Disaster Recovery (HADR) Databases wizard
    • Storage Management Setup launchpad
    • Troubleshooting wizard
  • Control Center plug-in extensions
  • Event Analyzer
  • Health Center
  • Indoubt Transaction Monitor
  • Journal
  • License Center
  • Memory Visualizer
  • Query Patroller Center
  • Satellite Administration Center
  • Task Center
  • User interface to access Spatial Extender functionality
  • User interface to Visual Explain
As a result, the following associated DB2 commands are also deprecated:
  • dasauto (Autostart DB2 administration server command)
  • dascrt (Create a DB2 administration server command)
  • dasdrop (Remove a DB2 administration server command)
  • dasmigr (Migrate the DB2 administration server command)
  • dasupdt (Update DAS command)
  • daslist (Display DAS name command)
  • db2admin (DB2 administration server command)
  • db2am (Start Activity monitor center command)
  • db2ca (Start the Configuration Assistant command)
  • db2cc (Start Control Center command)
  • db2ce (Start Command Editor command)
  • db2daslevel (Show DAS level command)
  • db2eva (Event analyzer command)
  • db2hc (Start Health Center command)
  • db2indbt (Start Indoubt Transaction Monitor Center command)
  • db2journal (Start Journal command)
  • db2lc (Start License Center command)
  • db2memvis (Start Memory Visualizer center command)
  • db2tc (Start Task Center command)

The Replication Center has not been deprecated. It is still available as part of the Replication tools.

Resolution

Start using the AUTOCONFIGURE command to get recommendations from the configuration advisor. Although the wizard interface for the configuration advisor is still supported, this wizard is deprecated and might be removed in a future release.

Start using the db2advis command to get recommendations from the design advisor. Although the wizard interface for the design advisor is still supported, this wizard is deprecated and might be removed in a future release. The design advisor is not deprecated.

The deprecated Control Center tools and related features are still supported in Version 9.7. Only Version 9.7 DB2 servers or earlier releases are supported. However, you should consider becoming familiar with the IBM Data Studio and IBM InfoSphere Optim tools and start using them in place of the Control Center tools. For more information, see Data management and application development tools.

IBM Data Studio and IBM InfoSphere Optim tools are available to perform similar tasks that you used to perform with the Control Center tools. These recommended tools provide enhanced features for those tasks.

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

Table 1. IBM tool by IBM product edition
IBM tool IBM product editions that include the tool
IBM Data Studio All DB2 database products, excluding DB2 Express-C, and all IBM InfoSphere Warehouse product editions
IBM InfoSphere Optim Performance Manager Enterprise Edition DB2 Advanced Enterprise Server Edition, DB2 Database Enterprise Developer Edition, IBM InfoSphere Warehouse Departmental Edition, and IBM InfoSphere Warehouse Advanced Departmental Edition
IBM InfoSphere Optim Performance Manager Extended Edition IBM InfoSphere Warehouse Enterprise Edition and IBM InfoSphere Warehouse Advanced Enterprise Edition
IBM InfoSphere Optim Query Workload Tuner IBM InfoSphere Warehouse Advanced Enterprise Edition
The following table shows the recommended tools to use in place of the Control Center tools.
Table 2. Recommended tools versus Control Center tools
Control Center tool IBM tool Links to additional information

Activity Monitor

Event Analyzer

IBM InfoSphere Optim Performance Manager

Added benefits:

Command Editor

IBM Data Studio2

Configuration assistant

IBM InfoSphere Optim Configuration Manager

Control Center

IBM Data Studio

Relevant information:
Added benefits:

Control Center associated wizards and advisors

IBM Data Studio

The Task assistants provide similar functionality to the Backup, Configure database logging, Create database, Load, Restore, and Set up HADR wizards in the Control Center tools. See Administering databases with task assistants at http://pic.dhe.ibm.com/infocenter/dstudio/v4r1/topic/com.ibm.datatools.adm.doc/topics/chxutrundbadmcmds.html.

Added benefits:

Health Center

IBM Data Studio web console

IBM Data Studio web console

IBM InfoSphere Optim Performance Manager

Relevant information:
Added benefits:

Memory Visualizer

IBM InfoSphere Optim Performance Manager

Relevant information:
Added benefits in InfoSphere Optim tools:

Query Patroller Center

IBM InfoSphere Optim Performance Manager

Added benefits:

Task Center

IBM Data Studio

Added benefits:

User Interface to Spatial Extender

IBM Data Studio

Access to Spatial Extender functionality from the Control Center is deprecated. Alternatively, you can use the InfoSphere Optim tools or DB2 CLP commands to perform similar tasks.

Added benefits:

Visual Explain

IBM Data Studio

Use the SQL and XQuery editor, which provides access to Visual Explain and enhanced query tuning capabilities. For more information, see Diagramming access plans with Visual Explain at http://pic.dhe.ibm.com/infocenter/dstudio/v4r1/topic/com.ibm.datatools.visualexplain.data.doc/topics/tvetop.html.

Added benefits:
Notes:
  1. 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.
  2. IBM Data Studio consist of three components. You can install any combination of these components and DB2 database products into a common shared environment.
  3. The Index Advisor and Query Advisor require an active license for IBM InfoSphere Optim Query Workload Tuner.