Ejemplo: Migración de datos a un destino de Db2 Warehouse , basándose en el uso de la API de Db2 Load

Informe de ejecución:

[i1058@lat111 ~]$ db2hpu -i i1058 -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.001(170224) 
         64 bits 02/28/2017 (Linux lat111 3.10.0-327.36.1.el7.x86_64 #1 SMP Wed Aug 17 03:02:37 EDT 2016 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 MIGRATE TABLESPACE
000003 SELECT * FROM I1058.EMPLOYEE;
000004 INTO TABLE (MYUSER.EMPLOYEE)
000005 LOADDEST(DB2 WAREHOUSE "DB2WAREHOUSE_ALIAS" WITH STANDARD AUTH)
000006 FORMAT DEL;

INZU462I HPU control step start: 02/28/2017 14:21:15.640.
INZU463I HPU control step end  : 02/28/2017 14:21:15.809.
INZU464I HPU run step start    : 02/28/2017 14:21:15.879.
INZU543I HPU utility will perform load operations on lat111 host.
INZU738I [lat111] HPU utility has performed load (INSERT mode) into MYUSER.EMPLOYEE on database BLUDB :
         Report in MYUSER.EMPLOYEE.msg (Read 42, Skipped 0, Loaded 42, Rejected 0, Deleted 0, Commited 42)
INZU465I HPU run step end      : 02/28/2017 14:21:23.108.
INZI441I HPU successfully ended: Real time -> 0m7.467627s
User time -> 0m0.248599s : Parent -> 0m0.245368s, Children -> 0m0.003231s
Syst time -> 0m0.057349s : Parent -> 0m0.047654s, Children -> 0m0.009695s

Sección Db2® Warehouse asociada en el archivo db2hpu.dest :

[Warehouse]
user=bluadmin
dbname=BLUDB
url=DB2WAREHOUSE_IP
port=50000
alias=DB2WAREHOUSE_ALIAS

Credenciales de Db2 Warehouse asociadas en el archivo db2hpu.creds

[DB2WAREHOUSE_ALIAS]
type=warehouse
password=XXXXXX