How to Process more than one input dataset with DBO reload

Document ID : KB000025185
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

Multiple output datasets, produced by different DBO unload executions, can be reloaded in a single DBO Reload step
 

Question:

How can multiple output datasets, produced by different DBO unload executions, be reloaded in a single DBO Reload step?
 

Environment: 

IMS Batch 
 

Answer: 

Concatenate all input datasets under the DBORELD1 DD statement and use HDSORT=Y to ensure the input is correctly sequenced.

Example:

This is DBO Reload job control to reload 3 unload files created by 3 different unload executions:

    //DBOREL    EXEC PGM=IDIDBO,REGION=4096K     //STEPLIB   DD  DSN=imstools.LOADLIB,DISP=SHR     //          DD  DISP=SHR,DSN=ims.reslib     //DFSRESLB  DD  DISP=SHR,DSN=ims.reslib     //ddn       DD  DISP=SHR,DSN=database.dsn     //DBDLIB    DD  DISP=SHR,DSN=ims.dbdlib     //DBORELD1  DD  DISP=SHR,DSN=unload.keyrange1     //          DD  DISP=SHR,DSN=unload.keyrange2     //          DD  DISP=SHR,DSN=unload.keyrange3     //DBOMSGS   DD  SYSOUT=*     //DBORPTS   DD  SYSOUT=*     //DBOCTRL   DD  *     FUNCTION=RELOAD,     DBDNAME=dbdname,     HDSORT=Y,     DBRC=N

 

Additional Information:

Be aware that if HDSORT=YES is not specified the reload will stop after reading the trailer record from the first input file and ignore subsequent files in the concatenation.