Skip to Content

Overview

The OPERTUNE for DB2 product enables you to modify Db2 Universal Database subsystems and Db2 sharing groups dynamically by using features such as parameter elements, operational assists, and group and schedule profiles:

  • Parameter elements let you modify subsystem parameters, such as the cast out reverse threshold or the dual archiving mode, as needed.
  • Operational assists help you to respond to common operational problems (for example, by canceling threads and maintaining archives)
  • Group profiles and schedule profiles enable you to assign commands to groups and then implement changes automatically by scheduling the command groups to run at optimal times.

Using these features of OPERTUNE, you can perform the following tasks:

  • Modify Db2 parameters to relieve current problems or bottlenecks
  • Dynamically tune subsystems
  • Adapt resource assignment or allocations to workload fluctuations
  • Enhance 24 hours a day, 7 days a week continuous operations for subsystems
  • Enhance automated operations for Db2
  • Dynamically add and remove active logs
  • Tune remote subsystems through VTAM 
  • Test applications with different subsystem parameters without recycling the subsystem
  • Cancel a thread that is draining resources without canceling the thread’s address space
  • Tune buffer pool and group buffer pool parameters
  • Manage subsystem archives
Warning

Important

OPERTUNE is also a component of the BMC System Performance for Db2 solution from BMC.

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 13.1