Example syntax to implement dynamic allocation of SYSREC | SYSCTL data sets using TEMPLATE processing
executing Fast Unload for Db2 for z/OS (PFU).
The following is an example of PFU syntax using TEMPLATE processing to control dynamic allocation of SYSREC | SYSCTL data
sets where UNLDDN defaults to SYSREC and CTLDDN defaults to SYSCTL:
//SYSIN DD *
TEMPLATE
SYSREC
DSN '&USERID..&DB..&TS..P&PA..SYSREC'
TEMPLATE
SYSCTL
DSN '&USERID..&DB..&TS..P&PA..SYSCTL'
FASTUNLOAD
INPUT-FORMAT TABLE
OUTPUT-FORMAT DSNTIAUL
LOAD-CONTROL FASTLOAD
SQL-ACCESS NONE
SHRLEVEL REFERENCE
SELECT * FROM creator.tablename;
The following is another example of PFU dynamic allocation using TEMPLATE processing where the CTLDDN default has been modified to PUNCH:
TEMPLATE PUNCH DSN 'userid.&SSID..&DB..&TS..PUN&PA(3,3)'
DISP(NEW,CATLG,DELETE) UNIT SYSDA
TEMPLATE SYSREC DSN 'userid.&SSID..&DB..&TS..REC&PA(3,3)'
DISP(NEW,CATLG,DELETE) UNIT SYSDA
FASTUNLOAD
SHRLEVEL CHANGE
LOAD-CONTROL DB2LOAD
SQL-ACCESS NONE
PRINT-OPTIONS PTIMSG
OUTPUT-FORMAT DSNTIAUL
DISPLAY-STATUS 500000,I
VSAM-BUFFERS 360
CTLDDN PUNCH
UNLDDN SYSREC
LIMIT 10
SELECT * FROM creator.tbname PART 001 ORDER BY column;
SELECT * FROM creator.tbname PART 002 ORDER BY column;