Chapter 4. Working with the Change Management functions 155
The generated JCL fills your delta change data set with DDL. As an example, let us look into
the currently generated delta changes data set shown in Figure 4-51.
Figure 4-51 Delta change generated DDL
4.4.6 The IMPORT process
In this section we discuss the IMPORT process in depth. The IIMPORT process itself always
follows the workflow as described in Figure 4-52.
VIEW ADMIN.CM.DELTA1 Columns 00001 00072
Command ===> Scroll ===> CSR
000001 DROP ADMIN DROP TABLE DSN8810.EMP ;
000002 CREATE CREATE TABLE DSN8810.EMP
000003 CREATE (EMPNO CHAR(6) FOR SBCS DATA NOT NULL,
000004 CREATE FIRSTNME VARCHAR(12) FOR SBCS DATA NOT NULL,
000005 CREATE MIDINIT CHAR(1) FOR SBCS DATA NOT NULL,
000006 CREATE LASTNAME VARCHAR(15) FOR SBCS DATA NOT NULL,
000007 CREATE WORKDEPT CHAR(3) FOR SBCS DATA WITH DEFAULT NU
000008 CREATE PHONENO CHAR(4) FOR SBCS DATA WITH DEFAULT NU
000009 CREATE HIREDATE DATE WITH DEFAULT NULL,
000010 CREATE JOB CHAR(8) FOR SBCS DATA WITH DEFAULT NU
000011 CREATE EDLEVEL SMALLINT WITH DEFAULT NULL,
000012 CREATE SEX CHAR(3) FOR SBCS DATA WITH DEFAULT NU
000013 CREATE BIRTHDATE DATE WITH DEFAULT NULL,
000014 CREATE SALARY DECIMAL(9, 2) WITH DEFAULT NULL,
000015 CREATE BONUS DECIMAL(9, 2) WITH DEFAULT NULL,
000016 CREATE COMM DECIMAL(9, 2) WITH DEFAULT NULL,
000017 CREATE CONSTRAINT EMPNO
000018 CREATE PRIMARY KEY (EMPNO),
000019 CREATE CONSTRAINT NUMBER
000020 CREATE CHECK (PHONENO >= '0000' AND PHONENO <= '9999'),
000021 CREATE CONSTRAINT PERSON CHECK (SEX = 'M' OR SEX = 'F'))
000022 CREATE IN DSN8D81A.DSN8S81E
000023 CREATE PARTITION BY (EMPNO ASC)
000024 CREATE (PART 1 VALUES('099999'),
000025 CREATE PART 2 VALUES('199999'),
000026 CREATE PART 3 VALUES('299999'),
000027 CREATE PART 4 VALUES('499999'),
000028 CREATE PART 5 VALUES('999999'))
- - - - - - - - - - - - - - - - - - - 10 Line(s) not Displayed
****** **************************** Bottom of Data ****************************
Important: The PROMOTE process marks your change either in status DEFINED or
COMPLETE.
156 DB2 for z/OS Administration Tools for Enhanced Change Management
Figure 4-52 The IMPORT workflow
The IMPORT process provides you the ability to register changes from a data set containing
DDL. You can import:
򐂰 DDL that is provided by the GEN command of Admin or any other DDL generation tool of
your choice
򐂰 A delta changes data set that has been produced as a result of:
The PROMOTE process
–Compare
If you plan to import your delta change data set (or your DDL data set) to multiple targets, you
have to import your DDL or delta change data set in every target environment where you want
to run the imported change.
While importing a change, you can use masking to adapt the DDL to your naming standards.
According to the IMPORT process itself, it does not make any difference if you provide native
DDL, an output data set from Compare, or an output data set from the PROMOTE process.
To start the import, use option 1 - Manage Changes and then 4 - Import changes. You are
required to enter the data set name. Put it in quotes to avoid conflicts. See Figure 4-53.
Figure 4-53 The IMPORT screen
Change Management makes sure that prerequisites are being detected during the IMPORT
process. We recommend that you start the IMPORT in batch mode, then you must do the
prereq resolution mode in batch as well.
You are prompted to tell Change Management what kind of action do you want to perform if
the change you are going to import has pending prerequisite changes (see Figure 4-54).
Restriction: There is currently no overwrite available during the IMPORT process, as it is
possible to do this in the WSL cloning process.
DB2 Admin ------------------- CM - Import Changes ----------------------- 20:26
Command ===>
Input data set information: DB2 System: DB8A
Data set name 'ADMIN.DB8A.C0000246.AN195814.CHANGES'
Prereq resolution mode . B (TSO/Batch)
Execution mode . . . . . B (TSO/Batch)
CM Import
Register
Register
Import
Import
Changes
Changes

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.