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
 

 

S04E Abend with REASON=X'00E40347'

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

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Tue Sep 16, 2008 1:52 pm    Post subject: S04E Abend with REASON=X'00E40347'
Reply with quote

Hi,

I am trying to load data into a table that is partitioned using IBM LOAD and my job is ending up with S04E Abend. Please find the joblog below.

************************************************************************************
RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DDZI.DSNDBC.DTVIPC.STVIPC0.I0001.A087
UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40318' CAUSE=X'00C9000A'
UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
************************************************************************************

Can somebody help me what is the problem and what can be done to solve this issue.

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

vishal_arora

New User


Joined: 20 May 2005
Posts: 16

PostPosted: Tue Sep 16, 2008 2:31 pm    Post subject: Reply to: S04E Abend with REASON=X'00E40347'
Reply with quote

Hi ,

Well just this much of information is not enough to resolve your issue. Need some more details like :

1) Did you get this error on first partition itself or some records got loaded to partition then abended.
2) Need to look at load card.

Alternatively you can try :

1) See if there is UTIL id clash or some database backup jobs are running and the tablespace is in UT mode.
2) May be the partition you are trying to load is full . You need to terminate the load utility and then alter the partition key.
3) what operation used ? Load Replace or Resume . In my opinion first partition should be replace then resume otherwise if replace is used for all the partition then the tablespace gets deleted everytime.
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Tue Sep 16, 2008 2:40 pm    Post subject:
Reply with quote

Thanks for your reply.

I did not get this error for the first time. Actually my table has 545 partitions each having a capacity to hold about 25million rows. I got this abend while I was trying to load Part 87.

Please check the Control card
LOAD DATA LOG NO RESUME YES NOCOPYPEND
SORTNUM 128
SORTKEYS 1600000000
SORTDEVT SYSDA
INTO TABLE DBNAME.TABLENAME PART 0087 REPLACE REUSE INDDN(SYSREC)


The tablespace is in RW when I tried submitting the job.

Thanks,
KJ
Back to top
View user's profile Send private message
vishal_arora

New User


Joined: 20 May 2005
Posts: 16

PostPosted: Tue Sep 16, 2008 2:51 pm    Post subject: Reply to: S04E Abend with REASON=X'00E40347'
Reply with quote

Hi ,

I am doubting this as a SPACE issue as the Reason code and Resource type is pointing this only.

I think the VSAM datasets which is corresponds to your tablespace partition 87 reached max extents .

123 - is max extents for single volume VSAM dataset
255 - is Max extents for Multivolume datasets

Please use ISPF 3.4 option , to the check the max extents of the VSAM datasets for the tablespace . You can get the name of the datset from the joblog of your job .

If that's the case then you need to contact your DBA for a Alter Tablespace and increasing the PRIQTY and SECQTY or require a REORG.

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

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Tue Sep 16, 2008 3:13 pm    Post subject:
Reply with quote

What you mentioned is true.

Thank You so much for your reply.
KJ
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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm


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