How to implement dynamic allocation of the SYSREC | SYSCTL data sets using TEMPLATE processing executing CA Fast Unload.

book

Article ID: 39700

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Summary:

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

 

Instructions:

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;

Environment

Release:
Component: PFU