oncheck -cD: migration from 7.31 to 9.40

Posted in 2005

Topics: Installation, Setup & Upgrades, Storage & Space Management, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life

Khaled Bentebal — Fri, 01 Jul 2005 11:34:29 — source: IIUG Forums & Mailing Lists

Hi, We did a migration from IDS 7.31 to IDS 9.40 on IBM AIX by installing = the product on a different directory (no export and no import). All of the ALTER IN PLACEs have been resolved before migration using a = dummy update. After the migration has been accomplished, we run oncheck -cD <database> = and we get the following messages on certains tables: TBLspace data check for <database>:<table> WARNING: data page 0x1 in tablespace 0x2c00004 appears to be more or less full than is indicated in the bitmap. Bitmap mode: 0x4, Calculated mode: 0xc Reset the bitmap mode for this page? This occurs on a lot of tables (dozens) and is annoying since we want to = do automatic migrations without intervention. This is telling us that the value of the bitmap page for this data page = is not in sync with the data page fullness. Any idea why this occurs and how to solve this ? Thanks in advance khaled ------=_NextPart_001_0782_01C57E40.92FF0380 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>We did a migration from IDS 7.31 to IDS = 9.40 on IBM=20 AIX by installing the product on a different directory (no export and no = import).</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>All of the ALTER IN PLACEs have been = resolved=20 before migration using a dummy update.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>After the migration has been = accomplished, we run=20 oncheck -cD <database> and we get the following messages on =certains=20 tables:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>TBLspace data check for=20 <database>:<table></FONT></DIV> <DIV><FONT face=3DArial size=3D2>WARNING: data page 0x1 in tablespace = 0x2c00004=20 appears to be</FONT></DIV> <DIV><FONT face=3DArial size=3D2>       =20             more or less = full than=20 is indicated in the bitmap.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>       =20         Bitmap mode: 0x4, Calculated mode: = 0xc</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Reset the bitmap mode for this = page?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This occurs on a lot of tables (dozens) = and is=20 annoying since we want to do automatic migrations without=20 intervention.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This is telling us that the value of = the bitmap=20 page for this data page is not in sync with the data page = fullness.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <DIV><FONT face=3DArial size=3D2>Any idea why this occurs and how to = solve this=20 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>khaled</FONT></DIV></DIV></BODY></HTML> ------=_NextPart_001_0782_01C57E40.92FF0380--

↪ replying to Khaled Bentebal

Andreas.KUTSCHE@spar.at — Mon, 04 Jul 2005 09:00:59 — source: IIUG Forums & Mailing Lists

Hi, did you run the oncheck -cD before the migration, too? Perhaps the errors were already hidden in your original database. If you want to be sure you could restore your old database (maybe to a different host) and run the oncheck -cD. Regards, Andreas Kutsche > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastrasse 3 A - 5015 Salzburg Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]Im > Auftrag von Khaled Bentebal > Gesendet: Freitag, 01. Juli 2005 13:35 > An: ids@iiug.org > Betreff: oncheck -cD: migration from 7.31 to 9.40 [5328] > > > Hi, > > We did a migration from IDS 7.31 to IDS 9.40 on IBM AIX by > installing = > the product on a different directory (no export and no import). > > All of the ALTER IN PLACEs have been resolved before > migration using a = > dummy update. > > After the migration has been accomplished, we run oncheck -cD > <database> = > and we get the following messages on certains tables: > > TBLspace data check for <database>:<table> > WARNING: data page 0x1 in tablespace 0x2c00004 appears to be > more or less full than is indicated in the bitmap. > Bitmap mode: 0x4, Calculated mode: 0xc > Reset the bitmap mode for this page? > > This occurs on a lot of tables (dozens) and is annoying since > we want to = > do automatic migrations without intervention. > > This is telling us that the value of the bitmap page for this > data page = > is not in sync with the data page fullness. > > Any idea why this occurs and how to solve this ? > > Thanks in advance > > khaled > ------=_NextPart_001_0782_01C57E40.92FF0380 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> > <META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>We did a migration from IDS > 7.31 to IDS = > 9.40 on IBM=20 > AIX by installing the product on a different directory (no > export and no = > > import).</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>All of the ALTER IN PLACEs > have been = > resolved=20 > before migration using a dummy update.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>After the migration has been = > accomplished, we run=20 > oncheck -cD <database> and we get the following messages on => certains=20 > tables:</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>TBLspace data check for=20 > <database>:<table></FONT></DIV> > <DIV><FONT face=3DArial size=3D2>WARNING: data page 0x1 in > tablespace = > 0x2c00004=20 > appears to be</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>    >    =20 >             more > or less = > full than=20 > is indicated in the bitmap.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>    >    =20 >         Bitmap mode: 0x4, > Calculated mode: = > > 0xc</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Reset the bitmap mode for this = > page?</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>This occurs on a lot of > tables (dozens) = > and is=20 > annoying since we want to do automatic migrations without=20 > intervention.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>This is telling us that the > value of = > the bitmap=20 > page for this data page is not in sync with the data page = > fullness.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV> > <DIV><FONT face=3DArial size=3D2>Any idea why this occurs and how to = > solve this=20 > ?</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial > size=3D2>khaled</FONT></DIV></DIV></BODY></HTML> > > ------=_NextPart_001_0782_01C57E40.92FF0380-- > > >

↪ replying to Khaled Bentebal

Khaled Bentebal — Mon, 04 Jul 2005 17:44:44 — source: IIUG Forums & Mailing Lists

Hi, The data has been checked before migration and is OK. Has anyone seen this kind of problem after migrating from 7.31 to 9.40 ? Thanks khaled ----- Original Message ----- From: "Andreas.KUTSCHE@spar.at" <andreas.kutsche@spar.at> To: <khaled.bentebal@consult-ix.fr>; <ids@iiug.org> Sent: Monday, July 04, 2005 10:54 AM Subject: AW: oncheck -cD: migration from 7.31 to 9.40 [5328] Hi, did you run the oncheck -cD before the migration, too? Perhaps the errors were already hidden in your original database. If you want to be sure you could restore your old database (maybe to a different host) and run the oncheck -cD. Regards, Andreas Kutsche > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastrasse 3 A - 5015 Salzburg Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]Im > Auftrag von Khaled Bentebal > Gesendet: Freitag, 01. Juli 2005 13:35 > An: ids@iiug.org > Betreff: oncheck -cD: migration from 7.31 to 9.40 [5328] > > > Hi, > > We did a migration from IDS 7.31 to IDS 9.40 on IBM AIX by > installing = > the product on a different directory (no export and no import). > > All of the ALTER IN PLACEs have been resolved before > migration using a = > dummy update. > > After the migration has been accomplished, we run oncheck -cD > <database> = > and we get the following messages on certains tables: > > TBLspace data check for <database>:<table> > WARNING: data page 0x1 in tablespace 0x2c00004 appears to be > more or less full than is indicated in the bitmap. > Bitmap mode: 0x4, Calculated mode: 0xc > Reset the bitmap mode for this page? > > This occurs on a lot of tables (dozens) and is annoying since > we want to = > do automatic migrations without intervention. > > This is telling us that the value of the bitmap page for this > data page = > is not in sync with the data page fullness. > > Any idea why this occurs and how to solve this ? > > Thanks in advance > > khaled > ------=_NextPart_001_0782_01C57E40.92FF0380 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> > <META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>We did a migration from IDS > 7.31 to IDS = > 9.40 on IBM=20 > AIX by installing the product on a different directory (no > export and no = > > import).</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>All of the ALTER IN PLACEs > have been = > resolved=20 > before migration using a dummy update.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>After the migration has been = > accomplished, we run=20 > oncheck -cD <database> and we get the following messages on => certains=20 > tables:</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>TBLspace data check for=20 > <database>:<table></FONT></DIV> > <DIV><FONT face=3DArial size=3D2>WARNING: data page 0x1 in > tablespace = > 0x2c00004=20 > appears to be</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>    >    =20 >             more > or less = > full than=20 > is indicated in the bitmap.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>    >    =20 >         Bitmap mode: 0x4, > Calculated mode: = > > 0xc</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Reset the bitmap mode for this = > page?</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>This occurs on a lot of > tables (dozens) = > and is=20 > annoying since we want to do automatic migrations without=20 > intervention.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>This is telling us that the > value of = > the bitmap=20 > page for this data page is not in sync with the data page = > fullness.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV> > <DIV><FONT face=3DArial size=3D2>Any idea why this occurs and how to = > solve this=20 > ?</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial > size=3D2>khaled</FONT></DIV></DIV></BODY></HTML> > > ------=_NextPart_001_0782_01C57E40.92FF0380-- > > >

Related threads

Glossary

IDS (Informix Dynamic Server)