Replication with UDB v8

[randi_clausen]

Regarding a new replication process using two Windows 2000 servers at
5.00.2195, one machine with SP4 and the other SP3, and both running WSE
8.1.5., I am requesting assistance. My dilemma--It appears that my
replication scenario is running without any errors, BUT it is not
copying changes and new records from the source database to the target
database tables.
1) The .trc file shows no error.

2) The Capture log file shows:
....
2005-02-28-15.47.34.843000 <CWorkerMain> ASN0100I CAPTURE "ASNRC". The
Capture program initialization is successful.
2005-02-28-15.47.34.843000 <CWorkerMain> ASN0109I CAPTURE "ASNRC". The
Capture program has successfully initialized and is capturing data
changes for "0" registrations. "0" registrations are in a stopped
state. "2" registrations are in an inactive state.
2005-02-28-15.52.34.546000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 15:52:34 2005".
2005-02-28-15.52.34.578000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 15:52:34 2005".
2005-02-28-15.57.34.875000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 15:57:34 2005".
2005-02-28-15.57.34.875000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 15:57:34 2005".
2005-02-28-16.02.35.171000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:02:35 2005".
2005-02-28-16.02.35.171000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:02:35 2005".
2005-02-28-16.07.35.453000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:07:35 2005".
2005-02-28-16.07.35.453000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:07:35 2005".
2005-02-28-16.12.35.750000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:12:35 2005".
2005-02-28-16.12.35.750000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:12:35 2005".

3) The Apply log file shows:
....
2005-02-28-15.48.35.781000 <asnParmClass::printParms> ASN0529I "Apply"
: "REPLRCQ1" : The value of "INAMSG" was set to "Y" at startup by the
following method: "DEFAULT".
2005-02-28-15.48.36.359000 <Asnenv:setEnvIpcQRcvHdl> ASN8008D "Apply"
: "REPLRCQ1" : "Created" IPC queue with key(s)
"(OSSEIPC0tempRANDI.REPLRC.REPLRCQ1.APP.IPC,
OSSEIPC1tempRANDI.REPLRC.REPLRCQ1.APP.IPC,
OSSEIPC2tempRANDI.REPLRC.REPLRCQ1.APP.IPC".
2005-02-28-15.48.36.359000 <CPCIMPC(08/07)> ASN1045I APPLY "REPLRCQ1".
The Apply program was started using database "REPLRC".
2005-02-28-15.48.37.156000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-15.53.37.312000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-15.58.37.484000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.03.37.640000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.08.37.796000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.13.37.953000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.

I have been working on this for days. I have set up a replication
process and then deleted it and started again. I have referenced the
IBM Redbook 'A Practical Guide to DB2 UDB Data Replication V8' and
searched the internet for answers.

Please give me input as to what I am missing. Thank you!

[Paul Peters]

Hello,

In the apply log file there is the message : 2005-02-28-16.03.37.640000
<CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.

This normally means that the apply program have detected a failure and is
waiting 5 minutes (the default) and will try again.

I will always submit the following query on the apply control table :

select * from asn.ibmsnap_applytrail order by lastrun desc fetch first 5
rows only

then you will see the latest error or success message in the table. When
there is an error : one of the last columns is the tablename where the
problem is occurred and what the exact problem is.

Good luck.
<ra***********@ins.state.il.us> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

Regarding a new replication process using two Windows 2000 servers at
5.00.2195, one machine with SP4 and the other SP3, and both running WSE
8.1.5., I am requesting assistance. My dilemma--It appears that my
replication scenario is running without any errors, BUT it is not
copying changes and new records from the source database to the target
database tables.
1) The .trc file shows no error.

2) The Capture log file shows:
...
2005-02-28-15.47.34.843000 <CWorkerMain> ASN0100I CAPTURE "ASNRC". The
Capture program initialization is successful.
2005-02-28-15.47.34.843000 <CWorkerMain> ASN0109I CAPTURE "ASNRC". The
Capture program has successfully initialized and is capturing data
changes for "0" registrations. "0" registrations are in a stopped
state. "2" registrations are in an inactive state.
2005-02-28-15.52.34.546000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 15:52:34 2005".
2005-02-28-15.52.34.578000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 15:52:34 2005".
2005-02-28-15.57.34.875000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 15:57:34 2005".
2005-02-28-15.57.34.875000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 15:57:34 2005".
2005-02-28-16.02.35.171000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:02:35 2005".
2005-02-28-16.02.35.171000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:02:35 2005".
2005-02-28-16.07.35.453000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:07:35 2005".
2005-02-28-16.07.35.453000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:07:35 2005".
2005-02-28-16.12.35.750000 <PruneMain> ASN0111I CAPTURE "ASNRC". The
pruning cycle started at "Mon Feb 28 16:12:35 2005".
2005-02-28-16.12.35.750000 <PruneMain> ASN0112I CAPTURE "ASNRC". The
pruning cycle ended at "Mon Feb 28 16:12:35 2005".

3) The Apply log file shows:
...
2005-02-28-15.48.35.781000 <asnParmClass::printParms> ASN0529I "Apply"
: "REPLRCQ1" : The value of "INAMSG" was set to "Y" at startup by the
following method: "DEFAULT".
2005-02-28-15.48.36.359000 <Asnenv:setEnvIpcQRcvHdl> ASN8008D "Apply"
: "REPLRCQ1" : "Created" IPC queue with key(s)
"(OSSEIPC0tempRANDI.REPLRC.REPLRCQ1.APP.IPC,
OSSEIPC1tempRANDI.REPLRC.REPLRCQ1.APP.IPC,
OSSEIPC2tempRANDI.REPLRC.REPLRCQ1.APP.IPC".
2005-02-28-15.48.36.359000 <CPCIMPC(08/07)> ASN1045I APPLY "REPLRCQ1".
The Apply program was started using database "REPLRC".
2005-02-28-15.48.37.156000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-15.53.37.312000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-15.58.37.484000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.03.37.640000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.08.37.796000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.
2005-02-28-16.13.37.953000 <CPREST(01/00)> ASN1044I APPLY "REPLRCQ1".
The Apply program will become inactive for "5" minutes and "0" seconds.

I have been working on this for days. I have set up a replication
process and then deleted it and started again. I have referenced the
IBM Redbook 'A Practical Guide to DB2 UDB Data Replication V8' and
searched the internet for answers.

Please give me input as to what I am missing. Thank you!

[Gert van der Kooij]

In article <11**********************@l41g2000cwc.googlegroups .com>,
ra***********@ins.state.il.us (ra***********@ins.state.il.us) says...

2005-02-28-15.47.34.843000 <CWorkerMain> ASN0109I CAPTURE "ASNRC". The
Capture program has successfully initialized and is capturing data
changes for "0" registrations. "0" registrations are in a stopped
state. "2" registrations are in an inactive state.

I guess this message shows the problem, data is captured for "0"
registrations and "2" registrations are inactive.

You can download a trial version from the Replication Monitoring
Center from https://secure.alphaworks.ibm.com/tech/db2rmc , maybe it
shows you the cause of those inactive registrations.

Hope this helps.