Beispiel: Ausführung der Entladung auf die Generierung des Ladebefehls Db2 beschränkt

Das vorliegende Beispiel zeigt den Bericht einer Ausführung, die auf die Generierung des Db2-Ladebefehls beschränkt ist. Optim™ High Performance Unload wird gegen eine Instanz von Db2 ausgeführt, die zwei logische Datenbankpartitionen auf demselben Rechner hat. Die Datenbankpartitionsnummern lauten 0 und 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 ".";