Space allocation

Posted in 2008

mohitanchlia@gmail.com — Thu, 24 Jan 2008 13:17:37 -0800 (PST) — source: Usenet: comp.databases.informix

Version IDS 10: Table that has a dedicated dbspace got 100% full. Then I started the delete process and since than it has deleted around 2.5 M rows, still when I run oncheck or query against sysptnhdr it keeps showing 0 pages free. Is there a delay before Informix will release the space and show it as free space. Why don't I see "Number of pages used" in oncheck going down. I know I have already deleted lot of data.