CONVERT example: Specifying the key ranges for partitions
If you want to assign specific key ranges to partitions, you can use the KEYS parameter
to specify an input data set containing the keys. The KEYS parameter specifies the high key
boundaries for each partition.
To specify the ranges for partitions, use the member IHCECVT3. The following example converts a
database into two partitions with each partition containing the keys up to the specified high key
boundary. Figure 1. Sample JCL (IHCECVT3) for batch using KEYS
//JOBNAME JOB NAME,000,CLASS=A,MSGCLASS=X
//********************************************************************
//* SAMPLE JCL FOR CONVERT - using KEYS method
//*
//* Your databases must be registered to DBRC
//* You must /dbr your databases prior to executing this job
//********************************************************************
//S2 EXEC PGM=IHCHALDB,DYNAMNBR=999,REGION=80M
//STEPLIB DD DISP=SHR,DSN=your.SIHCLOAD <=== your hcma loadlib
// DD DISP=SHR,DSN=your.SDFSRESL <=== ims reslib
// DD DISP=SHR,DSN=your.SHPSLMD0 <=== ims tools loadlib
//DFSRESLB DD DISP=SHR,DSN=your.SDFSRESL <=== ims reslib
//MACLIB DD DISP=SHR,DSN=your.SDFSMAC <=== ims maclib
//IMS DD DISP=SHR,DSN=your.dbdlib <=== ims dbdlib
//IMSDALIB DD DISP=SHR,DSN=your.mdalib <=== ims mdalib
//SYSPRINT DD SYSOUT=*
//MSGPRINT DD SYSOUT=*
//DBDPRINT DD SYSOUT=*
//LNKPRINT DD SYSOUT=*
//AMSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//IHCLIST DD SYSOUT=*
//****************************************
//*KEYSIN DD * (documentation only)
//* your first high-order key for partition1
//* your second high-order key for partition2 and so on...
//* your highest key for last partition
//****************************************
//KEYSIN DD *
M999999999
Z999999999
//IHCSYSIN DD *
CONVERT ONLINE(N) -
KEYS(KEYSIN) -
DBDPATT(*****...) DSNPREF(DBSMS.DB) -
DBD(xxxx) -
ICMID(3) -
ICHLQ(DBSMS.DB.IC) -
ICTRLR(2) -
IC.COMP(Y) -
IC.COMPRTN(FABJCMP2) -
PTRCHECK(Y)