Exemplos: descarregamento de dados a partir de um banco de dados Db2 Warehouse
Para esses dois exemplos a seguir, Optim™ High Performance Unload descarregará os dados de um banco de dados Db2® Warehouse. O nome do banco de dados é 'BLUDB', e a tabela envolvida nesta execução é ‘TABLE1’. O servidor Db2 Warehouse é ‘DB2WAREHOUSE_IP:50000’ onde DB2WAREHOUSE_IP é a url / hostname do servidor Db2 Warehouse , e 50000 é o número da porta associado ao serviço Db2 Warehouse .
Para a primeira execução, Optim High Performance Unload usará um arquivo de controle:
Relatório de execução:
[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.000000sSeção Credenciais Associadas do Db2 Warehouse para esta execução:
[DB2WAREHOUSE_SOURCE]
type=warehouse
user=user1
password=XXXXXXPara essa segunda execução, com base na mesma definição de credenciais de depósito, Optim High Performance Unload usará a especificação das opções de linha de comando --database e --table :
Relatório de execução:
[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