Loading the Database with ETOTLOAD

z/VSE Job Control Language › Loading the Database with ETOTLOAD

Loading the Database with ETOTLOAD

Use the following JCL to execute ETOTLOAD. Output from this step is processed by the FASTLOAD utility.

Note: For more information about the FASTLOAD utility statement, see the CA IDMS Utilities Guide.

ETOTLOAD (z/VSE)

*
// LIBDEF *,SEARCH=(user.sublib,idms.sublib)
// DLBL   dcmsg,'idms.sysmsg.ddldcmsg',1999/365,DA
// EXTENT SYSnnn,nnnnnn
// ASSGN SYSnnn,DISK,VOL=nnnnnn,SHR
*
// DLBL IDMSPCH,'sort1',0,SD
// EXTENT SYSnnn,nnnnnn,,,ssss,1
// DLBL SYS002,'sortdb11',0,SD
// EXTENT SYSnnn,nnnnnn,,,ssss,llll
// DLBL RELDCTL,'reldctl',0,SD
// EXTENT SYSnnn,nnnnnn,,,ssss,5
// ASSGN SYSnnn,DISK,VOL=nnnnnn,SHR
*
// DLBL unload,'total.data',0,SD
// EXTENT SYSnnn,nnnnnn,,,ssss,llll
// ASSGN SYSnnn,DISK,VOL=nnnnnn,SHR
*
// DLBL SYSIDMS,'#SYSIPT'
// EXEC ETOTLOAD,SIZE=256K
DMCL=etotdmcl DBNAME=etotal
/*
/*

idms.sublib	The name of the CA IDMS library
user.sublib	The name of the user sublibrary
dcmsg	Filename of the system message area (ddldcmsg)
idms.sysmsg.ddldcmsg	File ID of the CA IDMS system message area (DDLDCMSG)
SYSnnn	Logical unit of the volume for which the extent is effective
nnnnnn	Volume serial number of the file
sort1	Punch file for DBL1 step
sortdb11	Output file from ETOTLOAD to be used as input for FASTLOAD
reldctl	File ID for the file containing a control record with information about the subschema, DMCL, and segment to be used with FASTLOAD
nnnnnn	Volume serial number
ssss	Starting track (CKD) or block (FBA) of the disk extent
llll	Number of tracks (CKD) or blocks (FBA) in the disk extent
unload	Filename of the file containing data unloaded from the Total database (total.data)
total.data	File ID of the file containing data unloaded from the Total database
etotdmcl	SYSIDMS parameter specifying the name of the DMCL to be accessed at runtime Note: For more information about the SYSIDMS parameters, see the CA IDMS Common Facilities Guide.
etotal	SYSIDMS parameter specifying the name of the database to be accessed at runtime Note: For more information about the SYSIDMS parameters, see the CA IDMS Common Facilities Guide.