Beispiel: Entladen von Daten im Parquet-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 PARQUET;
  
  
INZU462I HPU control step start: 09/18/2024 13:38:19.640.
INZU463I HPU control step end  : 09/18/2024 13:38:20.035.
INZU464I HPU run step start    : 09/18/2024 13:38: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:38: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

Auszug aus der generierten Parquet-Datei (parquet-tools ist ein CLI-Tool von Apache Arrow ):

i1156@lat111 ~]$ parquet-tools inspect outfile | head
    
############ file meta data ############
created_by: parquet-cpp-arrow version 6.0.1
num_columns: 14
num_rows: 42
num_row_groups: 1
format_version: 1.0
serialized_size: 2603