Altering data structures in a database environment

This section describes the alter process, and the tasks that you can perform to create, modify, and drop your data structures within a Db2 subsystem.

For example, you can change the name of a data structure and modify attributes such as limit keys and storage groups. This process of creating, modifying, or dropping data structures is known as altering the data structures.

With ALTER and BMC AMI Change Manager for Db2, you can automate the alter process, as well as the following tasks:

  • Determine the dependencies on changed data structures and preserve those dependencies and their associated data
  • Analyze the impact of changes by validating the changes against the Db2 catalog
  • Import data definition language (DDL) files and CDL files from another subsystem and apply the changes to your subsystem

The following workflow illustrates the alter process.

Workflow for the alter process (page 1)

image2020-7-17_12-29-19.png

 Workflow for the alter process (page 2)

image2020-7-17_12-30-5.png

This section contains the following topics:



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*