Exemplo: Migração de dados em direção a um destino PostgreSQL

[postgres@lat111 ~]$ db2hpu -i i1110 -f sysin 
INZM031I Optim High Performance Unload for Db2 06.05.00.001.04(210121) 
64 bits 01/25/2021 (Linux lat111 3.10.0-862.14.4.el7.x86_64 #1 SMP Fri Sep 21 09:07:21 UTC 2018 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 I1110.EMPLOYEE;
000004 INTO TABLE (public.EMPLOYEE_PG)
000005 LOADDEST(POSTGRESQL "POSTGRESQL_ALIAS" WITH STANDARD AUTH)
000006 FORMAT DEL;

INZU462I HPU control step start: 01/25/2021 13:43:26.631. 
INZU608I The OUTFILE clause is ignored when migrating data. 
INZU463I HPU control step end : 01/25/2021 13:43:26.973. 
INZU464I HPU run step start : 01/25/2021 13:43:27.048. 
INZU398I No unload to be done on lat111 
INZU543I HPU utility will perform load operations on lat109 host. 
INZM031I [lat109] Optim High Performance Unload for Db2 06.05.00.001.04(210121) 64 bits 
01/25/2021 (Linux lat109 3.10.0-514.el7.x86_64 #1 SMP Wed Oct 19 11:24:13 EDT 2016 x86_64) 
INZU683I [lat109] HPU utility has prepared 42 rows for an upload to the POSTGRESQL destination. 
INZU682I [lat109] HPU utility has performed an upload to the POSTGRESQL destination: 
check its execution report in the /home/postgres/EMPLOYEE_PG.msg file. 
INZU465I HPU run step end : 01/25/2021 13:43:28.181. 
INZI441I HPU successfully ended: Real time -> 0m1.549895s 
User time -> 0m0.100645s : Parent -> 0m0.100645s, Children -> 0m0.000000s 
Syst time -> 0m0.091495s : Parent -> 0m0.091495s, Children -> 0m0.000000s

[PostgreSQL] 
alias=POSTGRESQL_ALIAS
url=lat109 
dbname=DB_POSTGRE
host=lat109 
user=postgres

[POSTGRESQL_ALIAS] 
type=postgresql
password=FAE6B57CC297B86F268F651F0018393187F92C0B87573C6B6B3F3BCE2E098BDCD83F46B84008EC83...