Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Unanswered: Accelerate export database

    Hi,

    the current DB2 database is approximately 120GB in size.
    Exporting the entire database takes about 5 hours.
    The database is exported by using the following command:

    Code:
    db2 -t -v -f "export".sql
    Code:
    export.sql
    EXPORT TO "e:\winprod\tabelle1.ixf" of ixf LOBS TO "e:\winprod\" MODIFIED BY LOBSINFILE MESSAGES "e:\winprodlog\tabelle1.log" SELECT * FROM DB2.tabelle1;
    EXPORT TO "e:\winprod\tabelle2.ixf" of ixf LOBS TO "e:\winprod\" MODIFIED BY LOBSINFILE MESSAGES "e:\winprodlog\tabelle2.log" SELECT * FROM DB2.tabelle2;
    ........
    Is it possible to accelerate the export procedure, for example by a different export format or other parameters?

    Greetz

    Dolphon

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    there are no Parameters to speed up a single Export. If your system is not at the IO-Capacity-Limits during the Export, you could run several exports in parallel. This should speed it up.

Posting Permissions

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