IBM Data Studio client overview

The Data Studio client is built on Eclipse technology and provides an integrated development environment for database and instance administration, routine and Java™ application development, and query tuning.

The IBM® Data Studio client is one of two Data Studio components: the client and the web console. 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.

The Data Studio client includes 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 tools

The following tools can help you get started with the Data Studio client:

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:

Query tuning features

With the Data Studio client, you can format SQL statements so that they are easier to read, generate visual representations of access plans, and get recommendations for collecting statistics on the objects that a statement references. You can also generate a report that summarizes information about the access plan and includes the recommendations.

If you connect the Data Studio client to a DB2 database or subsystem on which a license for InfoSphere® Optim™ Query Workload Tuner is active, you can use the full set of tuning features.

For more information, see Tuning features.

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:

Shell-sharing with other Eclipse-based products

Shell-sharing (sharing a common environment) with other Eclipse-based products makes it easy to share the functions between products from one interface. If you install the Data Studio client into the same product group as a compatible product, you install only one version of Eclipse that shares the components of each product. Shell-sharing saves disk space and avoids duplicating components that are already built into other products.

Another benefit of shell sharing is the ability to have products interact with each other, which makes each product stronger than if they were run alone. For example, the following shell-sharing scenario shows the strength of using InfoSphere Data Architect and Data Studio together:

  1. Shell-share IBM InfoSphere Data Architect with the Data Studio client.
  2. Create glossary models to standardize your naming conventions by using InfoSphere Data Architect.
  3. Use the database administration features of the Data Studio client to ensure that those naming conventions are followed.

To shell-share products, the base Eclipse versions must be the same. For example, you cannot shell-share an Eclipse version 3.4-based product with an Eclipse version 3.6-based product.

For more information about the features in the Data Studio client, see the following documents:
  • Supported data servers by feature: IBM Data Studio provides different features for the supported types of data servers. View this document for information about the supported data servers by feature and details about which features exist in each component of Data Studio.
  • Planning the features to install: You can choose to install the following feature sets during the product installation: Administration, Application Development, or Query Tuning. View this document for information about the features that are included in each set.

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


Feedback