Abend code of X'0878' while loading the tables

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

Hi,

I am getting abend code of X'0878' while loading the tables. Please let me know how i can resolve it.

Thanks!

dick scherrer · Posted: Mon Aug 06, 2007 8:46 pm

Hello,

When you ask about an abend, you need to post the JCL, the control statements, and the diagnostic information provided by the system.

Are you really getting an x'0878' or are you getting the DB2 -878?

If you have an x'0878' you need to include the reason code (which will be in the diagnostic information created by the system).

Both the DB2 -878 and the 878-nn abends are covered in the Manuals linked to from this site.

When you provide the necessary info, we may be able to offer suggestions.

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

Is there any limit on the number of partitions we can load thru a load job. I was loading 24 partitions in one job. It gave me X'0878'. When i tried to load only one partition, it went fine.

dbzTHEdinosauer · Posted: Mon Aug 06, 2007 10:30 pm

If you were taking advantage of the 'parallel load', then you need a loooooooooooooooot more memory.

dick scherrer · Posted: Mon Aug 06, 2007 10:53 pm

Hello,

If you want useful answers from the forum, you need to reply to questions asked and provide the information requested. . . .

As a habit, when something goes wrong, it is best to send all of the info you were presented by the abend, the JCL, and the control info you supplied when you submitted the job.

Is there some reason you would prefer shooting in the dark rather than simply posting the requested info? The better job you do presenting your situation, the better we can help.

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

I apologize for not giving the full information.

The error which i am getting for the load job is:

dbzTHEdinosauer · Posted: Tue Aug 07, 2007 12:09 am

gprerna,

had you supplied the JESMSGS (which you still have not), we would have known what the 878 refered to exactly. as I guessed, you are out of memory. You have one job with 30 tasks running simultaneously.

you have a few choices:

convince your management to buy more iron
run your monster job in the off hours
read the manual and learn how to reduce the task load over several steps until you find the fit that works (load on the machine vs time you run your job)

I image you have more tablespaces to administer, which means a lot of trial and error.

no one one this board is going to take the time in this forum to help you tune your DB2 Admin functions. It requires too many site specific pieces of data.

either you are in a very small shop (no one with as little problem solving ability as you seem to have should be a DBA) and drew the short straw and are DBA or this is a test system, in which case you should talk to your DBA's. If your present job should ever initiate and grab enough memory to run, nothing else on the box will, in which case I suggest you start sending out resumes.