Accelerate export database

Dolphon · #1 (**permalink**) 11-26-10, 05:09

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

nvk@vhv · #2 (**permalink**) 11-26-10, 05:40

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech