您的位置：程序门 -> db2 -> 数据管理

如何实现oracle向db2数据库的大数据量迁移！

[收藏此页] [打印本页]选择字色：背景色：字体：[大][中][小]

如何实现oracle向db2数据库的大数据量迁移！

发表于：2007-12-12 21:31:14 楼主

要实现从oracle数据库向db2数据库的大数据量数据迁移，数据量2~5亿条，谁知道用什么方法能在10小时内实现数据的全部迁移，或者迁移速度能达到1万/秒也可以！

发表于：2007-12-14 21:42:461楼得分:0

已获得专家建议：
1. tune your db2 server
powerfull hardware is the simplest way to level up the performance. and try to tune your db2 server configuration. a fine tuned db2 server can achieve high throughput.

2. using db2 utility load. （best recommended)
the load utility writes formatted pages directly into the database. you can turn off index statistic and constraint check, can utilize internal parallelism. etc..
so using load will much faster than using sql insert. about how to use load, you can check db2 command reference.

3. using static sql application
use sqlj or other programming language to write a store procedure. bind the plan and package. just pass the variable to sp.

4. using jdbc.
a question, is your java app using one thread per connection to insert into db2 table or all those threads share the same jdbc connection?
if one thread per connection. you'll encounter the lock escalation on table if you don't issue the connection.commit（) after ＥＸＥＣutebatch（). other threads will be lock-wait.
try to issue the sql command " set current degree = 'any' " and " set current isolation= ur " in the jdbc connection before you insert data.

其他资讯