All Products

DB/DC Data Dictionary was a mainframe-based metadata repository designed to document and manage database structures and relationships, primarily for IMS and DL/I databases on z/OS and z/VSE. Key functions included defining data elements (DEFINE ELEMENT), defining databases (DEFINE DATABASE), and generating reports. Administration was performed through JCL and utility programs, with user management handled via the mainframe security system (e.g.,...

Db2 Accessories Suite is a collection of tools designed to extend the capabilities of Db2 on z/OS. The suite includes components like Db2 Data Studio for database administration, Spatial Support for handling spatial data, and IBM Text Search for text indexing. It supports integration with C/C++ and Java, enabling developers to build custom applications. Key features include spatial data querying,...

The Db2 Administration Tool for z/OS is a critical component for managing and maintaining Db2 databases. It streamlines administrative tasks, enhancing DBA productivity and reducing the potential for errors. The tool's ISPF-based interface provides a consistent and user-friendly environment for managing database objects, monitoring performance, and executing SQL statements. Key features include the ability to create and alter database objects,...

Db2 AI for z/OS leverages machine learning to streamline Db2 administration on z/OS. It offers capabilities such as automated performance tuning, proactive problem prediction, and intelligent resource optimization. The architecture includes the Db2 AI Engine, Data Collector, and Recommendation Engine. The Data Collector gathers data from Db2 subsystems, which is then analyzed by the Db2 AI Engine to generate insights....

Db2 Analytics Accelerator (DAA) is a hardware and software solution designed to enhance the performance of analytical queries in Db2 for z/OS environments. The primary goal is to offload resource-intensive processing from the Db2 system to a dedicated appliance, thereby improving response times and freeing up CPU resources. Key components include the DAA appliance, the DAA software, and the network...

DB2 Archive Log Accelerator, designed for z/OS, provides compression and management of DB2 archive logs. It reduces storage costs and improves backup and restore performance. The product uses a command-line interface (CLI) for administration, with commands for compression, decompression, and log management. Key components include compression engines and data striping modules. Authentication is handled through the z/OS security subsystem, and...

DB2 Audit Management Expert (DB2 AME) provided auditing capabilities for DB2 databases on z/OS. The core functionality involved capturing database events, tracking user actions, and generating audit reports. Key components included the audit engine, which collected audit data, and the reporting module, which generated reports based on predefined criteria. The system used a command-line interface (CLI) for administration and configuration....

The DB2 Automated Utility Generator was a z/OS-based tool designed to automate the generation and submission of JCL for DB2 utilities. Its primary function was to streamline database administration tasks, such as backups, reorganizations, and data loading. The tool's architecture comprised a JCL generation engine that processed user input to create the necessary JCL statements. There were no APIs exposed....

Db2 Automation Expert automates Db2 administration tasks, replacing the Db2 Automation Tool. It streamlines database management by automating routine tasks such as space management, performance monitoring, and recovery operations. The tool uses configuration files to define automation policies and thresholds, specifying conditions for actions like tablespace reorganization. The Automation Engine executes tasks based on these policies, while the Monitoring Console...

The Db2 Automation Tool streamlines database administration by automating the generation and submission of Db2 utility jobs on z/OS. It replaces tools like DB2 Automated Utility Generator. Key components include the JCL Generator, Scheduling Engine, and Configuration Manager. The tool uses configuration files for settings and does not expose external APIs. Common commands include GENERATE BACKUP and GENERATE REORG. It...

DB2 Bind Manager, released in 2000, was designed to optimize Db2 application performance on z/OS by reducing the number of binds. The product analyzed application changes to determine if a bind was required, thereby minimizing overhead. The main goal was to improve application response times and reduce CPU consumption. Key components included change analysis, bind validation, and bind execution modules....

Db2 Buffer Pool Analyzer (BPA) was a tool designed to provide detailed insights into Db2 buffer pool performance on z/OS. It enabled technical managers to monitor buffer pool activity, identify performance bottlenecks, and optimize database performance. Key features included the ability to collect and analyze buffer pool statistics, generate comprehensive reports, and provide recommendations for tuning. The tool used a...

The Db2 Change Accumulation Tool, now unsupported, was designed to optimize Db2 database recovery on z/OS. Its primary function was to create up-to-date image copies by applying Db2 logs to existing image copies. This process reduced the time required for database recovery in the event of a failure. The tool utilized a command-line interface (CLI) for all operations, including initiating...

Db2 Change Management Solution Pack provides a centralized solution for managing Db2 environments, integrating change management, object comparison, and table editing capabilities. It streamlines change deployment, reduces errors, and improves auditability. The solution supports authentication through RACF, ACF2, and Top Secret, ensuring secure access to Db2 resources. Key features include change impact analysis, automated change deployment, and comprehensive audit trails....

The Db2 Cloning Tool is a critical component for efficient database management on z/OS. It enables rapid database replication, which is essential for development, testing, and disaster recovery scenarios. The architecture comprises the Cloning Agent, Configuration Manager, and Data Mover. Key commands include `CLONE DATABASE`, `CREATE TARGET`, and `START CLONING`. The tool uses TCP/IP for communication. It supports user authentication...

Db2 Connect provides a crucial bridge for accessing Db2 databases residing on mainframe systems from various distributed platforms. The core functionality centers around acting as a gateway, translating protocols between client applications and the mainframe Db2 server. Key components include the Db2 Connect gateway, client applications, and the Db2 database server. The gateway facilitates communication using TCP/IP. The product supports...

DB2 Data Archive Expert was designed to archive inactive data from DB2 databases on z/OS, improving database performance by reducing the size of active data. Key components included the JCL scripts for job submission and control, and the DB2 database itself. The product used native interfaces to interact with DB2. It supported archiving data to DB2 tables or flat files....

Db2 Data Studio is a GUI-based tool designed for Db2 database administration and query development. It offers a user-friendly interface for managing Db2 databases on Windows and UNIX platforms. Key features include database object browsing, SQL query execution with syntax highlighting and code completion, and performance monitoring tools. The tool uses JDBC and SQLJ APIs for database connectivity, enabling communication...

DB2 DataPropagator was designed to replicate data between DB2 databases, supporting both full and incremental replication. Key components included capture and apply programs. The capture program monitored the source database's transaction logs, and the apply program applied the changes to the target database. Common commands included `START REPLICATION`, `STOP REPLICATION`, `ADD SUBSCRIPTION`, and `REMOVE SUBSCRIPTION`. Configuration was managed through control...

DB2 DB/DASD was a tool developed to provide insights into DASD usage by DB2 resources within a z/OS environment. The primary function was to display and manage DASD usage, enabling administrators to monitor storage allocation and identify potential issues. The tool utilized a command-line interface (CLI) for interaction, with commands such as 'DISPLAY STORAGE' used to retrieve storage information. Configuration...