Skip to Content

Read DB2/400 table from SAP R/3 Oracle

*The customer a day has asked to me: I have an application in SAP R/3 Oracle and have need to read on-linens approximately 50.000 records with frequent modifications in short times ( max 1 minute. ) one table db2/400 on  OS400.* The solution is based on uses of the Transparent Oracle Gateway. A) The times of elaboration in the system – landscape they have allowed to read 50000 records ( 470 byte – one record ) me in 20 sec from R/3 Oracle to db2/400. *The performance on yours system-landscape could be better or worse in how much why it is influenced from various factors:

CPU type and memory configuration
database topology
I/O topology
network topology
system workload by type
Oracle workload characterization
query execution plans
DB2/400 resource information

* In Fig. 1 you can see the architecture.  Fig. 1 Architecture image The gateway has no database functions of its own. Instead, it provides an interface by which the Oracle Database 10g server can direct SQL operations to a DB2/400 database. The gateway that is supporting the DB2/400 server is identified to the Oracle Database 10g server by using a database link. The database link is the same construct that is used to identify other Oracle Database 10g server databases. Tables on the DB2/400 server are referenced in SQL as: [table_name@dblink_name | mailto:table_name@dblink_name] or, preferably, as: [owner.table_name@dblink_name | mailto:owner.table_name@dblink_name] If you create synonyms or views in the Oracle Database, then you can refer to tables on the DB2/400 server by using simple names as though the tables were local to the Oracle Database 10g server. When the Oracle Database 10g server encounters a reference to a table on the DB2/400 server, the applicable portion of the SQL statement is sent to the gateway for processing. Any host variables that are associated with the SQL statement are bound to the gateway and, therefore, to the DB2/400 server. The gateway is responsible for sending these SQL statements to the DB2/400 server. The DB2/400 server is responsible for executing the SQL statements and for detecting and returning responses. Fig.2 Sap Architecture image

Be the first to leave a comment
You must be Logged on to comment or reply to a post.