示例:迁移执行仅限于 Db2 加载具有唯一数据文件的零件
此示例显示了限于自动迁移的 Db2 Load 端的执行报告,其中包含具有要装入的所有数据的唯一文件。 Optim™ High Performance Unload 是针对 Db2 实例运行的,该实例在同一台机器上有两个逻辑数据库分区。 数据库分区号为 0 和 1。 目标表位于同一数据库和 Db2 实例中,这不是此类场景所必需的。
注意: 要加载的文件在 Optim High Performance Unload 执行之前。 即使未按预期显示,此文件也不包含开头带有数据库分区映射的头。 对于此类场景,不需要头和数据库分区映射。
[i975@lat186(:) hm500_mnt]$ ls -al outfile
-rw-r--r-- 1 i975 db2grp 4888 Sep 12 19:23 outfile
[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/13/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----+
000001 GLOBAL CONNECT TO SAMPLE;
000002 MIGRATE TABLESPACE
000003 DB2 FORCE
000004 SELECT * FROM EMPLOYEE;
000005 TARGET KEYS (DEFAULT)
000006 TARGET ENVIRONMENT (INSTANCE "i975")
000007 OUTFILE("outfile")
000008 FORMAT DEL INTO EMP_TARGET
000009 ;
000010
INZU462I HPU control step start: 16:27:34.906.
INZU102I DB2 FORCE specified, will process through Db2.
INZU463I HPU control step end : 16:27:35.301.
INZU464I HPU run step start : 16:27:35.380.
INZU605I The execution is limited to the loading data-related processing.
INZU377I TARGET clause will be ignored (SELECT processed through Db2)
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_VINCE.msg (Read 42, Skipped 0, Loaded 42, Rejected 0,
Deleted 0, Commited 42)
INZU465I HPU run step end : 16:27:42.189.
INZI441I HPU successfully ended: Real time -> 0m7.283022s
User time -> 0m0.016997s : Parent -> 0m0.016997s, Children -> 0m0.000000s
Syst time -> 0m0.008998s : Parent -> 0m0.008998s, Children -> 0m0.000000s