View previous topic :: View next topic
|
Author |
Message |
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
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 |
|
|
rexx77
New User
Joined: 14 Apr 2008 Posts: 78 Location: Mysore
|
|
|
|
Thanks for the reply.
Could you tell me how to check that underlined VSAM datasets? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
Could you tell me how to check that underlined VSAM datasets? |
ever heard of IDCAMS and LISTCAT |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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 |
|
|
|