|
View previous topic :: View next topic
|
| Author |
Message |
lokesh vasanthi
New User
Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India
|
|
|
|
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 |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
Issue the command
| Code: |
| -start db(MERFINDV) sp(MF06RJTS) access force |
|
|
| Back to top |
|
|
lokesh vasanthi
New User
Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India
|
|
|
|
Hi,
The Database and Indexspace already in RW Status.Its not in Checkpending or Copy pending.
Nanda |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
lokesh vasanthi
New User
Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
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 |
|
|
lokesh vasanthi
New User
Joined: 19 Aug 2005
Posts: 17
Location: Chennai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
You're welcome - good to hear this is resolved - thank you for posting the resolution 
d |
|
| Back to top |
|
|
|
|
