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: 7995
Location: Bellevue, IA

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: 1534
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: 10231
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: 1534
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 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 CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm


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