Overview
Learn more
Use and maintain
IBM® Data Studio provides foundational database development and administration support for the DB2 and Informix family of products
Data Studio provides developers and DBAs with basic capabilities for database management and development at no charge for DB2 and Informix Dynamic Server (IDS):
- Create, alter, and drop objects, manage privileges, view data distributions, and update statistics on those objects.
- Invoke enhanced administration support for DB2 on Linux, UNIX, and Windows including commands, utilities, and configuration support for pureScale databases.
- Simplify query building and editing, including support for XQuery.
- Speed data development with wizards and editors to create, test, debug, and deploy routines, such as stored procedures and user-defined functions.
- Create Web services that easily expose database operations (SQL SELECT and DML statements, XQuery expressions, or calls to stored procedures) to client applications.
- Install either a small, self-contained administration tool or a fully extensible platform for database development, administration, and tuning. For more information about these two downloadable packages, see Features and Benefits.
