Results 1 to 4 of 4

Thread: Import issue

  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: Import issue

    This may be a dumb AIX operating system question rather than DB2 question but I am hoping that someone may know the answer.

    I am trying to import data into a database using db2move (The database came from Windows and going into AIX) but running out of space on the hd1 disk where /home/db2inst1 is.

    When I try to increase the size of the volume through smitty, the number 512 is in bytes or kilobytes ?. Also, the other file sizes are displayed in bytes right ? Like the result of ls -al ?

    When I increased the volume size, do I need to reboot the machine ?

    Thanks for any help.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    space

    no reboot is needed - I think
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    how many records is in the data file? DB2move does not do COMMIT(amazing IBM hasn't gotten to it yet) So, if you have huge number of records you are running out of space. The only way to avvoid this is to doa regular IMPORT or LOAD and utilize savecount or commit what ever the case is.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Oct 2004
    Posts
    268
    I have increased the volume size and it has imported successfully..........


    Thanks.

Posting Permissions

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