예: cURL 도구 사용을 기반으로 하는 Db2 Warehouse 대상으로의 데이터 마이그레이션

실행 보고서:

[i1058@lat111 ~]$ db2hpu -i i1058 -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.001(170224) 
         64 bits 03/01/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: 03/01/2017 11:47:28.502.
INZU463I HPU control step end  : 03/01/2017 11:47:28.749.
INZU464I HPU run step start    : 03/01/2017 11:47:28.816.
INZU543I HPU utility will perform load operations on lat111 host.
INZU683I HPU utility has prepared 42 rows for an upload to the DB2 WAREHOUSE destination.
INZU682I [lat111] HPU utility has performed an upload to the DB2 WAREHOUSE destination: check its execution report in the MYUSER.EMPLOYEE.msg file.
INZU465I HPU run step end      : 03/01/2017 11:47:30.725.
INZI441I HPU successfully ended: Real time -> 0m2.222860s
User time -> 0m0.235410s : Parent -> 0m0.230205s, Children -> 0m0.005205s
Syst time -> 0m0.055166s : Parent -> 0m0.046838s, Children -> 0m0.008328s

db2hpu.dest 파일의 연관된 Db2® Warehouse 섹션:

[Warehouse]
user=bluadmin
curl=yes
url=https://DB2WAREHOUSE_IP:8443/dashdb-api/load/local/del
alias=DB2WAREHOUSE_ALIAS

db2hpu.creds 파일의 연관된 Db2 Warehouse 신임 정보

[DB2WAREHOUSE_ALIAS]
type=warehouse
password=XXXXXX