Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
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.