Implement dynamic allocation of the SYSREC | SYSCTL data sets using TEMPLATE processing executing Fast Unload.

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Example syntax to implement dynamic allocation of SYSREC | SYSCTL data sets using TEMPLATE processing
executing Fast Unload for Db2 for z/OS (PFU).

Resolution

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;