BMC CHANGE MANAGER for DB2

Manage DB2 for z/OS changes with integrity

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. If you are using multiple DB2 subsystems, migrating structure changes across them is repetitive task and you have no way to preserve local modifications to each subsystem. If you must revert to an earlier version, there is no easy way to do so. How can you manage deploy changes quickly and with integrity?

BMC solution

BMC CHANGE MANAGER for DB2 automates the change process by analyzing the request and determining the required changes, changing the structures, moving the data, and tracking the changes of all the DB2 environments – while properly managing ERP and CRM applications. BMC CHANGE MANAGER for DB2 ensures that a planned change is implemented correctly, the first time, without costly mistakes. With BMC CHANGE MANAGER for DB2, you can roll changes forward or back as needed.

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
• Provides profiles to define and control a change, migration, or baseline process
• Provides the ability to back out changes
• Can make changes to multiple databases and keep them in sync

Key differentiators

• Enables version control - Can roll changes forward or back as needed
• Multiple version support - Manages updates to multiple versions of applications that are being developed simultaneously across the enterprise.
• CM/Pilot - prepares change management tasks that are performed repeatedly, such as migrating changes from a test environment to production or migrating from one version of DB2 to another

Related Products

• BMC Database Administration for DB2