例： Db2 ロードコマンド生成に限定したアンロード実行

この例では、Db2 Load コマンド生成に限定された実行のレポートを示します。 Optim™ High Performance Unload は、同じ一意のマシン上に2つの論理データベース・パーティションを持つ Db2 インスタンスに対して実行される。データベース・パーティション番号は 0 と 1 です。

[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----+
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile.%{source_node}")
000005 LOADFILE("loadfile")
000006 FORMAT DEL INTO EMP_TARGET
000007 ;

INZU462I HPU control step start: 18:50:07.380.
INZU463I HPU control step end  : 18:50:07.643.
INZU464I HPU run step start    : 18:50:07.737.
INZU605I The execution is limited to the loading data-related processing.
INZU606I HPU utility would have generated the outfile.000 file on lat186 host for I975.EMPLOYEE.
INZU606I HPU utility would have generated the outfile.001 file on lat186 host for I975.EMPLOYEE.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 18:50:07.739.
INZI441I HPU successfully ended: Real time -> 0m0.358732s
User time -> 0m0.014997s : Parent -> 0m0.014997s, Children -> 0m0.000000s
Syst time -> 0m0.006998s : Parent -> 0m0.006998s, Children -> 0m0.000000s

[i975@lat186(:) hm500_mnt]$ cat loadfile
LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
INSERT INTO "I975"."EMP_TARGET" ("EMPNO","FIRSTNME","MIDINIT","LASTNAME","WORKDEPT","PHONENO","HIREDATE",
                                 "JOB","EDLEVEL","SEX","BIRTHDATE","SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE LOAD_ONLY_VERIFY_PART PART_FILE_LOCATION ".";