例: cURL ツール使用に基づいた Amazon S3 宛先へのデータ・マイグレーション
この例では Optim™ High Performance Unload は、 Amazon S3 宛先にデータを移行します。 cURL ツールの使用法に基づき、署名のバージョンは 2 です。
実行レポート:
[i1058@lat111 ~]$ db2hpu -i i1058 -f sysin
INZM031I Optim High Performance Unload for Db2 06.01.00.001(180124)
64 bits 01/24/2018 (Linux 3.10.0-327.36.1.el7.x86_64 #1 SMP Wed Aug 17 03:02:37 EDT 2016 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 MIGRATE TABLESPACE
000004 LOCK NO QUIESCE NO
000005
000006 SELECT * FROM EMPLOYEE;
000007 LOADDEST(OBJECT_STORAGE AWS_S3 "s3_v2_alias")
000008 OUTFILE("outfile")
000009
000010 FORMAT DEL;
INZU462I HPU control step start: 01/24/2018 16:11:35.368.
INZU463I HPU control step end : 01/24/2018 16:11:35.449.
INZU464I HPU run step start : 01/24/2018 16:11:35.450.
INZU543I HPU utility will perform load operations on lat111 host.
INZU683I HPU utility has prepared 42 rows for an upload to the AMAZON S3 destination.
INZU741I [lat111] HPU utility has performed an upload of the outfile file to the AMAZON S3 destination
at the location configured: check its execution report in the /home/i1058/EMPLOYEE.msg file.
INZU465I HPU run step end : 01/24/2018 16:11:36.104.
INZI441I HPU successfully ended: Real time -> 0m0.735456s
User time -> 0m0.107572s : Parent -> 0m0.107572s, Children -> 0m0.000000s
Syst time -> 0m0.015665s : Parent -> 0m0.015665s, Children -> 0m0.000000s
db2hpu.dest ファイル内の関連 Amazon S3 セクション:
[AWS_S3]
alias=s3_v2_alias
bucket=dev-hpum-test
host=lat111
relativepath=folder1
curl=yes
accesskey=ACCESKEY_5YU2XNMDHQA
version=2
region=eu-west-1db2hpu.creds ファイルに関連付けられた Amazon S3 の認証情報：
[s3_v2_alias]
type=aws_s3
password=FAE6B57CC297B86F268F651F0018393187F92C0B87573C6B6B3F3BCE2E098BDCD83F46B84008EC83...