Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jack A — — source: Usenet: comp.databases.informix
Hi,
I'm using IDS 2000 9.21 UC5 on Sun Solaris. We have 5 chunks in
each instance. I am trying to ensure that the database does not run out of
room and I am deleting historical data from the tables. However, the output
of onstat -d does not seem to reflect this. The free space in the data
chunks does not seem to grow.
Here is the output
Chunks
address chk/dbs offset size free bpages flags pathname
cf0b918 1 1 0 64000 36484 PO-
/opt/ids2k/db_spaces/root_chk1
cf4a9b0 2 2 0 32768 1995 PO-
/opt/ids2k/db_spaces/logs_chk1
cf4ab20 3 3 0 512000 511947 PO-
/opt/ids2k/db_spaces/temp_chk1
cf4ac90 4 4 0 768000 587270 PO-
/opt/ids2k/db_spaces/indx_chk1
cf4ae00 5 5 0 1023000 4 PO-
/opt/ids2k/db_spaces/ data_chk1
cf0ba88 6 5 0 512000 257259 PO-
/opt/ids2k/db_spaces/ data_chk2
6 active, 2047 maximum
What else do I need to do to ensure that the deletion is effective and the
tables have room to grow? I absolutely do not want to add another chunk but
I want to delete old data and free space in the existing chunks.
Thanks in advance,
Jack
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.