IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

REASON 00D70014 in load utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Wed Oct 25, 2023 11:32 pm
Reply with quote

Hi,

I'm getting below for a IBM load utility:

DSNU398I DSNURWBF -UNEXPECTED PRCOESSING ERROR REASON =X'00E40318' ON TABLE
DSNT500I DSNUGBAC -RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
DSNU017I DSNUGBAC-UTILITY DATA BASE SERVICES MEMEORY EXECUTION ABEDNED,REASON =X'00E40347' CAUSE=X'00E40318'
As per reason code 00D70014 it states an attempt to extent datatset failed.I tried giving more spaces in SYS*DD cards,but still it is failing.How can this be resolved?
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2141
Location: USA

PostPosted: Wed Oct 25, 2023 11:40 pm
Reply with quote

RTFM:

Quote:
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 might merely be full or the data set might have reached its maximum allowable extents. For more 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
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Wed Oct 25, 2023 11:44 pm
Reply with quote

What are the possible ways for a db admin to resolve this type of error.What course of action/necessary steps we can follow.
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2594
Location: Silicon Valley

PostPosted: Thu Oct 26, 2023 2:12 am
Reply with quote

1. check the packs available to the data set. They might merely be full

a. Check the volumes in the storage pool. Make sure they have enough free space for the next dataset extent.

2. or the data set might have reached its maximum allowable extents

a. Check the data set allocation to make sure it has not reached its maximum.
Back to top
View user's profile Send private message
Akil

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Sat Nov 04, 2023 11:16 pm
Reply with quote

Check the volumes in the storage pool. Make sure they have enough free space for the next dataset extent.
Q:How do I estimate the space/volumes required for the next dataset extent to


Check the data set allocation to make sure it has not reached its maximum.
Q:My tablespace is defined with 4gb.How do I determine/check if has reached maximum or not.
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2594
Location: Silicon Valley

PostPosted: Mon Nov 06, 2023 8:16 am
Reply with quote

Did you read message DSNP00Ii?
see www.ibm.com/docs/en/db2-for-zos/12?topic=messages-dsnp001i
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 592
Location: London

PostPosted: Mon Nov 06, 2023 7:19 pm
Reply with quote

Akil wrote:
Check the volumes in the storage pool. Make sure they have enough free space for the next dataset extent.
Q:How do I estimate the space/volumes required for the next dataset extent to


Check the data set allocation to make sure it has not reached its maximum.
Q:My tablespace is defined with 4gb.How do I determine/check if has reached maximum or not.


You need to be asking your local Storage team for this information, it's not appropriate to be asking this of a forum that has no insight to your system.

They can tell you what the free-space status is for the STORGRP the datasets are allocated to.

If your Tablespace is defined with 4GB, then that is the maximum size it can be as a VSAM dataset unless it has a DATACLAS with the Extended Addressability feature enabled. Again, best to ask your local Storage team.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Use Copy Utility DB2 7
No new posts Unload and Load ISPF Table TSO/ISPF 4
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts Reorg abended with REASON=X'00E40347' DB2 2
Search our Forums:

Back to Top