Beispiel: Entladen von Daten im ORC-Ausgabeformat

Ausführungsbericht:

  [i1156@lat111 ~]$ db2hpu -f sysin
INZM031I Optim High Performance Unload for Db2 06.05.00.004.04(240918) 
         64 bits 09/18/2024 (Linux lat111 3.10.0-862.14.4.el7.x86_64 #1 x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile")
000005 LOADFILE("loadfile")
000006 FORMAT ORC;


INZU462I HPU control step start: 09/18/2024 14:37:19.640.
INZU463I HPU control step end  : 09/18/2024 14:37:20.035.
INZU464I HPU run step start    : 09/18/2024 14:37:20.612.
INZU410I HPU utility has unloaded 42 rows on lat111 host for I1156.EMPLOYEE in outfile.
INZU465I HPU run step end      : 09/18/2024 13:37:21.065.
INZI441I HPU successfully ended: Real time -> 0m1.424924s
User time -> 0m0.673680s : Parent -> 0m0.082336s, Children -> 0m0.591344s
Syst time -> 0m0.524877s : Parent -> 0m0.042197s, Children -> 0m0.482680s