DSNU346I csect-name RECORD(n), CONCATENATED SQL/DS RECORD IS TOO LARGE

Explanation

A LOAD utility was executing with FORMAT SQL/DS input data. Multiple spanned segments of the input data were concatenated into one logical record for loading. The resultant concatenated record is too large to be processed. The maximum length allowed is 32764 bytes.

System action

When discard processing is specified, the input data set logical record is noted and is discarded in the DISCARD phase. The LOAD utility continues to process additional records in the input data set and the severity is 4. When discard processing is not specified, the severity is 8 and the LOAD utility terminates.

System programmer response

If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

User response

When discard processing is specified, examine the records in the DISCARDS data set after the LOAD utility completes. Correct the error in the discarded input data. Then run the LOAD utility with the RESUME YES option using the DISCARDS data set as input. When discard processing is not specified, correct the error in the input data set and rerun the job.

Problem determination

Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • Dynamic dump, taken to SYS1.DUMPxx data set, by Db2 (04E and 04F abends).
  • Listing of SYS1.LOGREC data set, obtained by executing IFCEREP1.

Severity

4 or 8