Re: BAD PAGE error after oncheck

Eugene Nechitaylo wrote: > Hello > > I ran into the following situation : > > oncheck -cD buzv:sysprocplan> TBLspace data check for buzv:informix.sysprocplan > BAD PAGE 8271bd: pg_frcnt -11 < 0 or > PAGEFREE 2020 > > As far as i know such error message says that pg_frcnt flag > on that page has the wrong value (to say exactly - the number > of free bytes on page). > > I think there's three ways to check it : > 1) Manually set the correct value for this flag. How to calculate the > real bytes free number? Am i wrong that he formula is: > PAGE_SIZE-(PAGE_HEADER_SIZE)-2*(TIME_STAMP_SIZE)- > (Number_of_slots*4)-(SUM_OF_ALL_SLOTS_SIZES) ? Only if you are a qualified IBM Informix systems engineer. > 2) Drop and recreate sysprocplan table. This one is SMI table, so idea > is to get all columns, indexes, constraints on it, delete the > corresponding items in systables, sysindexes e.t.c. and than manually > create this table ? This isn't an SMI table, it is a real table, hence the physical data pages on disk. However, it's a system table, so you can't drop & recreate it. > 3) DBEXPORT the whole database, than recreate it and dbimport. Last resort maybe. I would try running that oncheck command in Quiescent mode and see if it attempts to fix the page. Otherwise, speak to IBM tech support, they may have a fix, or be able to fix it for you. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list