Can data pages in IDS act like a torn page in SQL server
Posted in 2004
Konikoff, Rob (Contractor) — — source: IIUG Forums & Mailing Lists
Me: INFORMIX-OnLine Version 7.23.UC11 OS: HP-UX 11 One of our MS-SQL server guys came over and explained that he experiences "torn pages" where a corrupt data element leaves a partially filled page and skips to another page. All of his stuff lives in the lofty towers of cooked space. As such, he indicated a steep overhead price for self maintenance and space recovery. I'm a functional analyst, not the DBA, so I'm not even sure if I'm asking this right, but here goes: Since INFORMIX manages the disk space directly (forever raw!), if we only have a partial page fill and it skips to the next extent, shouldn't INFORMIX reclaim that space with the integrity checks and whatnot? Rob