oncheck -cD ERROR

Posted in 2008

BART GROOT — Mon, 21 Jan 2008 08:37:37 — source: IIUG Forums & Mailing Lists

Hi All, When running oncheck -cD on our database the following error message is returned: ERROR: Count of version 0 data pages 0 != pnv_pages -40 Reset partition data? After entering Y and rerunning the oncheck -cD all seems to be OK. Does anyone has any idea what this error exactly means? We do not encounter any problems. We have upgraded our informix from 9.40FC4 to 10.00FC6 lately. Could this be causing the error? Thanks, Bart.

↪ replying to BART GROOT

Keith Simmons — Mon, 21 Jan 2008 09:59:56 — source: IIUG Forums & Mailing Lists

On 21/01/2008, BART GROOT <bart.groot@corusgroup.com> wrote: > Hi All, > > When running oncheck -cD on our database the following error message is > returned: > > ERROR: Count of version 0 data pages 0 != pnv_pages -40 > Reset partition data? > > After entering Y and rerunning the oncheck -cD all seems to be OK. > > Does anyone has any idea what this error exactly means? We do not encounter > any problems. We have upgraded our informix from 9.40FC4 to 10.00FC6 lately. > Could this be causing the error? > > Thanks, > Bart. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > Bart Before you upgraded you did check you had no outstanding 'in-place' alters didn't you?? This looks like an issue with multiple versions of a table existing. Check for any in-place alters and I would suggest a pseudo update to get a single version of these tables and then rerun your checks. Of course I could be completely wrong !! Keith

↪ replying to Keith Simmons

BART GROOT — Mon, 21 Jan 2008 10:15:23 — source: IIUG Forums & Mailing Lists

Hi Keith, As far as I know there were no ongoing alters on tables prior to the upgrade. In addition I performed oncheck -ce / -cr / -cc / -cD /-cI checks (as suggested in the Informix manuals) prior to the upgrade. No strange things were found during these checks. Regards, Bart

↪ replying to BART GROOT

Keith Simmons — Mon, 21 Jan 2008 12:19:12 — source: IIUG Forums & Mailing Lists

On 21/01/2008, BART GROOT <bart.groot@corusgroup.com> wrote: > Hi Keith, > > As far as I know there were no ongoing alters on tables prior to the upgrade. > In addition I performed oncheck -ce / -cr / -cc / -cD /-cI checks (as > suggested in the Informix manuals) prior to the upgrade. No strange things > were found during these checks. > > Regards, > Bart > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > Bart No manuals handy, however I do not believe any of these commands will actually identify in place alters, they are only found from sysmaster or the out put from oncheck -pT. Following have reference to them:- http://groups.google.co.uk/group/comp.databases.informix/browse_thread/thread/d5 2784df63eb7a9c/ce51ddf71b94d955?hl=en&lnk=gst&q=identifying+in+place+alter#ce51d df71b94d955 You could have in-place alters without being aware of them, any database sructure changes such as adding or removing colums, extending text colums or changinf numeric to text? All these result in an in-place alter. If none of the able them dust your maintenance contract off !! Keith