Example: Data migration towards an HDFS destination, with a Kerberos authentication method
Execution report:
i1055@quickstart ~]$ db2hpu -i i1055 --debug -f sysin_mig2
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 (HADOOP HDFS WITH KERBEROS AUTH)
000005 OUTFILE("outfile")
000006 FORMAT XML;
INZU462I HPU control step start: 01/29/2016 11:39:11.408.
INZU463I HPU control step end : 01/29/2016 11:39:11.531.
INZU464I HPU run step start : 01/29/2016 11:39:11.583.
INZU543I HPU utility will perform load operations on quickstart host.
INZU683I HPU utility has prepared 42 rows for an upload to the HDFS destination.
INZU741I [quickstart] HPU utility has performed an upload of the outfile file to the HDFS destination
at the location configured: check its execution report in the /home/i1055/EMPLOYEE.msg file.
INZU465I HPU run step end : 01/29/2016 11:39:15.611.
INZI441I HPU successfully ended: Real time -> 0m4.202922s
User time -> 0m0.635902s : Parent -> 0m0.634903s, Children -> 0m0.000999s
Syst time -> 0m0.029994s : Parent -> 0m0.020996s, Children -> 0m0.008998s
Associated HDFS section in the db2hpu.dest file:
[HDFS]
hdfspath=/tmp
host=quickstart
user=foo/quickstart.cloudera@CLOUDERA
keytab=/tmp/foo.keytab