Entwicklung von hochperformanten Anwendungen mit Database Gateways

54 Pages·2013·0.92 MB·German

<Insert Picture Here>
Entwicklung von hochperformanten Anwendungen mit
Database Gateways
Thomas Niewel
Leitender Systemberater
1 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Agenda
Architektur
Funktionsweise von Database Gateways –
Unterstützung verschiedenster SQL Dialekte
Performance Aspekte
Zugriff auf Fremdsysteme am Beispiel DB2 for
z/OS (Database Gateway for DRDA)
Optimierung von Load Prozessen
Weiteres
2 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Architektur
Database Gateways
• Informationen
• http://www.oracle.com/technetwork/database/gateways/index.html
• Empfehlung: Version >= 11.2.03
Client
DDaattaabbaassee NNoonn OOrraaccllee
Gateway
Database
Installation auf dedizierten Server möglich
Oracle
3 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Oracle Database Gateways
• Oracle Open Systems Gateways
• Database Gateway for ODBC
• Database Gateway for Sybase
• Database Gateway for SQL Server
• Database Gateway for Teradata
• Database Gateway for Informix
4 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Oracle Database Gateways
• Oracle Mainframe Gateways
• Database Gateway for APPC
• Procedural Gateway
• Database Gateway for Websphere MQ
• Procedural Gateway
• Database Gateway for DRDA
• “Transparent” Gateway
5 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Database Gateway for ODBC vs.
“Spezielle” Gateways
DG4ODBC “Spezielle”
End to end solution No Yes
DDiissttrriibbuutteedd ttrraannssaaccttiioonnss NNoo YYeess
Stored procedures No Yes
Additional software Yes No
Enhanced DD translation No Yes
6 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Architektur
Database Gateway for DRDA
Linux/Unix/Windows
DB2 UDB
for LUW
CClliieenntt SSeerrvveerr
DB2 UDB
DRDA
DG4DRDA
for z/OS
DB2
Oracle
for iSeries
7 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Oracle Database Gateways - Hochverfügbarkeit
Gateway
System 1
Oracle
DG4DRDA
Instance 1
DDBB22
LLiisstteenneerr 11
Gateway
DB21 =
(DESCRIPTION =
(address_LIST=
System 2
(LOAD_BANANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(PORT=1860)(HOST=demo1.de.oracle.com)) DG4DRDA-
(ADDRESS = (PROTOCOL = TCP)(PORT=1861)(HOST=demo2.de.oracle.com)))
(CONNECT_DATA = Instance 2
(SID =GWI1)
) Listener 2
(HS=ok)
8 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Oracle Database Gateways in einer RAC
Umgebung
Gateway
NODE 1 System 1
Oracle DG4DRDA
RAC
DB21 = Instance 1
(DESCRIPTION =
(address_LIST= Listener 1
IInnssttaannccee 11
((LLOOAADD__BBAANNAANNCCEE==OONN))
DDBB22
(FAILOVER=ON)
(ADDRESS = (PROTOCOL =
Gateway
(ADDRESS = (PROTOCOL =
NODE 2
(CONNECT_DATA =
(SID =GWI1) System 2
) Oracle
(HS=ok
RAC DG4DRDA-
Instance 2
Instance 2
Listener 2
9 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Agenda
Architektur
Funktionsweise von Database Gateways –
Unterstützung verschiedenster SQL Dialekte
Performance Aspekte
Zugriff auf Fremdsysteme am Beispiel DB2 for
z/OS (Database Gateway for DRDA)
Optimierung von Load Prozessen
Weiteres
10 Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.