Chapter 6. Implementing changes to a design (Vn) 283
6.1.6 ANALYZE: Analyzing a change
You can go to CM on the Main panel and then display the changes to be reviewed on the
Changes panel. From this panel you can enter AN next to the ALC change to analyze the
change. See Figure 6-39.
Figure 6-39 Changes (ADB2C11)
Once you press Enter, you are prompted to fill in values required for the ANALYZE job. In this
case we specify the option to create a recover change and use original data.
DB2 ADMIN ------------------ CM - Changes -------------------- Row 1 to 2 of 2
Command ===> Scroll ===> PAGE
Line commands:
U - Update AN - Analyze RN - Run VE - Versions ST - Statements
PQ - Prerequisites IG - Ignores MA - Masks
? - Show all line commands
Sel ID Owner Name Type Status Comment
* * * * * *
--- -------- -------- ------------------ ------- -------- -------------------->
233 PAOLOR4 ADCOL1GWLTEMP CHANGE COMPLETE AL ADDCOL1 CHAR 12 GW
an 290 PAOLOR4 ALCPRIMKEY1 CHANGE DEFINED ALC CHANGE PRIMKEY DE
******************************* END OF DB2 DATA *******************************
Tip: It is a good idea to create a recover change when making changes. A recover change
is a change that lets you back out a change that has been completed.
284 DB2 for z/OS Administration Tools for Enhanced Change Management
See Figure 6-40 for the Generate Analyze Job panel.
Figure 6-40 Generate Analyze Job (ADB2C11A)
DB2 Admin ----------------- Generate Analyze Job ---------------------- 15:01
Command ===>
Specify the following for Analyze:
Base version method . . . . . E (Auto, User, or Existing)
Change reporting options . . YES (Yes/No)
Required data set information:
PDS for WSL . . . . . . . 'DB8A.ANALYZE.WSL8'
PDS for batch jobs . . . DB8A.ANALYZE.JCL8
Prefix for data sets . . PAOLOR4
Options:
Run SQLID . . . . . . . . (Blank, a SQLID, or <NONE>)
Validate WSL . . . . . . NO (Yes/No)
Use utility options . . . NO (Yes/No)
Generate templates . . . NO (Yes/No)
Build JCL to run WSL . . YES (Yes/No)
Generate a recover change YES (Yes/No)
Data to recover . . . . O (Original or Existing)
Optional jobs after Reload or Alter:
Run CHECK DATA . . . . NO (Yes/No)
Take an image copy . . N (after: Reload/Alter/Both/None)
Run REORG . . . . . . . N (Mandatory, All relevant, None)
Run RUNSTATS . . . . . N (after: Reload/Alter/Both/None)
Run REBIND . . . . . . NO (Yes/No)
BP - Change batch job parameters
TU - Specify TEMPLATE usage
UO - Change utility options
Chapter 6. Implementing changes to a design (Vn) 285
Once you press Enter, you get prompted to name the recover job name. See Figure 6-41.
Figure 6-41 Setting the recovery job name
The job output from the analyze ended with Rc=0 and shows the changes in Figure 6-42.
Figure 6-42 Job output
DB2 Admin -------------------- CM - Register Options -------------------- 15:20
Option ===>
Commands: CONTINUE DB2 System: DB8A
DB2 SQL ID: PAOLOR4
Specify the following values to register a change:
Owner . . . . . . . . PAOLOR4 > (Optional, default is PAOLOR4)
Name . . . . . . . . RALCPRIMKY1 >
Comment . . . . . . . RECCHANGE FOR CHGID290 >
Change Type . . . . : RECOVER (Promote, Change, Compare, Recover, Fast)
Specify the owner and name values to use for this change:
Owner Name
Ignore . . . . . . . > > (? to look up)
Mask . . . . . . . . > > (? to look up)
Delta Version . . . . PAOLOR4 > RALCPRIMKY1 > (? to look up)
Compare table source(DSG24D04.GLWTDPT) and target(DSG24D04.GLWTDPT)
Column DEPT_NO
(D)Type changed from INTEGER to DECIMAL(4, 0)
Tables have identical column lists
Table DSG24D04.GLWTDPT will be dropped
Table will be recreated
Table data will be converted
Compare index source(DSG24D04.GLWXDPT1) and target(DSG24D04.GLWXDPT1)
Index DSG24D04.GLWXDPT1 will be dropped by dropping the table
Index will be recreated because the base table will be dropped and recreated
Compare index source(DSG24D04.GLWXDPT2) and target(DSG24D04.GLWXDPT2)
Index DSG24D04.GLWXDPT2 will be dropped by dropping the table
Index will be recreated because the base table will be dropped and recreated
View DSG24D04.WLDEPT will be recreated because it is dependent on an object
that

Get DB2 for z/OS Administration Tools for Enhanced Change Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.