Distributed Relational Database Architecture setup
Distributed Relational Database Architecture(DRDA) setup.
1.Download the software from oracle support. : LINUX.X64_193000_gateways.zip
oracle@AppsServer:/u00
$ ls -ltr
-rwxrwxrwx 1 oracle dba 1007154302 Apr 1 06:37 LINUX.X64_193000_gateways.zip
2. Unzip the file LINUX.X64_193000_gateways.zip and start installation using runinstaller
export TMP=$HOME/tmp
cd /u00/gateways
./ runInstaller
3.After starting the installation,Provide all the source database details including port number
and database name given by the Apps Team .
Details
DB2 UDB Server Hostname or IP Address : <IP address>
DB2 UDB DRDA server listener port Number : 446
DB2 UDB database name :UDB
DB2 UDB Target Type :IOS
4.After completing the installation successfully, configure the listener and start it.
5. Find the configuration content of initdg4db2.ora and update the parameters with
relevant values
cd /u00/app/oracle/product/19.0.0/tghome_1/dg4db2/admin
Init Parameter file
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for DB2
# HS init parameters
#
HS_FDS_CONNECT_INFO=<get from Apps / Middleware Team>
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_FDS_RESULTSET_SUPPORT=FALSE
HS_IDLE_TIMEOUT=0
HS_FDS_PACKAGE_COLLID=NULLID
HS_FDS_WORKAROUNDS=16
HS_FDS_DELAYED_OPEN=FALSE
HS_RPC_FETCH_SIZE = 400000
Hs_RPC_FETCH_REBLOCKING=ON
HS_FDS_FETCH_ROWS=1
HS_FDS_TRACE_LEVEL=0
HS_FDS_TRANSACTION_ISOLATION=READ_UNCOMMITTED
HS_FDS_SUPPORT_STATISTICS=TRUE
Steps to create DRDA Database links.
1.To Create public Database link.
Set the db environent
. oraenv [dbname]
Sqlplus / as sysdba
Below syntax should be used to create the db link.
create public database link <DBLINKNAME> connect to username identified by xxxxx using ‘DB2LINK’;
2. DB2LINK tnsentry added in tnsnames.ora
####
DB2LINK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =orcltst)(PORT = 1587))
(CONNECT_DATA =
(SERVICE_NAME = dg4db2)
)
(HS=OK) )
3) Verification
$tnsping DB2LINK
once the tnsping is working check the below command
Select count(*) from scott.emp@<DBLINKNAME>;
See also