示例: 将数据迁移到指定了别名的 Db2 数据库

此示例说明通过使用 LOADDEST 子句和 db2hpu.dest 配置文件在同一本地 Db2® 数据库的两个表之间进行数据迁移。

执行报告:

[i1110@lat111 ~]$ db2hpu -i i1110 -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.003(190121) 
         64 bits 01/22/2019 (Linux lat111 3.10.0-862.14.4.el7.x86_64 #1 SMP Fri Sep 21 09:07:21 UTC 2018 x86_64) 
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment 
      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+ 
000001 GLOBAL CONNECT TO SAMPLE; 
000002 MIGRATE TABLESPACE 
000003 SELECT * FROM DEPARTMENT; 
000004 LOADDEST (DB2 "db2_alias_mig" WITH STANDARD AUTH) 
000005 INTO TABLE (DEPARTMENT_MIG) 
000006 FORMAT DEL; 

INZU462I HPU control step start: 01/22/2019 15:42:08.508. 
INZU463I HPU control step end  : 01/22/2019 15:42:08.903. 
INZU464I HPU run step start    : 01/22/2019 15:42:08.943. 
INZU543I HPU utility will perform load operations on lat111 host. 
INZU539I [lat111] HPU utility has performed load (INSERT mode) into 
         I1110.DEPARTMENT_MIG on database SAMPLE for instance i1110 : Report 
         in /home/i1110/I1110.DEPARTMENT_MIG.msg (Read 14, Skipped 0, 
         Loaded 14, Rejected 0, Deleted 0, Commited 14) 
INZU465I HPU run step end      : 01/22/2019 15:42:11.114. 
INZI441I HPU successfully ended: Real time -> 0m2.605305s 
User time -> 0m0.113125s : Parent -> 0m0.109602s, Children -> 0m0.003523s 
Syst time -> 0m0.040612s : Parent -> 0m0.029160s, Children -> 0m0.011452s

db2hpu.dest 配置文件中的关联 Db2 部分:

[Db2]
instance=i1110
alias=db2_alias_mig
dbname=SAMPLE
user=i1110
host=lat111