Example JCL: Consistent load
Review JCL examples for Consistent load jobs.
Example 1: Nonparallel consistent load
The following JCL example loads data to the accelerator at a consistent time without parallel processing.
//JOBCARD JOB USER01,CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),
// USER=&SYSUID,NOTIFY=&SYSUID,REGION=0M
//*
//*
//*
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* Job Generated by Accelerator Loader *
//* *
//* DB2 SSID: QAA5 *
//* Profile: USER01.SAMPL1 *
//* Desc: Consistent Load *
//* User: USER01 *
//* Date: Thursday 15/12/13 *
//* Time: 09:34:14.89 *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* Step: HLOC0100 *
//* *
//* Desc: This step will invoke *
//* Accelerator Loader *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//HLOC0100 EXEC PGM=HLO#MAIN,
// REGION=0M,
// PARM=(QAA5)
//STEPLIB DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SHLOLOAD
// DD DISP=SHR,DSN=RSQA.FEC130.IBMTAPE.SFECLOAD
// DD DISP=SHR,DSN=QDS5.SDSNEXIT
// DD DISP=SHR,DSN=DSN.VA10.SDSNLOAD
//DB2PARMS DD DISP=SHR,DSN=RSTEST.HLO210.DB2CNTL
//SORAMSGS DD SYSOUT=*
//SR0AMSGS DD SYSOUT=*
//SORAWK00 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SORAWK01 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SORAWK02 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK00 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK01 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK02 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTMSGS DD SYSOUT=*
//INFOM DD SYSOUT=*
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP02' -
) -
TO_CURRENT -
) -
ACCELNAME QDS5ACC1 -
PARALLEL '0,1' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLQ -
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
)
/*
//Example 2: Parallel consistent load
The following JCL example shows a consistent load job with parallel processing of two 16-partition tables.
//JOBCARD JOB USER01,CLASS=A,MSGCLASS=X,USER=&SYSUID,NOTIFY=&SYSUID,
// REGION=0M
//*
//*
//*
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* Job Generated by Accelerator Loader *
//* *
//* DB2 SSID: QAA5 *
//* Profile: USER01.PARALLEL '16,07' *
//* Desc: *
//* User: USER01 *
//* Date: Thursday 14/03/13 *
//* Time: 17:54:28.50 *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//* *
//* Step: HLOC0100 *
//* *
//* Desc: This step will invoke *
//* Accelerator Loader *
//* *
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//HLOC0100 EXEC PGM=HLO#MAIN,
// REGION=0M,
// PARM=(QAA5)
//STEPLIB DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SHLOLOAD
// DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SFECLOAD
// DD DISP=SHR,DSN=QDS5.SDSNEXIT
// DD DISP=SHR,DSN=DSN.VA10.SDSNLOAD
//DB2PARMS DD DISP=SHR,DSN=RSTEST.HLO210.DB2CNTL
//*
//SORAMSGS DD SYSOUT=*
//SR0AMSGS DD SYSOUT=*
//SORAWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SORBMSGS DD SYSOUT=*
//SR0BMSGS DD SYSOUT=*
//SORBWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORBWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORBWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0BWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0BWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0BWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SORCMSGS DD SYSOUT=*
//SR0CMSGS DD SYSOUT=*
//SORCWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORCWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORCWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0CWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0CWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0CWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SORDMSGS DD SYSOUT=*
//SR0DMSGS DD SYSOUT=*
//SORDWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORDWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORDWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0DWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0DWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0DWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SOREMSGS DD SYSOUT=*
//SR0EMSGS DD SYSOUT=*
//SOREWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SOREWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SOREWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0EWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0EWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0EWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SORFMSGS DD SYSOUT=*
//SR0FMSGS DD SYSOUT=*
//SORFWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORFWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORFWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0FWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0FWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0FWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SORGMSGS DD SYSOUT=*
//SR0GMSGS DD SYSOUT=*
//SORGWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORGWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORGWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0GWK01 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0GWK02 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0GWK03 DD UNIT=SYSDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTMSGS DD SYSOUT=*
//INFOM DD SYSOUT=*
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 1 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 2 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 3 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 4 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 5 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 6 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 7 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 8 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 9 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 10 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 11 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 12 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 13 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 14 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 15 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 16 -
) -
TO_CURRENT -
) -
ACCELNAME QDS5ACC1 -
PARALLEL '16,7' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO -
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
)
/*
//
Example 3: Controlling whether to process all partitions individually or as a whole
In the ISPF interface, the Load partitions individually field controls whether to process all partitions individually or to process them as a whole. The following examples show the generated SYSIN statement for each value:
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 1 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 2 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 3 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 4 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 5 -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
PARTITION 6 -
) -
TO_CURRENT -
) -
ACCELNAME QA1AACC1 -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO-
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
)
/*
////SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
) -
TO_CURRENT -
) -
ACCELNAME QA1AACC1 -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO-
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
) -
/*
//Example 4: Loading data into an alternate accelerator table or AOT on the same or another Db2 subsystem
This section contains two examples.
The first example specifies the target. The source is on SSID DBB5. The target has a different table name and is on SSID QA1A. This JCL is valid for AOT, partitioned, and segmented table types.
//JOBCARD JOB CSKUVA,CLASS=A,
// MSGCLASS=X,
// USER=&SYSUID,
// REGION=0M,
// NOTIFY=&SYSUID
//************************************************************
//HLOC0100 EXEC PGM=HLO#MAIN,
// REGION=0000M,
// PARM=(DBB5)
//STEPLIB DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SHLOLOAD
// DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SFECLOAD
//DB2PARMS DD DISP=SHR,DSN=RSTEST.HLO210.DB2CNTL
//*
//SORAMSGS DD SYSOUT=*
//SR0AMSGS DD SYSOUT=*
//SORAWK01 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK02 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK03 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK01 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK02 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK03 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTMSGS DD SYSOUT=*
//INFOM DD SYSOUT=*
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01_SOURCE' -
TARGET_CREATOR 'DSNC810' -
TARGET_NAME 'EMP01_TARGET' -
) -
TO_CURRENT -
) -
ACCELNAME QA1AACC1 -
TARGET_SSID QA1A -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO-
ACCEL_ON_SUCCESS_ENABLE YES -
DB2_SORT YES -
CHECK_DATA WRITE -
ACCEL_REMOVE_AND_ADD_TABLES -
)
/*
//
In the following example, TARGET_CREATOR and TARGET_NAME are specified. TARGET_SSID is not specified because the source and target are on the same subsystem.
//JOBCARD JOB CSKUMA,CLASS=A,
// MSGCLASS=X,
// USER=&SYSUID,
// REGION=0M,
// NOTIFY=&SYSUID
//** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
//HLOC0100 EXEC PGM=HLO#MAIN,
// REGION=0000M,
// PARM=(DBB5)
//STEPLIB DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SHLOLOAD
// DD DISP=SHR,DSN=RSQA.HLO210.IBMTAPE.SFECLOAD
// DD DISP=SHR,DSN=DSN.DDS5.SDSNEXIT
// DD DISP=SHR,DSN=DSN.VB10.SDSNLOAD
//DB2PARMS DD DISP=SHR,DSN=RSTEST.HLO210.DB2CNTL
//*
//SORAMSGS DD SYSOUT=*
//SR0AMSGS DD SYSOUT=*
//SORAWK01 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK02 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SORAWK03 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK01 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK02 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//SR0AWK03 DD UNIT=SYSALLDA,SPACE=(CYL,(00020,00001),,,ROUND)
//*
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTMSGS DD SYSOUT=*
//INFOM DD SYSOUT=*
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
( -
CREATOR 'DSNC810' -
NAME 'EMP01_SOURCE' -
TARGET_CREATOR 'DSNC810' -
TARGET_NAME 'EMP01_TARGET' -
) -
TO_CURRENT -
) -
ACCELNAME DDS5ACC1 -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO-
ACCEL_ON_SUCCESS_ENABLE YES -
DB2_SORT YES -
CHECK_DATA WRITE -
ACCEL_REMOVE_AND_ADD_TABLES -
)
/*
//
Example 5: Loading data to multiple accelerators using Consistent load
Note: The following examples use Consistent load functionality and not the HALOAD utility.
In the following example, multiple accelerators specified
individually will be loaded:
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP02' -
) -
TO_CURRENT -
) -
ACCELNAME 'IDAAS01,IDAAS02,IDAAS03' -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO -
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
)
In the following example, multiple accelerators will be loaded by specifying an
accelerator group. The accelerator group expands to its individual members at run
time.
IDAA_CONSISTENT_LOAD -
( -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP02' -
) -
TO_CURRENT -
) -
ACCELNAME 'ACCELGRP' -
PARALLEL '0,4' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO -
ACCEL_ON_SUCCESS_ENABLE NO -
DB2_SORT YES -
CHECK_DATA WRITE -
)
Example 6: FlashCopy template name
The following JCL example creates a Consistent Load step with FlashCopy. To ensure that a
FlashCopy is performed, you must specify the template name for FCCOPYDDN at the Global level and
specify the template name and DSN for TEMPLATE at the Global level.
//HLOC0101 EXEC PGM=HLO#MAIN,
// REGION=0M,
// PARM=(DB2SSID)
//DB2PARMS DD DISP=SHR,DSN=RSTEST.HLO210.DB2CNTL
//SORAMSGS DD SYSOUT=*
//SR0AMSGS DD SYSOUT=*
//SORAWK00 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SORAWK01 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SORAWK02 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK00 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK01 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SR0AWK02 DD UNIT=SYSDA,SPACE=(CYL,(00010,00010),,,ROUND)
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORAMSGS DD SYSOUT=*
//INFOM DD SYSOUT=*
//SYSINHLO DD *
IDAA_CONSISTENT_LOAD -
( -
TEMPLATE -
( -
NAME TEMPL1 -
DSN 'RSTEST.HLO210.&SSID..&DB(1,4).&DB(5,4)..&SN(1,4).&SN('-
'5,3).&SN(8,1)..PA&PA.' -
) -
GROUP -
( -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP01' -
) -
SPACE -
( -
CREATOR 'DSNC810' -
NAME 'EMP02' -
) -
TO_CURRENT -
NEW_COPY -
FCCOPYDDN TEMPL1 -
) -
ACCELNAME 'ACCELNAME' -
PARALLEL '0,1' -
LOG_COPY_PREFERENCE R1R2A1A2 -
USER_INDICATOR HLO -
ACCEL_REMOVE_AND_ADD_TABLES -
ACCEL_ON_SUCCESS_ENABLE YES -
)