示例: 从 Db2 Warehouse 数据库卸载数据
对于下面这两个示例、 Optim™ High Performance Unload 将从 Db2® Warehouse 数据库中卸载数据。 数据库名称为 "BLUDB" ，此执行中涉及的表为 ‘TABLE1’。 Db2 Warehouse 服务器是 ‘DB2WAREHOUSE_IP:50000’ ，其中 DB2WAREHOUSE_IP 是 Db2 Warehouse 服务器的 URL/主机名， 50000 是与 Db2 Warehouse 服务关联的端口号。
对于第一次执行， Optim High Performance Unload 将使用一个控制文件：
执行报告:
[i1058@lat111 ~]$ db2hpu -i i1058 -f sysin --warehouse DB2WAREHOUSE_SOURCE
INZM031I Optim High Performance Unload for Db2 06.01.00.001(170424)
64 bits 04/24/2017 (Linux lat111 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 BLUDB URL "DB2WAREHOUSE_IP" PORT "50000" ;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM TABLE1;
000004 OUTFILE("outfile")
000005 FORMAT DELIMITED;
INZU462I HPU control step start: 04/24/2017 11:56:18.124.
INZU102I DB2 FORCE specified, will process through DB2.
INZU463I HPU control step end : 04/24/2017 11:56:18.179.
INZU464I HPU run step start : 04/24/2017 11:56:18.180.
INZU410I HPU utility has unloaded 6 rows on lat111 host for USER1.TABLE1 in outfile.
INZU465I HPU run step end : 04/24/2017 11:56:18.454.
INZI441I HPU successfully ended: Real time -> 0m0.330399s
User time -> 0m0.245847s : Parent -> 0m0.245847s, Children -> 0m0.000000s
Syst time -> 0m0.049574s : Parent -> 0m0.049574s, Children -> 0m0.000000s此执行的关联 Db2 Warehouse 凭证部分:
[DB2WAREHOUSE_SOURCE]
type=warehouse
user=user1
password=XXXXXX对于第二次执行，基于相同的仓库凭证定义， Optim High Performance Unload 将使用 --database 和 --table 命令行选项的规范：
执行报告:
[i1058@lat111 ~]$ db2hpu -i i1058 --database BLUDB:DB2WAREHOUSE_IP:50000 --table TABLE1 --warehouse DB2WAREHOUSE_SOURCE --output outfile
INZM031I Optim High Performance Unload for Db2 06.01.00.001(170426)
64 bits 04/26/2017 (Linux lat111 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 BLUDB URL "DB2WAREHOUSE_IP" PORT "50000";
000002 UNLOAD TABLESPACE
000003 PART(ALL)
000004 DB2 FORCE
000005 SELECT * FROM "TABLE1";
000006 OUTFILE("outfile")
000007 ;
INZU462I HPU control step start: 04/26/2017 15:56:38.783.
INZU102I DB2 FORCE specified, will process through DB2.
INZU463I HPU control step end : 04/26/2017 15:56:38.910.
INZU464I HPU run step start : 04/26/2017 15:56:38.913.
INZU410I HPU utility has unloaded 6 rows on lat111 host for USER1.TABLE1 in outfile.
INZU465I HPU run step end : 04/26/2017 15:56:39.743.
INZI441I HPU successfully ended: Real time -> 0m0.959734s
User time -> 0m0.253916s : Parent -> 0m0.253916s, Children -> 0m0.000000s
Syst time -> 0m0.047984s : Parent -> 0m0.047984s, Children -> 0m0.000000s