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
 

 

Error -904 - UNAVAILABLE RESOURCE

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

New User


Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India

PostPosted: Sat Feb 27, 2010 6:40 am    Post subject: Error -904 - UNAVAILABLE RESOURCE
Reply with quote

Hi,

I tried to delete the row from one table using Platinum,when i tried to save its giving -904.Below is the error details

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE
00000200, AND RESOURCE NAME MERFINDV.MF06RJTS
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRDWC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -250 13172746 0 13223106 -974970878 12714050
SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF06' X'00C9000A' X'00000000'
X'00C9C4C2' X'C5E32002' X'00C20042' SQL DIAGNOSTIC
INFORMATION

I have checked the Reason code

The manual says
System Action: The operation is not allowed.
Operator Response: Notify the system programmer.

System Programmer Response: The check pending status needs to be resolved before the operation will be allowed.

If the object is a table space with referential relationships, then run the CHECK DATA utility to check for referential integrity violations.

If the object is a base table space with LOB columns, then run the CHECK DATA utility to validate the auxiliary columns.

If the object is a LOB table space, then run the CHECK LOB utility to validate the structure of the LOB table space.

If the object is an index space, then run the CHECK INDEX utility to verify that the index keys are consistent with the data in the table space or table space partition.

I checked the tablespace and Indexspace both are RW status.

Any help on this.

Thanks,
Nanda
Back to top
View user's profile Send private message

Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Sat Feb 27, 2010 11:58 am    Post subject:
Reply with quote

Issue the command
Code:
-start db(MERFINDV) sp(MF06RJTS) access force
Back to top
View user's profile Send private message
lokesh vasanthi

New User


Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India

PostPosted: Sat Feb 27, 2010 10:43 pm    Post subject: Reply to: Error -904 - UNAVAILABLE RESOURCE
Reply with quote

Hi,

The Database and Indexspace already in RW Status.Its not in Checkpending or Copy pending.

Nanda
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Feb 28, 2010 12:08 am    Post subject:
Reply with quote

Hello,

What about the tablespace? From an IBM publication:
Quote:
Resource Type: Tablespace or index
Event ID ....State ........Description
00C900A3 ..Exception ..Tablespace in Check pending mode
Back to top
View user's profile Send private message
lokesh vasanthi

New User


Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India

PostPosted: Sun Feb 28, 2010 6:56 am    Post subject:
Reply with quote

Hi Dick,

The Tablespace and Indexspace both are RW mode.

I have checked the RI through Platinume and there I have seen one columns like Rulename and Delete in that the delete column has the value of Restrict(I think this is causing the issue).

Any way get rid of this as application developer or do i need to contact DBA.

Thanks,
Nanda
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Feb 28, 2010 7:55 am    Post subject:
Reply with quote

Hi Nanda,

Quote:
Any way get rid of this as application developer or do i need to contact DBA.
I'd suggest working with the dba. They will know all about the environment there. Many of the tools/uses are restricted to the dba group.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Sun Feb 28, 2010 12:33 pm    Post subject: Reply to: Error -904 - UNAVAILABLE RESOURCE
Reply with quote

generally for this kind of issues the rule is to contact the DBAs
( obviously all depends on Your organization rules - but we do not know about them )
Back to top
View user's profile Send private message
lokesh vasanthi

New User


Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India

PostPosted: Fri Mar 05, 2010 7:45 pm    Post subject:
Reply with quote

Hi All,

I thought of post earlier,But I forgot

For the above issue in our shop we are having 2 subsystem(Test and Read) in our development LPAR. Test is for Development and Read is for Change Release testing.

When somebody creating the one of the child table in Read subsystem they pointed to Test Parent table.

When I tried to delete on the Test parent table due to Read Child table is in Checkpending status I was not able to delete the row from my Test table.

So I asked my DBA to remove the Check pending status from Read child table and i was able to delete the row.

Thanks,Nanda
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Mar 05, 2010 10:56 pm    Post subject: Reply to: Error -904 - UNAVAILABLE RESOURCE
Reply with quote

You're welcome - good to hear this is resolved - thank you for posting the resolution icon_smile.gif

d
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 DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


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