View previous topic :: View next topic
|
Author |
Message |
rahuindo
New User
Joined: 09 Apr 2008 Posts: 83 Location: Chennai
|
|
|
|
Hi,
We have 3 mainframe machines A, B and C in our system. The DB2 database resides in the mainframe machine A and it is where the DB2 tables get updated through different transactions. We need to retrieve the data from this DB2 database,on machine A, from Machine B and C.
One of the approach would be to replicate the DB2 database in Machine B and C as same as in Machine A.
I wanted to know if there is any other approach by which we can retrieve the data. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you replicate the data on the B and C machines, there should be less impact on the transaction processing on machine A.
To do this in real time, suggest you read about DRDA ( distributed relational database access ). There are sometmes significant performance issues. . . |
|
Back to top |
|
|
Ajay Baghel
Active User
Joined: 25 Apr 2007 Posts: 206 Location: Bangalore
|
|
|
|
From my little knowledge, but not very sure, but i think such programs have CONNECT TO ... statement
And the DBPROTOCOL is DRDA in the BIND Card. |
|
Back to top |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
|
|
Hello,
Sometime before we did some comparison study with the DRDA protocol.
Suggest You start from here to setup DRDA
For us the results were not looking good as the DRDA protocol was heavy on the CPU consumption time.....
And the BIND Control Card goes something like this.......
Code: |
//SYSTSIN DD *
DSN SYSTEM(DA21)
BIND PLAN(YOURPGM) MEMBER(YOURPGM) -
LIBRARY ('YOUR.LIB.DBR') -
ACTION (REPLACE), VALIDATE(BIND), ISOLATION (CS) , FLAG (I), -
ACQUIRE (USE) , RELEASE (COMMIT) , EXPLAIN (NO), RETAIN, -
OWNER(XXXXXX) , QUALIFIER(XXXXXX) , DBPROTOCOL(DRDA)
END
|
And to Connect to the Database
Code: |
EXEC SQL CONNECT TO
DB01
END-EXEC
|
Syam |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
rahuindo,
You need to go for CDC( Change Data Capture ). Like capturing data from Daily Prod sub-system to warehousing sub-system.
Do you have any DB2 Tools like Log Analyzer, but using tools like that you get any DML activities against a table. It can generate DELETE , INSERT & UPDATE statements, which you can run on other sub-system with a little manipulations.
Also look into CURRENTSERVER option in BIND PLAN.
Thanks,
Sushanth |
|
Back to top |
|
|
|