DBSpace Full?
We are trying to insert data into a table and get the following error
WARNING: DBspace dldata1 is full
Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below)
informix@psdb03sat:~> onstat -d | grep 19
8e33ee80 19 0x40001 19 7 2048 N B informix dldata1
8e7cc028 19 19 67371008 5242880 -11853 PO-B- /IDS/data/lun1
8e7e5028 35 19 247452672 1048576 29060 PO-B- /IDS/data/lun1
8e7e59d8 40 19 252695552 2097152 106599 PO-B- /IDS/data/lun1
8e7cd5f8 46 19 265540608 2097152 25255 PO-B- /IDS/data/lun1
8e7e2218 52 19 278123520 1048576 731868 PO-B- /IDS/data/lun1
8e7e25f8 54 19 280220672 2097152 2095365 PO-B- /IDS/data/lun1
158615dd0 66 19 316396544 1048576 0 PO-B- /IDS/data/lun1
Has anyone ever seen this? Is there a way to make the engine see the 4GB chunk (#54) that is not used at all?
Any help is appreciated.
Laurie