예: cURL 도구 사용을 기반으로 Azure 대상에 대한 BLOB 업로드 명령을 생성하는 데이터 언로드

실행 보고서:

[i1156@lat111 ~]$ db2hpu -i i1156 -f sysin_azure
INZM031I Optim High Performance Unload for Db2 06.05.00.003.01(230710) 
64 bits 07/10/2023 (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
000003 UNLOAD TABLESPACE
000004
000005 SELECT * FROM EMPLOYEE;
000006
000007 OUTFILE("outfile")
000008 LOADFILE("loadfile")
000009 LOADDEST("OBJECT_STORAGE AZURE "AZURE_CURL_ALIAS")
000010
000011 FORMAT DEL;
INZU462I HPU control step start: 07/10/2023 13:27:28.925.
INZU463I HPU control step end  : 07/10/2023 13:27:29.264.
INZU464I HPU run step start    : 07/10/2023 13:27:29.879.
INZU410I HPU utility has unloaded 42 rows on lat111 host for I1156.EMPLOYEE in outfile.
INZU684I HPU utility has generated an upload command for the AZURE destination in the loadfile file.
INZU465I HPU run step end      : 07/10/2023 13:27:29.888.
INZI441I HPU successfully ended: Real time -> 0m0.962261s
User time -> 0m0.074943s : Parent -> 0m0.074943s, Children -> 0m0.000000s
Syst time -> 0m0.037471s : Parent -> 0m0.037471s, Children -> 0m0.000000s

db2hpu.dest 파일의 연관된 Azure 섹션:

[Azure]
alias=AZURE_CURL_ALIAS
account=my_azure_account
curl=yes
sastoken=sv=my_sas_token

생성된 출력 파일에서 발췌한 내용:

[i1156@lat111 ~]$ cat outfile
"000010","CHRISTINE","I","HAAS","A00","3978",19950101,"PRES ",18,"F",19630824,+0152750.00,+0001000.00,+0004220.00
...
"200340","ROY","R","ALONZO","E21","5698",19970705,"FIELDREP",16,"M",19560517,+0031840.00,+0000500.00,+0001907.00

생성된 업로드 명령:

[i1156@lat111 ~]$ cat loadfile
#!/bin/sh

echo Start uploading ...
curl --write-out "%{http_code}" -X PUT -H "x-ms-version: 2023-01-03" -H "x-ms-blob-type: BlockBlob" 
     -H "Content-Type: text/plain; charset=UTF-8" -H "x-ms-content-length: 4888" -T "outfile" 
     "https://my_azure_account.blob.core.windows.net/container1/outfile?my_sas_token" -o "EMPLOYEE.msg" 
     > "EMPLOYEE.msg.http" 2> "EMPLOYEE.msg.err"
RC=$?
if [ $RC -eq 0 ]
then
    RC=$(cat "EMPLOYEE.msg.http")
    if [ $RC -ge 300 -o $RC -lt 100 ]
    then
        RC=1
    else
        RC=0
        rm -f "EMPLOYEE.msg.err"
    fi
else
    RC=1
fi
rm -f "EMPLOYEE.msg.http" >/dev/null 2>&1
if [ $RC -ne 0 ]
then
    echo "An error occurred while processing the 'outfile' file. The 'EMPLOYEE.msg' and 'EMPLOYEE.msg.err' files 
          contain the associated execution reports."
else
    echo "The 'outfile' file has been processed successfully. The 'EMPLOYEE.msg' file contains the associated execution report."
fi
exit $RC