Hello all!

I'm doing export/load of my db with db2move. (DB2 v8.1.5, AIX v5)

db2move finished with load but it didn't succeded for all tables. For few big tables I have message "The system is full". I'm tring to find out why this happens and I wanted to do db2move only for one table again to look what is going on with a system. (ulimit -a shows files-unlimited, large file system is enabled too, there is enough space as it looks now - it is filling temporary space that I have created and has 5 containers ... Maybe later about this.)

So I wanted to delete everything that has been loaded and start it again.
But table is in load pending state. I can't do "load...terminate" because I didn't start a single load command. What can I do instead of droppig a table? Can I somehow continue with load by db2move?


Thank you in advance,
NNicole

By the way, how big is your largest table and your temporary tablespace? Make sure you have enough free space with your temporary tablespace. I always setup 1.5 times temporary tablespace as the biggest table when I do export/load, or it will report "System Full".

All temp space is 2613492kB*5= 12GB. The biggest table is 24GB. OK...
Than I have to load it again...

Thank you... I'll report how it ended...

NNicole