Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Abend code of X'0878' while loading the tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gprerna

New User


Joined: 21 Mar 2007
Posts: 38
Location: US

PostPosted: Mon Aug 06, 2007 7:58 pm    Post subject: Abend code of X'0878' while loading the tables
Reply with quote

Hi,

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

Thanks!
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 06, 2007 8:46 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
gprerna

New User


Joined: 21 Mar 2007
Posts: 38
Location: US

PostPosted: Mon Aug 06, 2007 9:45 pm    Post subject: Re: Abend code of X'0878' while loading the tables
Reply with quote

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.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Aug 06, 2007 10:30 pm    Post subject:
Reply with quote

If you were taking advantage of the 'parallel load', then you need a loooooooooooooooot more memory.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 06, 2007 10:53 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
gprerna

New User


Joined: 21 Mar 2007
Posts: 38
Location: US

PostPosted: Mon Aug 06, 2007 11:10 pm    Post subject: Re: Abend code of X'0878' while loading the tables
Reply with quote

I apologize for not giving the full information.

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

Code:
INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 6     
PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF TASKS = 24
UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'0878'   


The Job card is as below:

Code:
//XXXXXXXX JOB (XXXX),'LOAD',REGION=0M,
//  CLASS=0,MSGCLASS=X,NOTIFY=&SYSUID     



Job:

Code:
//NBK17DEX JOB (NKTC),'LOAD ALRT CUST',REGION=0M,                     
//  CLASS=0,MSGCLASS=X,NOTIFY=&SYSUID                                 
//*                                                                   
//*+JBS BIND SYS9S01.PERM                                             
//   JCLLIB ORDER=(CNET.INITLOAD.CIT3.PROCLIB)                         
//JOBLIB   DD  DSN=DB2T5.DBA.LOADLIB,DISP=SHR                         
//         DD  DSN=D9ST.DB2.DSNLOAD,DISP=SHR                           
//U11STEP  EXEC UCC11                                                 
//*                                                                   
//JS000100 EXEC DB2CMDT5                                               
//SYSUT1   DD *                                                       
-TERM UTILITY(CNE04.ALERTCUST)                                         
/*   
//JS000001 EXEC CNE1S3SL,                     
//         SSID=D9ST,                         
//         UTIL=DB2UTLT5,                     
//         UID='CNE04.ALERTCUST',             
//         HCNE=CNET.INITLOD,                 
//         MIDENV=CIT3,                       
//         TABLNM=ALERT.CUST,                 
//         PARMLIB=CNET.INITLOAD.CIT3.PARMLIB,
//         PARMEM=CNE1SSL1



Please let me know in case you need more details.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Aug 07, 2007 12:09 am    Post subject:
Reply with quote

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:
  1. convince your management to buy more iron
  2. run your monster job in the off hours
  3. 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.
icon_lol.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us