Unloading HALDB partitions and databases for offline reorganization

HALDB partitions or databases can be unloaded with the HD Reorganization Unload utility (DFSURGU0).

To unload an entire HALDB database, do not include a SYSIN DD statement. To unload any other number of partitions, you must include a control statement in your SYSIN data set. The control statement identifies the name of the first partition to unload and, if you are unloading more than one partition, the number of partitions to unload.

Multiple partitions are unloaded consecutively. For key range partitioning, consecutive partitions are determined by the high keys. If you are using a partition selection exit routine, consecutive partitions are determined by the order assigned by the exit routine.

Do not include DD statements for the HALDB database data sets. The HD Reorganization Unload utility uses dynamic allocation for HALDB data sets. This is not true for non-HALDB databases.

Requirement: You must supply buffer pools for all data sets in the partitions that are unloaded. This includes the ILDSs.

Recommendation: Enable OSAM sequential buffering for databases that use OSAM.

The following code is an example of the HD Reorganization Unload utility control statement to unload one partition.

SYSIN DD *
PARTITION=PEO02

The following code shows the HD Reorganization Unload utility control statement to unload three partitions.

SYSIN DD *
PARTITION=PEO04,NUMBER=3

The following JCL shows a sample job that unloads a HALDB partition.

//JOUKO3C JOB  (999,POK),JOUKO3,CLASS=A,NOTIFY=&SYSUID,
//        MSGLEVEL=(1,1),MSGCLASS=X,REGION=0M
//JOBLIB    DD DSN=IMSPSA.IMS0.SDFSRESL,DISP=SHR
//          DD DSN=IMSPSA.IM0A.MDALIB,DISP=SHR
//*******************************************************************
//*   HD UNLOAD FOR THE PARTITION PEO02 OF PEOPLE DATABASE
//*******************************************************************
//UNLOAD   EXEC PGM=DFSRRC00,REGION=1024K,
//         PARM='ULU,DFSURGU0,PEOPLE,,,,,,,,,,,Y,N'
//DFSRESLB  DD DSN=IMSPSA.IMS0.SDFSRESL,DISP=SHR
//IMS      DD DISP=SHR,DSN=JOUKO3.HALDB.DBDLIB
//DFSURGU1 DD DSN=JOUKO3.UNLOAD.PEO02,UNIT=3390,VOL=SER=TOTIMN,
//         SPACE=(CYL,(10,5),RLSE),DISP=(NEW,CATLG)
//DFSVSAMP DD *
IOBF=(4096,50)
VSRBF=8192,50
/*
//SYSPRINT DD SYSOUT=*
//DFSCTL    DD *
SBPARM ACTIV=COND
/*
//SYSIN   DD *
PARTITION=PEO02
/*

The IMS High Performance Unload tool is an alternative to the HD Reorganization Unload utility. You can use the High Performance Unload tool to unload any number of partitions or the entire database.

Related Reading: For more information on the High Performance Unload tool, see IMS High Performance Unload for z/OS® User's Guide.