IBM Data Studio
IBM Data Studio is a set of tools for managing enterprise data, databases, and data-driven applications. 
IBM Data Studio is being replaced by Db2 Administration Foundation and Db2 Developer Extension.
- Db2 Administration Foundation provides Db2 for z/OS database administrators who have minimal z/OS or Db2 experience with a modern, browser-based interface for working with Db2 subsystems and their catalogs.
- Db2 Developer Extension is a free downloadable extension for Microsoft Visual Studio Code that provides SQL language support to a modern and widely adopted IDE. Db2 Developer Extension introduces capabilities that help application developers to quickly write syntactically correct SQL for Db2 for z/OS.
IBM Data Studio includes the following tools:
- IBM InfoSphere Data Architect
- Optim™ Database Relationship Analyzer
- IBM Data Studio
- IBM Optim pureQuery Runtime
- IBM Data Studio Administrator
- IBM® IBM OMEGAMON for Db2 Performance Expert on z/OS
- IBM Database Encryption Expert
- Db2 High Performance Unload for z/OS
IBM Data Studio can help you perform a wide range of daily activities. You can use IBM Data Studio to manage Db2 databases on different operating systems.
Database administration
You can use IBM Data Studio to administer Db2 instances, Db2 for z/OS subsystems, databases, and database objects from workstation computers. You can also run utilities that reorganize or load your data in your existing Db2 for z/OS databases.
Application development and deployment
You can use IBM Data Studio for the following application development tasks:
- Developing pureQuery® applications in a Java™ project
- Creating, testing, debugging, and deploying routines, such as stored procedures and user-defined functions
- Creating, editing, and running SQL queries
- Connecting to data sources and browsing data objects and their properties
- Creating and altering data objects
Query analysis and performance optimization
IBM Data Studio provides query serviceability and tuning capabilities from workstation computers for queries that run in Db2 for z/OS environments. You can use IBM Data Studio to for the following query optimization tasks:
- View query activity and identify problematic queries.
- Get tuning recommendations for statistics that could improve query performance.
- Graph the access path for a query.
- Graphically generate optimization hints.
- Generate reports with information about tables and predicates that are associated with a particular query.
- View the values of subsystem parameters.