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