we had this problem several times during the import of several databases while unicode migrations, 'normal' migrations etc.
During the load/import of the database the size increases more and more, sometimes the DB runs full and stands still.
After adding volumes, it takes some time, the loading continues, and than all of the sudden, the database size is back to normal, which can be half the size as some moments before. The new size fits to the size before the export.
We use MAX Db 7.7 (dif. releases) on AIX 6.1 .
It is not reproducebable, we decreased the size of processes, it happens, we increase them, it doesn't happen.
It's not an problem during index creation as they are not created at that moment.
So why does it get so big?
Edited by: Jan Lars Goedtke on Jun 22, 2010 2:03 PM