Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    57

    Unanswered: db2move <----> how to solve load pending

    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

  2. #2
    Join Date
    May 2003
    Location
    Toronto
    Posts
    29
    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".

  3. #3
    Join Date
    May 2003
    Posts
    57
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •