Example: Unload execution limited to the Db2 Load command generation

This example shows the report of an execution that is limited to the Db2 Load command generation. Optim™ High Performance Unload is run against a Db2 instance that has two logical database partitions on the same unique machine. The database partition numbers are 0 and 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 ".";