What APIs does MasterReorg expose?

MasterReorg uses standard DB2 APIs for interacting with the DB2 subsystem. It does not expose any custom APIs.

How does MasterReorg interact with the DB2 catalog?

MasterReorg interacts directly with the DB2 catalog to gather information about DB2 objects, such as tables, indexes, and their characteristics. This information is used to determine which objects to reorganize and how to optimize the reorganization process.

What ports or network configurations are required for MasterReorg?

MasterReorg uses standard DB2 commands and utilities for performing reorganization tasks. It does not require any special ports or network configurations beyond those required for DB2 itself.

How does MasterReorg improve DB2 performance?

MasterReorg improves DB2 performance by optimizing data access and reducing I/O operations. By reorganizing tables and indexes, it reduces fragmentation and improves data locality, leading to faster query execution and reduced response times.

How does MasterReorg reduce administrative overhead?

MasterReorg automates the reorganization process, reducing the need for manual intervention and freeing up DBAs to focus on other tasks. By selecting objects based on a time window, it ensures that reorganization tasks are completed efficiently and without disrupting critical business operations.

How does MasterReorg reduce storage costs?

By reclaiming fragmented space and optimizing data storage, MasterReorg can reduce storage costs and improve storage utilization. This can lead to significant cost savings, especially in large DB2 environments.

What access control model is used by MasterReorg?

MasterReorg relies on the DB2 access control model for managing user permissions and access to DB2 objects. It does not implement its own access control model.

What encryption is used by MasterReorg?

MasterReorg does not encrypt data itself. It relies on DB2's encryption capabilities for protecting sensitive data.

What audit/logging capabilities exist in MasterReorg?

MasterReorg logs all reorganization activities, providing an audit trail for tracking changes and identifying potential issues. These logs can be used for security monitoring and compliance purposes.

What administrative interfaces are available for MasterReorg?

MasterReorg is administered through configuration files and command-line interfaces. It does not have a dedicated GUI or web console.

How is user management handled in MasterReorg?

User management is handled through the standard DB2 security administration tools. MasterReorg does not provide its own user management capabilities.

What monitoring/logging capabilities exist in MasterReorg?

MasterReorg provides logging and monitoring capabilities to track the progress of reorganization tasks and identify potential issues. These logs can be integrated with standard monitoring tools for proactive problem detection.

What are the main configuration parameters for MasterReorg?

MasterReorg configuration parameters include time windows for reorganization, object selection criteria, system resource limits, and logging options. These parameters can be customized to optimize performance and meet specific requirements.

Share Your Product Experience

Help the community by sharing your experience with mainframe products. Your insights help others make informed decisions.

Share Your Experience

MasterReorg for DB2 on z/OS

Name: MasterReorg for DB2 on z/OS
Availability: InStock

Infotel Supported z/OS

Tools and Utilities Administration Databases Db2

Vendor

Infotel

Product Overview

MasterReorg automates DB2 object reorganization on z/OS, optimizing performance and reducing administrative overhead. The main system components include the Reorganization Scheduler, Object Selector, and Execution Engine. The Reorganization Scheduler determines when to initiate reorganization tasks based on predefined schedules and time windows.

The Object Selector identifies tables and indexes for reorganization based on estimated completion time and user-defined criteria. The Execution Engine performs the actual reorganization using standard DB2 utilities. These components communicate through internal messaging and shared data structures.

Configuration files define key parameters, including time windows, object selection criteria, and system resource limits. It uses standard DB2 APIs for interacting with the DB2 subsystem. For example, the Object Selector uses the DB2 catalog to gather information about object characteristics.

Competing products include IBM DB2 Sort and BMC AMI Reorg. MasterReorg's time-windowed approach and integration with MASTER-UTIL provide a distinct advantage, offering more granular control and a broader range of DB2 management capabilities. It relies on DB2's security infrastructure for authentication and authorization.

It logs all reorganization activities for auditing purposes.

Frequently Asked Questions

What is the primary function of MasterReorg?

MasterReorg automates the reorganization of DB2 objects, such as tables and indexes, to improve performance and reclaim space. It uses a time-window approach, selecting objects for reorganization based on estimated completion time. It is part of the MASTER-UTIL suite.

How does MasterReorg decide which DB2 objects to reorganize?

MasterReorg determines which objects to reorganize based on estimated completion time within a defined time window. It considers factors like object size, fragmentation level, and system load to prioritize objects that will benefit most from reorganization within the available time.

What type of DB2 reorganization does MasterReorg perform?

MasterReorg performs complete DB2 reorganization, which involves rebuilding indexes, reordering rows in tables, and reclaiming fragmented space. This process optimizes data access and improves overall database performance.

How does MasterReorg relate to the MASTER-UTIL suite?

MasterReorg is part of the MASTER-UTIL suite, which provides a range of utilities for DB2 database management, including backup, recovery, and data migration tools. These utilities are designed to work together to streamline DB2 administration tasks.

Help Improve This Directory

Notice outdated information? Have insights about this product? Help the mainframe community stay informed with accurate, current data.

Report Issue Suggest Product Share Event

Share Your Product Experience

Help the community by sharing your experience with mainframe products. Your insights help others make informed decisions.

Share Your Experience

Share Your Product Experience

MasterReorg for DB2 on z/OS

Product Overview

Frequently Asked Questions

What is the primary function of MasterReorg?

How does MasterReorg decide which DB2 objects to reorganize?

What type of DB2 reorganization does MasterReorg perform?

How does MasterReorg relate to the MASTER-UTIL suite?

What configuration files are used by MasterReorg?

What APIs does MasterReorg expose?

How does MasterReorg interact with the DB2 catalog?

What ports or network configurations are required for MasterReorg?

How does MasterReorg improve DB2 performance?

How does MasterReorg reduce administrative overhead?

How does MasterReorg reduce storage costs?

What authentication methods are supported by MasterReorg?

What access control model is used by MasterReorg?

What encryption is used by MasterReorg?

What audit/logging capabilities exist in MasterReorg?

What administrative interfaces are available for MasterReorg?

How is user management handled in MasterReorg?

What monitoring/logging capabilities exist in MasterReorg?

What are the main configuration parameters for MasterReorg?

Related Products

More from Infotel

InfoLoad for DB2 on z/OS

InfoPak

InfoReorg for DB2 on z/OS

InfoScope

InfoSimulation

InfoTrace

Similar Products

_beta access admin

_beta access audit

_beta access easy

_beta access monitor

_beta doc|z plus

_beta doc|z transform

Help Improve This Directory

Share Your Product Experience