Esempio: migrazione dei dati

I dettagli di configurazione sono identici a quelli nell'esempio per la generazione di un comando di caricamento Db2 con un passo di connessione.

Questo esempio illustra la migrazione dei dati da una tabella TBL_SOURCE (che si trova nel database LOCALDB) verso una tabella TBL_TARGET (che si trova su una macchina remota nel database REMOTEDB, quest' ultima catalogata localmente):

[i1058@lat111 ~]$ db2hpu -i i1058 -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.001(161019) 
         64 bits 10/20/2016 (Linux lat111 3.10.0-123.el7.x86_64 #1 SMP Mon May 5 11:16:57 EDT 2014 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 LOCALDB;
000002 MIGRATE TABLESPACE
000003 SELECT * FROM TBL_SOURCE;
000004 LOADDEST(DB2 REMOTE “NODERMT”)
000005 INTO TABLE (I1058.TBL_TARGET)
000006 FORMAT DEL;

INZU462I HPU control step start: 10/20/2016 09:48:24.438.
INZU463I HPU control step end  : 10/20/2016 09:48:24.615.
INZU464I HPU run step start    : 10/20/2016 09:48:24.674.
INZU543I HPU utility will perform load operations on lat111 host.
INZU539I [lat111] HPU utility has performed load (INSERT mode) into I1058.TBL_TARGET on database REMOTEDB 
for instance i1058 : Report in /home/i1058/I1058.TBL_TARGET.msg (Read 2, Skipped 0, Loaded 2, Rejected 0, Deleted 0, Commited 2)
INZU465I HPU run step end      : 10/20/2016 09:48:27.366.
INZI441I HPU successfully ended: Real time -> 0m2.928060s
User time -> 0m0.257479s : Parent -> 0m0.245809s, Children -> 0m0.011670s
Syst time -> 0m0.058804s : Parent -> 0m0.051802s, Children -> 0m0.007002s