Unanswered: db2move <----> how to solve load pending
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?
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".