IBM Data Server Manager

IBM® Data Server Manager is an integrated database management tools platform that is used for DB2® for z/OS® subsystems. With Data Server Manager, you can monitor performance, track configuration changes, administer databases, and optimize the database environment.

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)