REASON=X'00C4'



IBM's flagship relational database management system

Re: REASON=X'00C4'

Postby GuyC » Thu Apr 08, 2010 7:40 pm

you can't resolve reorg pending with a reorg share level change.
try using share level none
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: REASON=X'00C4'

Postby arshadhrashid » Fri Apr 09, 2010 9:31 pm

Hi,
I have cases open with IBM and Platinum both and so far the only thing we found out is that there is a data corruption that happend
during the upgrade. I will update the forum if I get some solution form any one of them
Thanks,
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby arshadhrashid » Fri Apr 09, 2010 9:38 pm

Hi GuyC
Shere level has no impact in my case. The same error is generated in any share level.
thanks
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby arshadhrashid » Fri Apr 23, 2010 4:25 am

It finally turened out that the tablespaces in question are corrupted and cannot be repaired.
Platinum support doesnot think that any upgarde could have caused that.
The only soluion was to drop and re-create all the corrupted objects, which we did
and the issue was resloved.

Thanks everyone for their input.
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Re: REASON=X'00C4'

Postby dick scherrer » Fri Apr 23, 2010 5:54 am

Good to hear it is resolved even though the reason was not detected. . .

Thank you for posting the resolution :)

Hopefully, this will not recur,

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: REASON=X'00C4'

Postby arshadhrashid » Fri Apr 23, 2010 8:47 pm

By the way as per IBM (I just got it today) This data corruption is resolved with PK95354.
Which is RSU level 1001.

This will prevent this corruption in the future but there is no solution for my issue now.

Thanks,
arshadhrashid
 
Posts: 70
Joined: Tue Jul 28, 2009 5:03 am
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post