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
 

 

DB2 table giving -904 with reason code 00D70024

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

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Tue Dec 29, 2009 3:08 pm    Post subject: DB2 table giving -904 with reason code 00D70024
Reply with quote

Hi,

I am getting -904 with reason code 00D70024 and type of resource is 220 when i tried to edit (Insert/Update) a record in a DB2 table. But I am not getting any problem while browsing/SELECT on the table.

When i verified the description about the given reason code, it says that "No data sets exist for a nonpartitioned table space or index space". If dataset is not available then how am i able to browse it using FileAid/SoftTech?

I verified the status of the tablespace and indexspace using PLATINUM tool. It says the status is RW.

Could you please let me know how to recover the table.
Back to top
View user's profile Send private message

guptae

Moderator


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

PostPosted: Tue Dec 29, 2009 3:23 pm    Post subject:
Reply with quote

Hello Mallik,

Would you please check that -904 you are getting for tablespace dataset or indexspace?
I have also faced the similar problem & drop & recreate the object.
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Tue Dec 29, 2009 3:29 pm    Post subject:
Reply with quote

Hi Guptae,

It is giving for TableSpace.

Even i have applied the same method when i faced same issue in development region. This time i cannot apply the same process because this issue occured in system test environment.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Dec 29, 2009 4:21 pm    Post subject:
Reply with quote

Check if DSN mentioned in error is migrated? If yes HRECALL it.
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Tue Dec 29, 2009 4:35 pm    Post subject:
Reply with quote

Hi Shambaji,

when i did HRECALL on the DSN, it says DATASET NOT IN CATALOG.

I think dataset is not migrated,it got deleted.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Dec 29, 2009 9:52 pm    Post subject:
Reply with quote

Hi Maliku,

Quote:
I am getting -904 with reason code 00D70024 and type of resource is 220 when i tried to edit (Insert/Update) a record in a DB2 table. But I am not getting any problem while browsing/SELECT on the table.


Since you get the error during INSERT/UPDATE and not during select. There might be a space problem. See the MSTR for messages.

Resize the object. Let us know what happens ?

Sushanth
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Wed Dec 30, 2009 10:27 am    Post subject:
Reply with quote

Hi Sushanth,

Following is the error which i am getting while Insert/Update. I didnot find MSTR in this error information. Can you please let me know how to see MSTR messages?

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURCE
00000220, AND RESOURCE NAME
UCTEST01.DSNDBC.DSHMPD02.ITLOC0L2.I0001.A001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 102 13172746 0 13820889 -1041948670 12714048
SQL DIAGNOSTIC INFORMATION Cannot Continue. Edit Session will End
Enter SQL Command to View the SQL Statement in Error
Back to top
View user's profile Send private message
guptae

Moderator


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

PostPosted: Wed Dec 30, 2009 12:01 pm    Post subject:
Reply with quote

Hello Mallik,

Please check in spool DSN_MSTR ( Here Change dsn_ to your subsystem name) & check for the date when you got the Error . It will have some entry on UCTEST01.DSNDBC.DSHMPD02.ITLOC0L2.I0001.A001
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Wed Dec 30, 2009 12:14 pm    Post subject:
Reply with quote

Hi guptae,

Thanks for the reply!!!

I am not inserting/updating the data using a program/JCL. I am trying to do that using tools like FileAid/SoftTech.

I am getting the error message which i have given in my earlier reply.
Back to top
View user's profile Send private message
guptae

Moderator


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

PostPosted: Wed Dec 30, 2009 12:58 pm    Post subject:
Reply with quote

Hello Mallik,

Just check if you have any entry in MSTR for that?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Dec 30, 2009 1:27 pm    Post subject:
Reply with quote

Mallik Annasagaram wrote:
I am not inserting/updating the data using a program/JCL. I am trying to do that using tools like FileAid/SoftTech.


does not matter how you are communicating with db2
db2 is returning the error.

Mallik,
suggest you do some reading and thinking and try to rise above your current level of ignorance(*)


(*) short form for lack of knowledge; if You are ignorant about its meaning check
http://en.wikipedia.org/wiki/Ignorance
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Mon Jan 04, 2010 7:24 am    Post subject:
Reply with quote

Malik,

It looks like that dataset is missing in the catalog. I.e. it may be got deleted.

Please check with your DBA or please do the following if you have access to do following

1) If the missing dataset is index space dataset, rebuild the corresponding index would help you to create the dataset again.

2) If the missing dataset is table space dataset,

a) If you want data from that table, Recover the dataset from last image copy dataset using RECOVER utility

b) If don't bother about data in the table, just run the LOAD with empty dataset as input, it will recreate the table space datasets.

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

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Mon Jan 04, 2010 10:41 am    Post subject:
Reply with quote

Hi Senthil,

Thanks for the valuable reply!!!

I tried all the approaches except RECOVER utility. I hope it works icon_lol.gif
I will let you know the result.
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 PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 3 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
This topic is locked: you cannot edit posts or make replies. Need to code a Rexx PGM sundaram.naveen CLIST & REXX 18 Thu Oct 06, 2016 6:45 pm
No new posts Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm


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