Re: BAD PAGE error after oncheck

#1

Eugene Nechitaylo wrote:

Quote:

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.

Quote:

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.

Quote:

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.

+----------------------------------------------------------+-----------+

Quote:

Mark D. Stock mailto:mdstock (AT) MydasSolutions (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: BAD PAGE error after oncheck

comp.databases.informix comp.databases.informix

Re: BAD PAGE error after oncheck - 08-27-2003 , 11:02 AM