Esempio: migrazione dei dati verso una destinazione di tipo " IBM Cloud Object Storage ", basata sull'utilizzo dello strumento " cURL

Rapporto di esecuzione:

[i1110@lat111 ~]$ db2hpu -i i1110 -f SYSIN
INZM031I Optim High Performance Unload for Db2 06.05.00.004.02(240430) 
         64 bits 05/03/2024 (Linux lat111.labo.infotel.com 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 employee;
000004 LOADDEST(OBJECT_STORAGE IBM_COS "ibm_cos_curl")
000005 OUTFILE("outfile")
000007 FORMAT DEL;
      
INZU462I HPU control step start: 05/03/2024 15:58:07.723.
INZU463I HPU control step end  : 05/03/2024 15:58:07.794.
INZU464I HPU run step start    : 05/03/2024 15:58:07.828.
INZU543I HPU utility will perform load operations on lat111 host.
INZU683I HPU utility has prepared 42 rows for an upload to the IBM COS destination.
INZU741I [lat111] HPU utility has performed an upload of the outfile file to the IBM COS destination at the location configured: 
         check its execution report in the /home/i1110/EMPLOYEE.msg file.
INZU465I HPU run step end      : 05/03/2024 15:58:08.785.
INZI441I HPU successfully ended: Real time -> 0m1.061958s
User time -> 0m0.109047s : Parent -> 0m0.102977s, Children -> 0m0.006070s
Syst time -> 0m0.035914s : Parent -> 0m0.028833s, Children -> 0m0.007081s

IBM e associata Sezione COS nel file db2hpu.dest :

[IBM_COS]
alias=ibm_cos_curl
curl=yes
bucket=coshpum
accesskey=MYACCESSKEY
region=eu-de
url=https://s3.eu-de.cloud-object-storage.appdomain.cloud

IBM e associato Credenziali COS nel file " db2hpu.creds ":

[ibm_cos_curl]
type=ibm_cos
password=9DB1A0470228A4AE9F6895A5B3EA768347FD36BB64FE5FD9CDD9FBC6C1642AC6AC0F8AEC6A4434B3...