DSNU1036I csect-name - UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR dataset-use
Explanation
One of the following conditions occurred:
- The PRESORT option was specified for the LOAD utility, but the number of records could not be estimated.
- While processing a TEMPLATE utility statement that does not include the SPACE option, Db2 could not calculate the default data set size.
Db2 bases default calculations on the size
of existing data sets. In this situation, Db2 could not determine the size of existing data sets, because at least one of those existing data
sets is one of the following types:
- an in-stream data set
- a member of a partitioned data set
- a data set that resides on tape
- a result set that was generated by a DECLARE CURSOR statement that was executed by the EXEC SQL utility.
- dataset-use
- The data set that caused the error. dataset-use can be either a DD name, such as SYSREC, or a utility option, such as INDDN, that identifies the data set or template.
System action
Db2 halts utility processing for the current object. If the utility is processing a list of objects, utility processing of the next object proceeds or halts based on the OPTIONS ITEMERROR statement. By default, processing halts.
User response
Take one of the
following actions:
- If the error occurred because of a LOAD PRESORT statement, add the NUMRECS option to your LOAD statement to help the utility estimate the number of records.
- If the error occurred because of TEMPLATE statement without the SPACE option, add SPACE to the TEMPLATE statement in error and rerun the utility. If the utility is the LOAD utility, you must add the SPACE option to all TEMPLATE statements referenced in the LOAD statement, except for the input data set.
Severity
8 (error)
