IBM Data Studio client components overview

The IBM Data Studio client is one of two Data Studio components: the client and the web console. The Data Studio client component is built on Eclipse technology and provides a workspace for database administration and application development tasks.
You can install either of two versions of the Data Studio client: the full client or the administration client.

For information about the Data Studio web console component, which you use for job management and health monitoring, see the IBM Data Studio web console overview.

IBM Data Studio offers the following features.

Perspectives
The tools that you use as a database administrator or application developer depend on your perspective. The primary perspective for database administration is the Database Administration perspective, and the primary perspective for application development is the Database Development perspective. Other perspectives that you can use include the Data, Java, SQL and Routine Development, and Query Tuning perspectives.
Getting started
The following tools can help you get started with the Data Studio client:

If you are new to the Eclipse development environment, view the Eclipse Basic tutorial. Click the link, then click the Show in Table of Contents icon Show in Table of Contents icon in the information center to see the entire tutorial.

Several tutorials are available to help you get started with Data Studio. To access tutorials, expand the Tutorials category in the Contents pane of information center.

Use the Task Launcher in the Data Studio client to view and start many getting started tasks and other key tasks in the product. Task Launcher opens when you start Data Studio, or you can open it by clicking Help > Task Launcher.

Database administration features

With the database administration features in the Data Studio client, you can navigate your database catalog, administer your database, and manage changes to your database:

Database catalog navigation
You can use the Administration Explorer and Object List views of the Data Studio client to navigate between your databases and quickly find the database objects that you want. For more information, see Administration Explorer and the Object List overview.
Database administration with task assistants
The Data Studio client simplifies the process of administering your DB2 for Linux, UNIX, and Windows databases by providing task assistants to perform common database administration tasks. The task assistants help you set options for the database administration command, preview the commands that are generated, and run the commands. You use task assistants to perform tasks such as:
  • Starting or stopping an instance or database
  • Configuring an instance or database
  • Creating a database
  • Configuring automatic maintenance, configuring logging, and managing storage for a database
  • Backing up, restoring, recovering, or rolling forward a database or table space
  • Unloading and loading data in a table
  • Reorganizing a table
  • Updating the statistics for a table

For more information, see Administering databases.

Database object management
Changing database objects requires determining which changes need to be made, specifying those changes, evaluating the effects of those changes, and then deploying them.

An editable Properties view and the Review and Deploy dialog box provides a consistent way to create, alter, and drop objects. You can also manage the privileges objects for various types of database servers. After you define your changes in the Properties view, Data Studio automatically generates the commands that can make the changes. The generated commands are displayed in the Review and Deploy dialog box, where you can review the commands and run them.

More robust change management features are provided for DB2 for Linux, UNIX, and Windows databases because a change plan is used to manage the changes. A change plan makes more complex changes possible and you can use it to change more than one object at a time. Data Studio manages the dependent objects and takes resulting actions to address any side effects that are caused by your database object changes. With change plans, you can also preserve your data across database changes, undo your database changes, and track your changes with a version control system.

Data application developer features
For data application developers, Data Studio provides the following key features. Working in a data development project in the Data Project Explorer, you can:
Team features
If you are working on a large team, you can share data development projects by using supported code control systems, and you can share database connection information. For more information, see:

For more details about the installation packages that are available for IBM Data Studio, see the product web page.


Feedback