MVSFORUMS.com

[AD7]

Hi all,

I am running a load JCL for a few tables using the DSNUPROC utility.

The JCL started running properly and even loaded 2 of the tables, however when the load step for the third table came, i got the following abend - SB37

I increased the space parameters for the temporary data sets used for sorting before loading the tables and ran the JCl again, this time I got an abend - S04E

The tables that I am trying to load are in the development environment, but are based on the production priqty and seqty and parameters.

Please advise.

Thanks,
A-D

[bauer]

AD7,


look for the reason code.

Meening of o4e is:



04E

Explanation: When the system detects an error in internal IBM DATABASE 2 (DB2) (*) processing, it will abnormally end a connected user task (TCB) or one of its own internal tasks.

Source: Data Facility Product (DFP)

System Action: The system abnormally ends the connected user task or the DB2 internal task.

Application Programmer Response: Check register 15 of the SDWA section 'General Purpose Registers at Time of Error', and locate the accompanying reason code. In addition,
check the information displayed at the user's terminal, and in the corresponding SYS1.LOGREC entry.

System Programmer Response: If the error recurs and the program is not in error, look at the messages in the job log for more information. Search problem reporting data bases
for a fix for the problem. If no fix exists, contact the IBM Support Center. Provide the SYSOUT output for the job and the SYS1.LOGREC error record.

[AD7]

@BAUER

Thank you so much!

The first load abended because the space allocated for the temporary data sets was insufficient, I had increased the parameters and re-ran the JCL.

The second abend came - because the tablespaces being loaded had gone into copy pending. I forced access to the tablespaces and ran the JCl again to a successful completion

Thanks again!