Workbench for DB2 Modernization Guide

Workbench for DB2 provides a web-based interface for accessing DB2 catalog information, simplifying object management and SQL performance analysis. It integrates with other BMC DB2 utilities like Object Administration for DB2 and Performance for DB2 SQL to offer a comprehensive DB2 management solution.

Workbench for DB2 is offered at no charge when acquired with other BMC DB2 utilities. This makes it an accessible tool for DB2 database administrators and developers already using BMC solutions.

Workbench for DB2 is primarily used to access and manage DB2 catalog information. Users can browse database objects, view object definitions, and analyze SQL performance. It streamlines administrative tasks and enhances productivity.

Workbench for DB2 is designed to work within a z/OS environment, leveraging the capabilities of the mainframe platform for DB2 database management.

Workbench for DB2 allows users to browse DB2 catalog information, view object definitions (tables, views, indexes), execute SQL statements, and analyze SQL performance using visual explain plans. Common operations include filtering objects by name or type, displaying DDL, and exporting object definitions.

Workbench for DB2 uses standard web protocols (HTTP/HTTPS) for communication. Specific API details are not publicly documented, but integration is achieved through its web-based interface and interoperability with other BMC DB2 tools.

The main system components include the web server, application server, and the DB2 data server. The web server handles user requests, the application server processes the requests and interacts with DB2, and the DB2 data server stores the catalog information.

Workbench for DB2 relies on the DB2 catalog for storing metadata. It does not introduce separate storage mechanisms. The DB2 catalog contains information about database objects, their definitions, and statistics.

Workbench for DB2 enhances productivity by providing a user-friendly interface for accessing and managing DB2 catalog information. It reduces the time and effort required to perform administrative tasks and analyze SQL performance.

By simplifying DB2 administration and SQL performance analysis, Workbench for DB2 helps reduce operational costs. It enables DBAs to quickly identify and resolve performance bottlenecks, optimizing resource utilization.

Workbench for DB2 integrates with other BMC DB2 utilities, such as Object Administration for DB2 and Performance for DB2 SQL, to provide a comprehensive DB2 management solution. This integration streamlines workflows and enhances data management capabilities.

Workbench for DB2 leverages the security features of the underlying z/OS and DB2 environments. Authentication methods include RACF, ACF2, and Top Secret, depending on the site's configuration.

Workbench for DB2 utilizes the access control mechanisms provided by DB2. Access to DB2 objects is controlled through DB2 privileges and roles. The access control model is primarily ACL-based, managed within DB2.

Data transmitted between the web browser and the Workbench for DB2 server can be encrypted using HTTPS. Data at rest within the DB2 catalog is protected by DB2's native encryption capabilities, if configured.

Workbench for DB2 relies on DB2's audit facilities for tracking user activity and data access. Audit logs can be configured to capture specific events, such as object modifications and SQL statement executions.

Workbench for DB2 is administered through its web-based interface. User management is typically handled through the underlying z/OS security system (RACF, ACF2, Top Secret) and DB2 privileges.

Key configuration parameters include settings for the web server, application server, and DB2 connection parameters. These parameters are typically configured through configuration files or the web-based interface.

Workbench for DB2 leverages DB2's monitoring and logging capabilities. DB2 provides extensive monitoring data that can be accessed through SQL queries or monitoring tools. Logging is configured through DB2's audit facilities.