B37 on UNLDDSN allocated by TEMPLATE
Article ID: 259495
Updated On:
Products
Issue/Introduction
An unload utility fails with a B37 on the unload dataset allocated by the TEMPLATE control statement:
IEC030I B37-04,IFG0554A,jobname,step,ddname,dev,ser,
unload.dataset.name
DSNU016I 037 17:21:21.55 DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'0B37'
BPA0016E: DB2 UTILITY APPLICATION - INCOMPLETE.
How do you manually override the space allocation?
Environment
Release : 20.0
Resolution
When using the TEMPLATE control statement for the Unload, the space allocation is calculated by Db2.
IBM recommend that in order to improve the accuracy of the default space estimation, you should run the RUNSTATS utility with the UPDATE SPACE or UPDATE ALL option before you run the UNLOAD utility.
To work around the problem you can specify your own values for disk space by using the SPACE option in the TEMPLATE utility control statement:
TEMPLATE UNLDDSN DSN 'unload.dataset.name'
SPACE (primary,secondary) CYL
Specify appropriate values for primary and secondary.
Additional Information
For further details please refer to the IBM documentation on the TEMPLATE control statement.
Feedback
