You can modify the change statements in an existing change
if the change is in INITIAL, DEFINED, or ANALYZED status.
About this task
However, modifying an existing change is considered a
manual intervention and is not recommended for several reasons. When
you modify an existing change, Db2 Admin Tool cannot apply
virtual changes or determine whether pending changes exist. Modifying
an existing change can also impact other existing changes substantially.
For example, the change you are modifying might be a pending change
that was applied when another change was created.
During the
process of modifying a change, Db2 Admin Tool checks only
the syntax of each change statements. When you modify change statements
through the Change Statements panel (ADB2C1S) panel, for example,
syntax checking is completed at the time that you exit the panel.
Semantic checking is done during the analyze process.
To modify
the change statements in an existing change:
Procedure
Identify and consider the impact of the changes to dependent
changes.
For example, assume that want to modify a change
that adds a new column to a table to change the name of the column.
The change might be a prerequisite change to other changes that use
that column such as another change that creates an index that includes
that column.
Display the change to be modified by selecting option 1
on the Change Management panel, and then select
option 1 on the Manage Changes panel.
Issue the ST line command to display the change statements
in the change that you want to modify on the Change Statements panel.
The following figure shows an example of the Change
Statements panel: Figure 1. Change Statements panel (ADB2C1S )
DB2 Admin ------------- CM - Change Statements ------------------ Row 1 from 1
Command ===> Scroll ===> CSR
Change statements for change "JOHNSON"."EMP_CH2"
Line commands:
E - Edit D - Delete I - Insert S - Show
Sel Sequence O Qual Name Statement
* * * * *
--- ----------- -- -------- ------------------ ------------------------------->
1 TB JOHNSON HREMP ALTER TABLE "JOHNSON"."HREMP"
******************************* END OF DB2 DATA *******************************
Issue the E line command to change any of change statements
in the change, the D line command to delete a change statement, and
the I line command to insert a new change statement.
When
you use the E and I line commands, you are put into an ISPF edit session
and can work with the SQL statement.
Press F3 to return to the Change Statements panel.
Db2 Admin Tool reregisters
the change. A message is displayed to indicate whether the change
was registered successfully. When a modified change is reregistered,
pending changes or prerequisite changes are not processed.
Reanalyze any change that is in ANALYZED status and that
is impacted by the modifications that you made to this change.
Reanalyzing the impacted changes ensures the validity of the
changes.