IBM Data Studio

Simplify database development and administration for IBM database software

Overview

Learn more

Use and maintain

IBM Data Studio helps database developers and administrators manage, administer and develop heterogeneous database environments for increased productivity.

IBM Data Studio provides database developers and DBAs an integrated, modular environment for productive administration of DB2 for Linux, UNIX and Windows. It also provides collaborative database development tools for DB2, Informix, Oracle, and Sybase at no charge. Features and Highlights:

From version 3.1 onwards, IBM Data Studio consolidates Optim Development Studio, Optim Database Administrator and Data Studio Health Monitor into a single eclipse-based offering.
Speed database development and improve standardization using customizable templates to create, test, debug, and deploy routines, such as stored procedures.
Develop with performance in mind, using an enhanced data access development environment, including the ability to view client performance metrics.
Simplify query building, editing, and tuning, including support for XQuery. Format queries, view access plan graphs, and get statistics advice.
Manage objects, analyze dependencies, manage privileges, view data distributions, and update statistics. View, edit, and copy data for testing.
Develop collaboratively by integrating with Rational, InfoSphere, and other Eclipse-based offerings.
Compare and synchronize changes between models, databases, and DDL, and manage change plans to coordinate changes across objects.

View features and benefits