Oninit cdi / Archive
Talk to an expert →

corrupt page location

Posted in 2013

Topics: Storage & Space Management, Logging & Checkpoints, Versions, Editions & End-of-Life

PUSHPA KUMARA — — source: IIUG Forums & Mailing Lists

Hi All, i have face page corrupt issue so is there any way to find exact page loation related to "7:3167600" with oncheck -pe command output or any other massage log as bellow --- % onstat -m IBM Informix Dynamic Server Version 11.50.FC8GE -- On-Line (Prim) -- Up 2 days 10:30:10 -- 4994048 Kbytes -------------------------------------------------------------------------------04:00:07 Checkpoint Completed: duration was 5 seconds. 04:00:07 Mon Aug 26 - loguniq 26443, logpos 0x101d018, timestamp: 0xae1c8c36 Interval: 845644 04:00:07 Maximum server connections 147 04:00:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 3607, Llog used 8195 04:00:07 Level 0 Archive started on rootdbs, phydbs, logdbs, xxxdbs 04:20:23 Assert Warning: Archive detects that page 7:3167600 is corrupt. Thanks Pushpa

↪ replying to PUSHPA KUMARA
Art Kagel — — source: IIUG Forums & Mailing Lists

Yes, oncheck -pe and look for an extent in chunk #7 that includes page # 3,167,600. Or you can query sysextents: select * from sysextents where chunk = 7 and offset <= 3167600 and (offset + size) >= 3167600; Alternatively, you could just run an oncheck -cDI and oncheck -cr and let oncheck find the problem. That will also show up any corruption in other objects that the archive didn't notice. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 28, 2013 at 2:08 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hi All, > > i have face page corrupt issue so is there any way to find exact page > loation > related to "7:3167600" with oncheck -pe command output or any other > > massage log as bellow > --- > % onstat -m> > IBM Informix Dynamic Server Version 11.50.FC8GE -- On-Line (Prim) -- Up 2> days > 10:30:10 -- 4994048 Kbytes > > > ------------------------------------------------------------------------------- > 04:00:07 Checkpoint Completed: duration was 5 seconds. > 04:00:07 Mon Aug 26 - loguniq 26443, logpos 0x101d018, timestamp: > 0xae1c8c36 > Interval: 845644 > > 04:00:07 Maximum server connections 147 > 04:00:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 3607, Llog used 8195 > > 04:00:07 Level 0 Archive started on rootdbs, phydbs, logdbs, xxxdbs > 04:20:23 Assert Warning: Archive detects that page 7:3167600 is corrupt. > > Thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3441d00c544904e4ffd277

Related threads

Glossary