Esempio: migrazione dei dati verso una destinazione Amazon EC2

Report di esecuzione

[i1110@pc-l-0037 ~]$ db2hpu -i i1110 -f sysin_aws_ec2
INZM031I Optim High Performance Unload for Db2 06.05.00.002.05(220518) 
         64 bits 05/18/2022 (Linux pc-l-0037 5.3.18-59.10-preempt #1 SMP PREEMPT Fri Jun 25 12:36:56 UTC 2021 (6856d31) 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 employee;
000004 LOADDEST(OBJECT_STORAGE AWS_EC2 "aws_ec2_alias")
000005 OUTFILE("outfile")
000006 FORMAT DEL;

INZU462I HPU control step start: 05/18/2022 11:20:21.054.
INZU463I HPU control step end  : 05/18/2022 11:20:21.130.
INZU464I HPU run step start    : 05/18/2022 11:20:21.471.
INZU543I HPU utility will perform load operations on pc-l-0037 host.
INZU683I HPU utility has prepared 42 rows for an upload to the AMAZON EC2 destination.
INZU741I [pc-l-0037] HPU utility has performed an upload of the outfile file to the AMAZON EC2 destination at the location configured: 
         check its execution report in the /home/i1110/EMPLOYEE.msg file.
INZU465I HPU run step end      : 05/18/2022 11:20:22.015.
INZI441I HPU successfully ended: Real time -> 0m0.960467s
User time -> 0m0.047419s : Parent -> 0m0.047419s, Children -> 0m0.000000s
Syst time -> 0m0.012932s : Parent -> 0m0.012932s, Children -> 0m0.000000s

[AWS_EC2]
alias=aws_ec2_alias
privatekey=/home/i1110/ec2_private_key.pem
user=ec2-user
url=ec2-public-url
path=/home/ec2-user/HPU_UNLOADS/