bad page

Posted in 2006

Topics: Migration, Import/Export & Data Conversion

Danny De Koster — Mon, 17 Apr 2006 20:24:55 +0200 — source: Usenet: comp.databases.informix

Hi all, I can't unload a certain table. Doing an oncheck -cDI database:table, the system gives a bad page error. How can I resolve this or where can I find information on this topic. thanks, Danny

↪ replying to Danny De Koster

TBP — Mon, 17 Apr 2006 18:47:25 GMT — source: Usenet: comp.databases.informix

Danny De Koster wrote: > Hi all, > > I can't unload a certain table. Doing an oncheck -cDI database:table, the > system gives a bad page error. > How can I resolve this or where can I find information on this topic. > > thanks, > Danny > > Version of IDS? O/S? Well, sounds like you have a "bad page". Is it a data page or an index page? Does oncheck -cD database:table show an error? If not, then you have a bad index page, and the oncheck -cDI should have told you which index was bad, then you can just drop and re-create the index. If oncheck -cD database:table does show an error, then you have a bad data page :( You should receive various bits of information when the engine encounters a bad page; What does the online.log show? Is an af file produced? You would need to unload around the bad data page. Not at work, so can't easily give you an example (amazingly nothing on google either, or of the IBM search support site)

↪ replying to TBP

Danny De Koster — Mon, 17 Apr 2006 21:49:06 +0200 — source: Usenet: comp.databases.informix

Version 7.30 Linux SuSe. How to get around of the bad table? Yes I get the error doing oncheck -cD database:table "TBP" <TheBigPotato@NotHere.Co.Uk> schreef in bericht news:1pR0g.27130$zf1.12793@newsfe5-gui.ntli.net... > Danny De Koster wrote: >> Hi all, >> >> I can't unload a certain table. Doing an oncheck -cDI database:table, the >> system gives a bad page error. >> How can I resolve this or where can I find information on this topic. >> >> thanks, >> Danny >> >> > Version of IDS? > O/S? > > Well, sounds like you have a "bad page". > > Is it a data page or an index page? > > Does oncheck -cD database:table show an error? > If not, then you have a bad index page, and the oncheck -cDI should have > told you which index was bad, then you can just drop and re-create the > index. > > If oncheck -cD database:table does show an error, then you have a bad data > page :( > You should receive various bits of information when the engine encounters > a bad page; > > What does the online.log show? > Is an af file produced? > > You would need to unload around the bad data page. > > Not at work, so can't easily give you an example (amazingly nothing on > google either, or of the IBM search support site)

↪ replying to TBP

bozon — 17 Apr 2006 12:58:21 -0700 — source: Usenet: comp.databases.informix

Danny De Koster wrote: >You would need to unload around the bad data page. Unload to good.out select rowid from <table>; If this errors the last rowid in the table should be your last good before the bad page. then try to select rowid > than this until you get to the max rowid or you don't have any errors. This will be the first good rowid after the bad page. Then unload the records with the following unload to good_recs.out select * from <table> where rowid not between<first_bad_page> and <last_bad_page> ; You have all of the data that you can get without doing a restore before the page was corrupted and rolling the logs.

↪ replying to Danny De Koster

david@smooth1.co.uk — 17 Apr 2006 13:50:03 -0700 — source: Usenet: comp.databases.informix

"How to get around of the bad table? " Restore from a backup or Get IBM to dial in and fix it.