Previous Topic: UNLOCKNext Topic: UPDATE STATISTICS


UNLOAD

DD statements for the batch command facility (z/OS)

//userdb   DD  DSN=user.olddb,DISP=SHR

Additional existing database files assignments, as required

//sysjrnl  DD  DUMMY
//SYS002   DD  DSN=user.dbl002,DISP=(NEW,PASS),UNIT=tape002,
//             DCB=(RECFM=VB,BLKSIZE=bbb002)
//SYS003   DD  DSN=user.dbl003,DISP=(NEW,PASS),UNIT=tape003,
//             DCB=(RECFM=VB,BLKSIZE=bbb003)
//SYSPCH   DD  DSN=&&sortunld,DISP=(NEW,PASS),UNIT=disk,
//             SPACE=(TRK,1),DCB=BLKSIZE=80
//RELDCTL  DD  DSN=user.reldctl,DISP=(NEW,CATLG),UNIT=nnnn,
               VOL=SER=nnnnnn,
               DCB=(RECFM=FB,LRECL=60,BLKSIZE=bbbctl)

userdb

DDname of the existing database file

user.olddb

Data set name of the existing database file

sysjrnl

DDname of the dummy journal file

user.dbl002

Data set name of the SYS002 output file

tape002

Symbolic device name of the SYS002 output file

bbb002

Block size of the SYS002 output file; must be at least the size of the largest database record plus 4 bytes

user.dbl003

Data set name of the SYS003 output file

tape003

Symbolic device name of the SYS003 output file

bbb003

Block size of the SYS003 output file

&&sortunld

Data set name of the sort parameters created by UNLOAD

disk

Symbolic device name of the sort parameter file

user.reldctl

Data set name of the reload control file containing control and set information

bbbctl

Size of the RELDCTL file. It should be a multiple of 60 with a maximum size of 32,760.