OPERTUNE for DB2

The core architecture of OPERTUNE for DB2 consists of several key components. The Command Processor is responsible for parsing and executing user commands entered via the CLI. The DB2 Interface component handles communication with the DB2 subsystem, facilitating the modification of parameters and the management of threads and connections.

The Configuration Manager component is responsible for storing and managing configuration data, typically within z/OS datasets. The Logging and Auditing component captures system events and user actions for monitoring and auditing purposes. The CLI provides the primary interface for administrative tasks.

User management is integrated with z/OS security, utilizing mechanisms such as RACF or equivalent. Configuration parameters are managed through the CLI, allowing for online adjustments to DSNZPARM and DDF settings. Monitoring and logging capabilities are provided to track system events and changes.

Communication between the components utilizes internal z/OS communication mechanisms. OPERTUNE for DB2 does not expose any APIs. It uses a proprietary protocol for communication with the DB2 subsystem.

The tool stores configuration data within z/OS datasets. Compared to manual configuration, OPERTUNE for DB2 offers significant advantages in terms of speed and reduced downtime. Competitors include other DB2 administration tools, but OPERTUNE for DB2's focus on online parameter changes and thread management provides a unique value proposition.

The tool's ability to modify parameters like STMT_CACHE without a DB2 restart is a key differentiator.