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
 

 

DB2 Load Utility Batch Memory Execution abend with x'07FA'

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

New User


Joined: 19 Dec 2006
Posts: 16
Location: Mumbai

PostPosted: Tue Mar 06, 2007 3:30 pm    Post subject: DB2 Load Utility Batch Memory Execution abend with x'07FA'
Reply with quote

Hi,

I am trying to load very high number of records into a table. Due to the enormous input, the sort dataset (SYSUT1 and SORTOUT) became full and the job went down with SB37.

To avoid this condition, i defined the sort dataset on CART and submitted the job again (after terminating the utility and correcting the Recover pending status on indices). It ran fine and completed successfully.

I, then extended the same method (of creating sort dataset on CART) for loading another table of equal size. But this time it abended with S7FA code. The Output message showed that the

"Utility Batch memory execution abended REASON CODE X'07FA' "

I tried submitting the job again but was of no use. Then i defined the sort datasets on DISK in multiple volumes and could successfully load the table.

Please share your opinions about What the problem is with the usage of CART and how the issue could be addressed.

Thanks in anticipation...
Regards.
Back to top
View user's profile Send private message

vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Tue Mar 06, 2007 4:13 pm    Post subject:
Reply with quote

Quote:
"Utility Batch memory execution abended REASON CODE X'07FA' "

I tried submitting the job again but was of no use.


Did you made sure that, Tablespace and indexspace was not in restricted state when the LAOD job failed for the first time. But i do wonder how it ran second time when you defined on disk volume.

You can always use the SORTKEYS & SORTDEVT options to get rid of SYSUT1 & SORTOUT work datasets. These parameters adds to performance as well. It will avoid lot of I/O's especially when you have more indexes and more data on the table. I hope you are in the DB2 V7 or Higher level. Thanks
Back to top
View user's profile Send private message
Karthikeyan J

New User


Joined: 19 Dec 2006
Posts: 16
Location: Mumbai

PostPosted: Tue Mar 06, 2007 5:39 pm    Post subject: Hi Vini,
Reply with quote

Thank you very much for the quick reply.

I will try and see if SORTKEYS and SORTDEVT can help me. At the same time i am curious to know the reason behind the abend. The problem seems to be with CART.A Search on '07FA' the reason code suggests some MQ object being already open.It would be wonderfull if that error mesasage could be understood .

PS: I had made sure that the DATABASE and all the related Indices were not in restricted state or any other abended state.

Thanks in Anticipation
Back to top
View user's profile Send private message
sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Mon Mar 19, 2007 6:56 pm    Post subject:
Reply with quote

Hi
could u post the utility u are using to load or used while unloading ?

Sandeep
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 Batch job tunning sgandhla Testing & Performance analysis 0 Fri Mar 24, 2017 9:41 pm
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm


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