Oninit cdi / Archive
Talk to an expert →

oncheck -cD question

Posted in 2009

Summary

Paulo Padilla got oncheck -cD warnings that a data page's bitmap mode (0xc) differed from the calculated mode (0x4) and asked about answering yes. Nestor Gomez Munoz saw it after a migration and ran oncheck -ycD without data loss. Paulo relayed support's view that migrations or crashes cause it, and advised following up with oncheck -cI, -cD, -cr and -cc.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

PAULO RAFAEL PADILLA — — source: IIUG Forums & Mailing Lists

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

↪ replying to PAULO RAFAEL PADILLA
nestor gomez munoz — — source: IIUG Forums & Mailing Lists

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. >

↪ replying to nestor gomez munoz
PAULO RAFAEL PADILLA — — source: IIUG Forums & Mailing Lists

Thank you Nestor. I realized that I had no errors after answer yes to all of them. Does any one knows why this happened?

↪ replying to nestor gomez munoz
PAULO RAFAEL PADILLA — — source: IIUG Forums & Mailing Lists

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 it’s 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!