IBM Data Server Manager
IBM Data Server Manager is an integrated database management tools platform for monitoring performance, tacking configuration changes, and database administration in Db2 for z/OS subsystems. 
IBM Data Server Manager is being replaced by Db2 Administration Foundation and Db2 Developer Extension.
Important: The following tools are replacing IBM Data Studio and IBM Data Server Manager for use with Db2 for z/OS:
- 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.
Database administration
You can use Data Server Manager for the following database administration tasks:
- Managing database objects and changes
- Developing and running SQL scripts
- Job scheduling to automate changes to a database
Query analysis and performance optimization
You can use Data Server Manager for the following query optimization tasks:
- Tuning individual or entire workloads
- Receiving expert recommendations from tuning advisors about statistics, indexes, and performance
- Capturing SQL and workloads from various sources (for example, performance monitor, development environment, or directly from the database)
- Viewing advanced access plan visualization (graph or grid based)
- Using wizards to identify tuning opportunities and assess benefits and impact
- Comparing SQL performance over time by accessing real-time and historical performance metrics
- Creating reports to share findings or as input for trend analysis and capacity planning
- Resolving availability and performance problems in your system based on alerts
Configuration management
You can use Data Server Manager for the following configuration management tasks:
- Tracking configuration changes for monitored databases
- Comparing configurations between two databases
- Cloning configurations from one database to another
- Getting insights into IT deployments
- Enforcing database connection properties from a central location
- Redirecting database access to another database
Autonomic management
You can use Data Server Manager for the following autonomic management tasks:
- View and manage the overall health of Db2 for z/OS systems across the enterprise
- Access identified Db2 for z/OS symptoms and recommended actions
- View resource dashboards that consolidate information from various sources and tools with data sharing groups and individual table space and index space partitions
- Pinpoint and navigate to resources with the highest severity symptoms and actions
Storage optimization
You can use Data Server Manager for the following storage optimization tasks:
- Review storage accesses over time
- Identify how often instances, schemas, tables, indexes, and table spaces are accessed or modified
- View details for historical accesses and take suggested actions (for example, configuring adaptive or static compression to realize potential storage savings)