IBM Unload Utility Model using RC/Migrator
Article ID: 35465
Updated On: 07-02-2024
Products
Issue/Introduction
The IBM Unload Utility Model has been added to the standard @DEFAULT Utility Model in RC/Migrator for Db2 for z/OS (RCM) release r19.
The model utility element is: IBMULD
Resolution
There is an RC/Migrator Model symbol that can be used to generate IBM TEMPLATE or otherwise generate a normal .ALLOC batch processor dataset allocation.
Look in the symbol list:
UTILITY OBJ DESCRIPTION SIZE
IBMULD T IBM UNLOAD RPI
CMD SYMBOL ERR REPLACEMENT VALUE
_ ALLOC1 %CALC(%ROWLEN+6*%NROWS/%BYTETRK*60/100+1)_______________
_ ALLOC2 %CALC(%ROWLEN+6*%NROWS/%BYTETRK*30/100+1)_______________
_ DATACLAS ________________________________________________________
_ DATADSN %DSN..DA________________________________________________
_ DISK SYSDA___________________________________________________
_ DSN %USERID..%DSNQUAL2..%DSNQUAL3..D%DATE..T%TIME___________
_ LABEL SL______________________________________________________
_ LARGE 50000___________________________________________________
_ MGMTCLAS ________________________________________________________
_ PARTDSN %DSN..P&PART..DA________________________________________
_ STORCLAS ________________________________________________________
_ TAPE CART____________________________________________________
_ UNIT %DISK___________________________________________________
_ USETMPLT YES_____________________________________________________
_ VOLLIMIT ________________________________________________________
_ VOLSER ________________________________________________________
The USETMPLT symbol is set to YES to generate an IBM TEMPLATE statement.
If USETMPLT is not = YES then a batch processor .ALLOC statement is generated.
The generated Utility Statements look like:
<<< %USETMPLT = NO >>>
-- FROM IBMULD
.ALLOC FI(SYSCTL00) DUMMY
.ALLOC FI(UNLDDSN) +
DA('authid.dbname.TID28.D201019.T2105326.DA') +
TRACKS +
SPACE(1,1) +
UNIT(SYSDA) +
NEW CATALOG
.CALL UTIL UNLOAD PARM(ssid)
.DATA
UNLOAD
FROM TABLE authid.table
HEADER NONE
LIMIT ALL
NOPAD
UNLDDN UNLDDSN
SHRLEVEL REFERENCE
.ENDDATA
-- END OF IBMULD UTILITY
<<< %USETMPLT = YES >>>
-- FROM IBMULD
.CALL UTIL UNLOAD PARM(ssid)
.DATA
TEMPLATE UNLDDSN DSN 'authid.dbname.TID28.D201019.T2055200.DA'
SPACE CYL
UNLOAD
FROM TABLE authid.table
HEADER NONE
LIMIT ALL
NOPAD
UNLDDN UNLDDSN
SHRLEVEL REFERENCE
.ENDDATA
-- END OF IBMULD UTILITY
The IBM Unload can be coupled with an IBM LOAD or a Fast Load for data load operations simply by switching the load utilities using the "X" line command in the model as usual.
Additional Information
Feedback
