예: Kerberos 인증 방법을 사용하는 MongoDB 대상으로의 데이터 마이그레이션
실행 보고서:
i1055@quickstart ~]$ db2hpu -i i1055 --debug -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.001(160126)
64 bits 01/29/2016 (Linux quickstart.cloudera 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 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 EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE;
000004 LOADDEST (NOSQL_DB MONGODB WITH KERBEROS AUTH)
000005 FORMAT JSON;
INZU462I HPU control step start: 01/29/2016 10:43:47.603.
INZU463I HPU control step end : 01/29/2016 10:43:48.027.
INZU464I HPU run step start : 01/29/2016 10:43:48.112.
INZU543I HPU utility will perform load operations on quickstart host.
INZU683I HPU utility has prepared 42 rows for an upload to the MONGODB destination.
INZU682I [quickstart] HPU utility has performed an upload to the MONGODB destination:
check its execution report in the /home/i1055/EMPLOYEE.msg file.
INZU465I HPU run step end : 01/29/2016 10:43:49.517.
INZI441I HPU successfully ended: Real time -> 0m1.914016s
User time -> 0m0.624904s : Parent -> 0m0.616906s, Children -> 0m0.007998s
Syst time -> 0m0.025995s : Parent -> 0m0.016997s, Children -> 0m0.008998s
db2hpu.dest 파일의 연관된 MongoDB 섹션:
[MongoDB]
url=http://www.mongodbserver.com
dbname=db1
collectionname=collection1
binpath=/tmp/mongodb/bin
host=quickstart
user=user@CLOUDERA
keytab=/tmp/user.keytab