Replication to Remote Databases.

Sreedhar Bobbadi

Replication to Remote Databases.
Dear Gurus

We are using Data Propagator (Ver 7) to replicate data from one DB2
(os/390) Data Sharing group to another. This works like a charm. Recently
we started replicating to a remote DB2 (os/390) and I am seeing that this
is painfully slow. The following is mainview elapse time analysis :

CATEGORY #EVENTS AVG/EVENT ELAPSED %TOTAL
---------------- ------- --------- -------- ------- 0
...25...50...75..100%
ELAPSED TIME |
|
IN DB2 01:17:19 96.37 |
******************* |
IN APPLICATION 00:02:54 3.62 | <
|
--TOTALS-- 01:20:13 100.00 |
******************** |
WAITS IN DB2 (LOCAL) |
|
LOCK/LATCH 320 155 us 50 ms 0.00 |
|
I/O WAIT 1,161 5,612 us 6,515 ms 0.13 | <
|
LOG WRITE I/O 3 1,806 us 5,417 us 0.00 |
|
OTHER READ I/O 305 17 ms 5,057 ms 0.10 | <
|
OTHER WRITE I/O 8 80 ms 644 ms 0.01 | <
|
UNIT SWITCH EVENTS |
|
..COMMIT/ROLLBK 192 4,372 us 839 ms 0.01 | <
|
..OPEN/CLOSE 3 126 ms 378 ms 0.00 |
|
..SYSLGRNG 2 725 us 1,449 us 0.00 |
|
..DATASPACE MGR 3 32 ms 95 ms 0.00 |
|
..OTHER 166,068 27 ms 01:15:40 94.31 |
****************** |
ARCH. LOG(QIS) 0 0 us 0 us 0.00 |
|
ARCH.READ(TAPE) 0 0 us 0 us 0.00 |
|
DRAIN LOCK 0 0 us 0 us 0.00 |
|
CLAIM RELEASE 0 0 us 0 us 0.00 |
|
PAGELATCH CONT. 0 0 us 0 us 0.00 |
|
SPAS SERVER TCB 0 0 us 0 us 0.00 |
|
Force-at-commit 0 0 us 0 us 0.00 |
|
---TOTAL WAITS--- 168,065 27 ms 01:15:53 94.59 |
****************** |
*NOT ACCOUNTED 22 s 0.44 | <
|

Can somebody point me to the parms or stuff that I should be looking at to
improve preformace.

Thank You
Sreedhar.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm