Posted in 2004
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
We use strictly necessary cookies to make this site work. With your consent we’d also use optional cookies for analytics and marketing. You can accept all, reject all, or choose. Read our Cookie Policy.