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
 

 

Load job fails with reason code '00E40318'

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

New User


Joined: 14 Apr 2008
Posts: 74
Location: Mysore

PostPosted: Fri Jun 26, 2009 9:03 pm    Post subject: Load job fails with reason code '00E40318'
Reply with quote

Greetings.

I am trying to load data from sequential file to Table. Seven partition of that table got loaded and the following error message is displayed. Also Rollback has happened.

Code:


DSNURWBF -UNEXPECTED PROCESSING ERROR,REASON=X'00E40318' ON TABLE - XXXXXXXXX

DSNT500I    177 11:16:55.45 DSNUGBAC - RESOURCE UNAVAILABLE           
                      REASON 00D70014                                 
                      TYPE 00000220                                   
                      NAME TESTIU2.DSNDBC.DATABASE NAME.TABLESPACE NAMEI0001.A007 


Load card i use is

Code:


LOAD DATA                                 
      REPLACE LOG NO ENFORCE CONSTRAINTS   
      NOCOPYPEND                           
      STATISTICS TABLE(ALL) INDEX(ALL)     
      ERRDDN SYSERR MAPDDN SYSMAP         
      DISCARDDN SYSDISC DISCARDS 1         
INTO TABLE ABCDEF.TABLE

     


Any help in solving this is greatly appreciated. TIA
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8119
Location: East Dubuque, Illinois, USA

PostPosted: Fri Jun 26, 2009 9:06 pm    Post subject:
Reply with quote

I don't do DB2, but I do know how to read manuals. This is a skill you might want to pick up. I Googled 00D70014 and got a manual:
Quote:
00D70014

Explanation

An attempt to extend a data set failed, because a problem was detected in media manager services.
System action

Abort the request.
Operator response

Notify the system programmer or database administrator.
System programmer response

Notify the database administrator if appropriate. Otherwise, check the packs available to the data set. They may merely be full or the data set may have reached its maximum allowable extents. For additional information, see the description of message DSNP001I.
User response

Notify the operator, system programmer, or database administrator.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1537
Location: Andromeda Galaxy

PostPosted: Fri Jun 26, 2009 9:42 pm    Post subject:
Reply with quote

Hi,


Can you please check if the LDS has hit the maximum extents?

In the sense check for the underlined VSAM dataset of the table space if it had reached the
maximum extent.

Regds,
Prem
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 74
Location: Mysore

PostPosted: Sat Jun 27, 2009 11:22 am    Post subject:
Reply with quote

Thanks for the reply.

Could you tell me how to check that underlined VSAM datasets?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Sat Jun 27, 2009 12:07 pm    Post subject: Reply to: Load job fails with reason code '00E40318'
Reply with quote

Quote:
Could you tell me how to check that underlined VSAM datasets?


ever heard of IDCAMS and LISTCAT icon_confused.gif
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1537
Location: Andromeda Galaxy

PostPosted: Sun Jun 28, 2009 4:11 pm    Post subject:
Reply with quote

rexx77 wrote:

Could you tell me how to check that underlined VSAM datasets?



Please get in touch with your DBA's they should be able to help you on on that regard
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Sun Jun 28, 2009 10:00 pm    Post subject:
Reply with quote

Hello Rexx,

It seems either your vsam dataset reached the maximum extents or storage group need to be alter to incude more volumes
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 UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
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 Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm


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