oncheck -cD question
Hi all,
When I checked a database with oncheck -cD database
this warning comes out:
WARNING: data page 0x9732 in tablespace 0x600002 appears to be
more or less full than is indicated in the bitmap.
Bitmap mode: 0xc, Calculated mode: 0x4.
is there any side effect for this if I answer yes to all of them?
Why do this happen?
Thanks in advance
It happened to my databases after migrate from IDSFC2 to IDSFC9.
After testing on a pair of tables, I decided there were no lost of data,
so, I made oncheck -ycD to all of the tables.
El mar, 17-02-2009 a las 13:44 -0500, PAULO RAFAEL PADILLA escribió:
> Hi all,
>
> When I checked a database with oncheck -cD database
>
> this warning comes out:
>
> WARNING: data page 0x9732 in tablespace 0x600002 appears to be
>
> more or less full than is indicated in the bitmap.
>
> Bitmap mode: 0xc, Calculated mode: 0x4.
>
> is there any side effect for this if I answer yes to all of them?
>
> Why do this happen?
>
> Thanks in advance
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thank you Nestor. I realized that I had no errors after answer yes to all of them. Does any one knows why this happened?
I post what support told me.
It happened due to migrations or crashes in databases.
For this example:
WARNING: data page 0x9732 in tablespace 0x600002 appears to be
more or less full than is indicated in the bitmap.
Bitmap mode: 0xc, Calculated mode: 0x4.
It means that system has recorded this page 0x9732 in tablespace 0x600002 as
full, but new calculus for it indicates that it isn't. So its pointed for
sanity on data.
So IDS showed you to fix it and you must press yes.
It's recommended to run these commands additionally:
oncheck -cI database_name
oncheck -cD database_name
oncheck -cr
oncheck -cc database_name
That's all!