DB2 table giving -904 with reason code 00D70024

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

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.

guptae · Posted: Tue Dec 29, 2009 3:23 pm

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.

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

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.

Escapa · Posted: Tue Dec 29, 2009 4:21 pm

Check if DSN mentioned in error is migrated? If yes HRECALL it.

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

Hi Shambaji,

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

I think dataset is not migrated,it got deleted.

sushanth bobby · Posted: Tue Dec 29, 2009 9:52 pm

Hi Maliku,

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

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

guptae · Posted: Wed Dec 30, 2009 12:01 pm

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

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

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.

guptae · Posted: Wed Dec 30, 2009 12:58 pm

Hello Mallik,

Just check if you have any entry in MSTR for that?

dbzTHEdinosauer · Posted: Wed Dec 30, 2009 1:27 pm

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

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

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

Hi Senthil,

Thanks for the valuable reply!!!

I tried all the approaches except RECOVER utility. I hope it works

I will let you know the result.