Streamline database development and improve enterprise standardization
- Use customizable templates and editors to create, test, debug, and deploy routines, such as stored procedures and user-defined functions.
- Simplify query building, editing, and tuning, including support for XQuery; format queries, view access plan graphs, and get statistics advice.
- Manage objects and privileges: create, alter, and drop objects, analyze dependencies, manage privileges of users, groups, and roles on data objects, view data distributions, and update statistics on those objects.
Save time and reduce errors for managing production deployments
- Create, schedule, and track command scripts and utilities.
- Configure databases, autonomic maintenance, and High Availability Disaster Recovery (HADR) across standard, Database Partitioning Feature (DPF), and pureScale topologies.
- Reverse engineer databases into physical models, compare and synchronize changes between models, databases, DDL, and manage change plans to coordinate changes across objects.
Maximize collaboration across roles
- IBM Data Studio offers collaborative development environment integrating with Rational Application Developer, InfoSphere Data Architect, and Infosphere Optim pureQuery Runtime.
- IBM Data Studio provides advanced administration and development capabilities through consolidation of InfoSphere Optim Database Administrator, Optim Development Studio, and Data Studio Health Monitor capabilities into a single eclipse based offering.
Enhance Productivity
IBM Data Studio now replaces DB2 Control Center and includes additional capabilities:
- Make database object changes with a change plan and manage change using forward engineering from a model; develop Java applications that use pureQuery annotated methods;copy objects from one database to another.
- Run commands on multiple objects, and manage cluster members in DB2 pureScale environment.
- Create and manage jobs, and schedule command scripts configuring email notifications to report on job completion.
- Monitor database health and availability, and status of utilities operating on databases using Web Console accessed from the Data Studio full client.

