示例:迁移执行仅限于 Db2 加载已分发数据的部分
此示例显示了限于自动迁移的 Db2 Load 端的执行报告,其中包含已为目标分发数据的文件。 Optim™ High Performance Unload 是针对 Db2 实例运行的,该实例在同一台机器上有两个逻辑数据库分区。 数据库分区号为 0 和 1。 目标表位于同一数据库和 Db2 实例中,这不是此类场景所必需的。
注意: 要加载的文件在 Optim High Performance Unload 执行之前,其名称适合 Db2 加载步骤,该步骤针对已分发的流运行。 即使未按预期显示,这些文件也会在开头包含带有分区映射的头。 对于此类场景,头和映射是必需的。
[i975@lat186(:) hm500_mnt]$ ls -al outfile.00*
-rw-r--r-- 1 i975 db2grp 10422 Sep 12 19:06 outfile.000
-rw-r--r-- 1 i975 db2grp 11354 Sep 12 19:06 outfile.001
[i975@lat186(:) hm500_mnt]$ db2hpu -f SYSIN -i i975 --load-only
INZM031I Optim High Performance Unload for Db2 06.01.00.001(120912) 64 bits 09/12/2012 (Linux lat186 x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----10---+----11---+----12---+----13-
000001 GLOBAL CONNECT TO SAMPLE;
000002 MIGRATE TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 TARGET KEYS (DEFAULT)
000005 TARGET ENVIRONMENT (INSTANCE "i975")
000006 OUTFILE("outfile")
000007 FORMAT DEL INTO EMP_TARGET
000008 ;
000009
INZU462I HPU control step start: 19:07:40.382.
INZU463I HPU control step end : 19:07:40.771.
INZU464I HPU run step start : 19:07:40.797.
INZU605I The execution is limited to the loading data-related processing.
INZU543I HPU utility will perform load operations on lat186 host.
INZU539I [lat186] HPU utility has performed load (INSERT mode) into I975.EMP_TARGET on database SAMPLE for instance i975 :
Report in /home/i975/labo/hm500_mnt/I975.EMP_TARGET.msg (Read 42, Skipped 0, Loaded 42, Rejected 0, Deleted 0, Commited 42)
INZU465I HPU run step end : 19:07:47.934.
INZI441I HPU successfully ended: Real time -> 0m7.551867s
User time -> 0m0.016997s : Parent -> 0m0.016997s, Children -> 0m0.000000s
Syst time -> 0m0.008998s : Parent -> 0m0.008998s, Children -> 0m0.000000s