BMC ALTER for DB2

Manage DB2 for z/OS changes with integrity and speed

Change is inevitable: all databases require changes when application changes are introduced. But changing DB2 on z/OS database structures and objects is labor-intensive and error prone because you must unload the objects being changed, drop them, create them, and load them - and dependent objects will be affected. Migrating data structures to another environment requires significant manual analysis and coding. Keeping track of dependent objects affected and the order in which changes are to be applied is critical to the successful completion of database changes.

BMC solution

BMC ALTER for DB2 automates the change process by analyzing the request and determining the required changes, changing the structures, moving the data, preserving all security, and rebinding any plans affected - in the proper order - to ensure proper completion of changes. BMC ALTER for DB2 ensures that planned changes are implemented correctly, the first time, without costly mistakes.

Features and benefits

• Eliminates manual change management process Improves application availability by reducing the time it takes to perform structural changes and by executing changes in parallel
• Migrates data structures and data from one DB2 subsystem to another, or migrates them within a subsystem
• Ensures proper order of changes

Key differentiators

• High Speed unload engine
• Preserves all object relationships and dependencies
• Completely restartable

Related Products

• BMC CHANGE MANAGER for DB2
• BMC Database Administration for DB2