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.
- The Data Studio full client provides an integrated development
environment for database administration and routine and Java application
development that can be installed with other IBM software products
so that they can share a common environment.
- The Data Studio administration client is an alternative
to the full client that provides a small-footprint, stand-alone integrated
development environment for database administration, and non-Java
routine development.
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 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 .
- 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.
For
more information, see:
- 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.