Reorganizing a Modeled Database Using DMREORG reorganization

Reorganization of modeled databases proceeds in much the same manner as a DASDL update. The following WFL job performs the reorganization for the LIVEDB and TESTDB databases using DMREORG reorganization by increasing the length of Z in data set Q from 12 to 20 characters.  Note, you must use the BUILDREORG utility when you are performing any form of reorganization or garbage collection for a modeled database if using DMREORG reorganization.

?BEGIN JOB REORGANIZE/BOTHDBS;
%
% REORGANIZE LIVEDB
COMPILE LIVEDB WITH DASDL;
COMPILER DATA
UPDATE;
OPTIONS (AUDIT);
D DATA SET (K NUMBER(6)) AREAS = 100;
S SET OF D KEY K;
Q DATA SET (Z ALPHA(20)) PACK = TESTPACK;
AUDIT TRAIL (KIND = TAPE, DUPLICATED ON TAPE);
?
%----- END LIVEDB DASDL -----

RUN SYSTEM/BUILDREORG;
FILE DASDL (TITLE = DESCRIPTION/LIVEDB);
DATA CARD
$ RESET ZIP
UPDATE;
GLOBAL DMREORG OFFLINE;
?
%----- END BUILDREORG INPUT -----

RUN SYSTEM/REORGANIZATION;
FILE DASDL = DESCRIPTION/REORGANIZATION/LIVEDB ON TESTPACK;
%------ END OF REORGANIZATION FOR LIVEDB ------

% REORGANIZE TESTDB
COMPILE TESTDB WITH DASDL;
COMPILER DATA
MODEL LIVEDB;
UPDATE;
OPTIONS (AUDIT);
CONTROL FILE (PACK = TESTPACK);
D DATA SET (K NUMBER(6)) PACK = TESTPACK;
S SET OF D KEY K PACK = TESTPACK;
Q DATA SET (Z ALPHA(20)) PACK = TESTPACK;
?
%----- END TESTDB DASDL -----

RUN SYSTEM/BUILDREORG;
FILE DASDL (TITLE = DESCRIPTION/TESTDB);
DATA CARD
$ RESET ZIP
UPDATE;
GLOBAL DMREORG OFFLINE;
?
%-----END BUILDREORG INPUT -----

RUN SYSTEM/REORGANIZATION;
FILE DASDL = DESCRIPTION/REORGANIZATION/TESTDB ON TESTPACK;

?END JOB.