Registering a multi-target change
You can register and track changes on multiple target systems.
Before you begin
Change Management must be enabled on the system and be either optional or required for your SQL ID. You enable Change Management by customizing the Db2® Administration Tool.
If the option to create a multi-target change is shown on the Register Options panel (ADB2CRO), then the change can be registered on multiple target systems. The steps that follow assume your system is configured to create a multi-target change.
You can register the change on multiple target locations.
About this task
To register a multi-target change:
Procedure
- Specify Yes in the Multi-target Change field on the CM
- Register Options panel and then issue the CONTINUE command.
The following figure shows an example of the CM - Register Options panel:
Figure 1. CM - Register Options Panel (ADB2CRO) ADB2CRO n -------------------- CM - Register Options -------------------- 17:30 Command ===> Commands: CONTINUE DB2 System: DD1A DB2 SQL ID: ADM001 Specify the following values to register a change: Owner . . . . . . . . VNDR1 > (Optional, Default is VNDR1) Name . . . . . . . . TESTCHG1 > Comment . . . . . . . > Multi-target Change . YES (Yes/No, Default is NO) Target Name . . . . TESTTEST3 > (Optional, ? to lookup) Group name . . . . > (Optional, ? to lookup) Replace existing change . . ('/' to replace, Default is BLANK) Specify the owner and name values to use for this change (? to lookup): Owner Name Ignore . . . . . . . > > Mask . . . . . . . . > > - Select the target names you want to register on the ADBPCMT
panel then select NEXT. The following figure shows an example of the CM - Associate Targets panel:
Figure 2. CM - Associate Targets Panel (ADBPCMT) ADBPCMT n --------------- CM - Associate Targets ------------- Row 1 to 1 of 1 Details for multi-target change: VNDR1.S28479-C1 DB2 System: DD1A DB2 SQL ID: ADM001 Commands: NEXT Line commands: U - Update D - Delete AT - Add targets AG - Add targets from group I - Interpret ? - Show all line commands Target Change Change Sel Name DB2 Location Owner name Status * * * * * --- -------> ------------> --------- ---------------------- ------------------- I TESTCHG1 DD1A ATCOWN ATCNAM NEW ******************************* END OF DB2 DATA *******************************Note: If no targets exist, panel ADBPC911 displays to allow you to insert targets. - Specify the action to take for any pending changes to the
objects on the target system that are affected by this change:
- Cancel
- Do not register the change if there are pending changes.
- Prereq
- Make the pending changes for the affected objects prerequisite changes for this change.
- Supersede
- Make this change a prerequisite change for the pending changes.
Figure 3. Specify Register Mode Panel (GOC5RM) .-----------------------—------------------------------—--------–––------. |GOC5RM ----------------- Specify Register Mode ----------------- 17:35 | | | |Pending changes action . . SUPERSEDE (Cancel, Prereq, Supersede) | | | | | | | | F1=HELP F2=SPLIT F3=END F4=expand F5=RFIND F6=RCHANGE | | F7=UP F8=DOWN F9=SWAP F10=LEFT F11=RIGHT | '------------------------------------------------------—--------------—--'
If successful, the output indicates Register Successful and the changes are registered on the specified targets. The following is an example report of a multi-target change summary:
Figure 4. Multi-Target Change (ADB2CID) ADB2CID - Multi-Target Change Summary Multi-target change id: 3747 Target Owner Name Status --------- -------- ------------------ ----------------------------------- B148286 A ADB9400I:The change was registered successfully, Changeid: 3957 C148286 B ADB9400I:The change was registered successfully, Changeid: 3958 ADB2CID - Multi-Target Change End of Summary