互联网服务
db2move load为何越执行到后面就越慢？
最近给一客户做数据迁移，db2move load大概12000张表，db2版本为v9.7 fp6，这次迁移发现两个奇怪的问题：1.相同数据量在配置很低的测试环境load完需要6小时45分钟，而在配置更好的生产环境却花了7小时15分钟，配置更高的环境效率却更低；2.db2move load一开始执行很快，输出显示一张张表...显示全部
查看其它 8 个回答bigworld0128的回答
晕，按错键了，补充下db2diag.log中的内容：
(1) 下面红色字体表示上一个表load完马上就load下一个表：
-------------------------------------------------------------------------------------------------
2013-02-01-17.50.21.482451+480 I113603A533 LEVEL: Warning
PID : 12714226 TID : 19134 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 19134 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 106 bytes
LOADID: 3086.2013-02-01-17.50.21.312139.0 (2;30944)
Completed BUILD phase at 02/01/2013 17:50:21.478651.
2013-02-01-17.50.21.609544+480 I114137A468 LEVEL: Warning
PID : 12714226 TID : 3086 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 3086 EDUNAME: db2agent (QYNJ) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
DATA #1 :
Starting LOAD operation (S) (3) (I).
-------------------------------------------------------------------------------------------------
(2)到下面这个时间点，load完上一个表后5s才开始load下一个表：
-------------------------------------------------------------------------------------------------
2013-02-02-04.06.31.334540+480 I35195591A533 LEVEL: Warning
PID : 12714226 TID : 20254 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 20254 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 106 bytes
LOADID: 3086.2013-02-02-04.06.31.137332.0 (2;40676)
Completed BUILD phase at 02/02/2013 04:06:31.331093.
2013-02-02-04.06.36.833537+480 I35196125A468 LEVEL: Warning
PID : 12714226 TID : 3086 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 3086 EDUNAME: db2agent (QYNJ) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
DATA #1 :
Starting LOAD operation (S) (3) (I).
-------------------------------------------------------------------------------------------------
另外，补充下：表空间采用自动存储管理，JFS2文件系统，启用CIO
(1) 下面红色字体表示上一个表load完马上就load下一个表：
-------------------------------------------------------------------------------------------------
2013-02-01-17.50.21.482451+480 I113603A533 LEVEL: Warning
PID : 12714226 TID : 19134 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 19134 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 106 bytes
LOADID: 3086.2013-02-01-17.50.21.312139.0 (2;30944)
Completed BUILD phase at 02/01/2013 17:50:21.478651.
2013-02-01-17.50.21.609544+480 I114137A468 LEVEL: Warning
PID : 12714226 TID : 3086 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 3086 EDUNAME: db2agent (QYNJ) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
DATA #1 :
Starting LOAD operation (S) (3) (I).
-------------------------------------------------------------------------------------------------
(2)到下面这个时间点，load完上一个表后5s才开始load下一个表：
-------------------------------------------------------------------------------------------------
2013-02-02-04.06.31.334540+480 I35195591A533 LEVEL: Warning
PID : 12714226 TID : 20254 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 20254 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 106 bytes
LOADID: 3086.2013-02-02-04.06.31.137332.0 (2;40676)
Completed BUILD phase at 02/02/2013 04:06:31.331093.
2013-02-02-04.06.36.833537+480 I35196125A468 LEVEL: Warning
PID : 12714226 TID : 3086 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : QYNJ
APPHDL : 0-152 APPID: *LOCAL.db2inst1.130201095020
AUTHID : DB2INST1
EDUID : 3086 EDUNAME: db2agent (QYNJ) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
DATA #1 :
Starting LOAD operation (S) (3) (I).
-------------------------------------------------------------------------------------------------
另外，补充下：表空间采用自动存储管理，JFS2文件系统，启用CIO
浏览1135