no space after delete?
Posted in 1994
Topics: Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Platform-Specific Issues
Hi,
thanks for your interest.
I have a problem with free table space after delete on my first INFORMIX-
project. I create many tables (also with indexes), then I store many, many
data. Whenever 90 % table space consumed, I will remove oldest data.
I remove with "delete from ... where ...;". The data was deleted, but no more
space was free!
The next test: I consumed all table space (see 0 free Chunks from tbstat -d)
and I can no more data stored. Now delete _all_ datas on all tables - now
space! I also remove indexes - without better result. When I remove one table
self, in that moment the space is free. I use ESQL/C, but I have equal result
with SQL-statements over isql command.
dbexport/dbimport is not good idea - too many data. I must remove oldest
data and then store new data. What can I do?
my configuration:
RS/6000 320 with AIX 3.2.5
INFORMIX Online 5.00
ESQL/C 5.00
Sorry for my english, when you can better answer in German - than do it.
Heiko :)
hlu@petnet.in-berlin.de
+49 30 5425978