BMC REORG PLUS for DB2

Reorganize DB2 on z/OS data quickly and efficiently

DB2 on z/OS data is growing, IT budgets are shrinking, and continuous availability is required. To remain competitive, companies must increase performance and reduce costs. When databases are disorganized, performance degrades or systems run out of space, costing IT organizations both time and money. How can you ensure that DB2 on z/OS databases are performing optimally while you maintain continuous availability?

BMC solution

BMC REORG PLUS for DB2 reorganizes DB2 databases quickly and efficiently by using multitasking and parallel processing. Online features and minimal outages ensure maximum data availability. BMC REORG PLUS for DB2 has powerful restart capabilities that reduce manual intervention when restarting a failed reorg job.

Features and benefits

• Analyzes and allocates memory and CPU resources for maximum performance and availability
• Eliminates the need to execute RUNSTATS utility separately
• Automatically calculates optimal work file sizes and dynamically allocates work file and copy data set space
• Provides online features that recoverability

Key differentiators

• Significantly reduces costs of reorganizing DB2 data  - uses fewer CPU cycles and EXCPs than the native DB2 utility
• Runs outside of DB2 address space to reduce the effect of load processing on other applications
• Eliminates the need to execute a copy utility separately - produces copies as part of the reorg process

Related Products

• BMC Database Performance for DB2