Regarding Replication DB2 UDB - Page 2

sat

i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?

Knut Stolze wrote:

sat wrote:

Hi!
I have seen jus now in the target table (TGDEPTCOPY) it's still
showing only 4 records.I kept the time interval for replication as 15
minutes.But still its not working.I'm not even facing any errors.Please
do let me know what might be the problem.

Hard to tell. Did you use the logs when you started capture and apply?
Have you actually started both? What do the logs show? What does
the "status" in the Replication Center show?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 19 '06

Subscribe Reply

3453

sat

Sorry i dint mean that i didnt read your messages.
But this is for the 1st time i'm working on replication so i couldnt
get from ur points.

Knut Stolze wrote:

sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.

I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 20 '06 #11

sat

I have given the correct userid and password.Even now i was trying.But
its not working.

2006-09-20-13.20.51.019000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2836 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2836,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

This is wat i have seen in the capture log today .

Knut Stolze wrote:

sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.

I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 20 '06 #12

sat

Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that
you
have somewhere a non-existing user or an invalid password specified,
which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

Even i have seen in the replication center--Manage passwords and
connectivity--the userid and the password are same.
There is no non-existing user.Because each and every time i'm the only
person gettting connected.
I only created both the capture and apply databases.So,au tomatically
i'll be able to connect to both the databases.
Even then i'm not able to do.Please do suggest me.

sat wrote:

I have given the correct userid and password.Even now i was trying.But
its not working.

2006-09-20-13.20.51.019000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2836 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2836,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

This is wat i have seen in the capture log today .

Knut Stolze wrote:
sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.
I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 20 '06 #13

Joachim Müller

sat schrieb:

Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that
you
have somewhere a non-existing user or an invalid password specified,
which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

Even i have seen in the replication center--Manage passwords and
connectivity--the userid and the password are same.
There is no non-existing user.Because each and every time i'm the only
person gettting connected.
I only created both the capture and apply databases.So,au tomatically
i'll be able to connect to both the databases.
Even then i'm not able to do.Please do suggest me.

sat wrote:
>I have given the correct userid and password.Even now i was trying.But
its not working.

2006-09-20-13.20.51.019000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD283 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2836,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD960 ,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD960,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.CMD".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD960 ,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD960,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.CMD".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD329 2,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3292,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD329 2,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3292,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD230 0,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2300,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD230 0,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2300,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD341 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3416,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD341 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3416,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

This is wat i have seen in the capture log today .

Knut Stolze wrote:
>>sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.
I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Hi,

I think you have to forget to create a password file with asnpwd,
and than start the control server:

asnapply CONTROL_SERVER= xxx APPLY_QUAL=xxx APPLY_PATH="/db2/xxx/db2d
ump" PWDFILE=../../db2xx/replication/asnpwd.aut

Best regards,
Joachim Müller

Sep 21 '06 #14

Joachim Müller

sat schrieb:

Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that
you
have somewhere a non-existing user or an invalid password specified,
which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

Even i have seen in the replication center--Manage passwords and
connectivity--the userid and the password are same.
There is no non-existing user.Because each and every time i'm the only
person gettting connected.
I only created both the capture and apply databases.So,au tomatically
i'll be able to connect to both the databases.
Even then i'm not able to do.Please do suggest me.

sat wrote:
>I have given the correct userid and password.Even now i was trying.But
its not working.

2006-09-20-13.20.51.019000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD283 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2836,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD960 ,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD960,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.CMD".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD960 ,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD960,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.CMD".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD329 2,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3292,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD329 2,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3292,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD230 0,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2300,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD230 0,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD2300,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD341 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3416,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48tem pDB2.SAMPLE.ASN .CAP.IPC.CMD341 6,
OSSEIPC49tempD B2.SAMPLE.ASN.C AP.IPC.CMD3416,
OSSEIPC50tempD B2.SAMPLE.ASN.C AP.IPC.C".

This is wat i have seen in the capture log today .

Knut Stolze wrote:
>>sat wrote:

Actually for both the capture and apply programs the check status is in
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.
I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Sep 21 '06 #15

sat

Hi,
I really feel thankful for your timely help.And yesterday i found
out that we need to have PRIMARY KEY on the TARGET TABLE if we need to
create a replication environment.So that was the mistake i have
done.And even i have created the "asnpwd".
Hope i will be getting much encouragement regarding replication.

Thanks & Regards,
Sat.
Joachim Müller wrote:

sat schrieb:
Check the user/password settings that you use in the Control Center
(or "asnclp" if you manage DB2 Replication that way). I'd think that
you
have somewhere a non-existing user or an invalid password specified,
which
causes the SQL30082 to be raised. Also, make sure that the user under
whose authority capture/apply is run is allowed to connect to both
databases.

Even i have seen in the replication center--Manage passwords and
connectivity--the userid and the password are same.
There is no non-existing user.Because each and every time i'm the only
person gettting connected.
I only created both the capture and apply databases.So,au tomatically
i'll be able to connect to both the databases.
Even then i'm not able to do.Please do suggest me.

sat wrote:
I have given the correct userid and password.Even now i was trying.But
its not working.

2006-09-20-13.20.51.019000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2836 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2836,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.21.51.175000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD960,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD960,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.CMD".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.22.51.300000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3292 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3292,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.23.51.597000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD2300 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD2300,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Attached to" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

2006-09-20-13.24.37.879000 <cmdsEngineASN8 008D "Capture" : "ASN" :
"Initial" : "Detached from" IPC queue with key(s)
"(OSSEIPC48temp DB2.SAMPLE.ASN. CAP.IPC.CMD3416 ,
OSSEIPC49tempDB 2.SAMPLE.ASN.CA P.IPC.CMD3416,
OSSEIPC50tempDB 2.SAMPLE.ASN.CA P.IPC.C".

This is wat i have seen in the capture log today .

Knut Stolze wrote:
sat wrote:

Actually for both the capture and apply programs the check status isin
resting.
So how can i activate them again?
So that the replication will work fine?Worker thread,Admin thread...
all these are the ones which i have seen in check status.
So, please guide me how i need to activate both the programs.
I'm sorry, but I don't see any point in continuing this discussion since you
don't appear to read my responses.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Hi,

I think you have to forget to create a password file with asnpwd,
and than start the control server:

asnapply CONTROL_SERVER= xxx APPLY_QUAL=xxx APPLY_PATH="/db2/xxx/db2d
ump" PWDFILE=../../db2xx/replication/asnpwd.aut

Best regards,
Joachim Müller

Sep 22 '06 #16

Similar topics

3889

Setting up replication with access front end

by: John | last post by:

Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql server and then link the tables to access front-end mdb app (using odbc?). Copy the same setup (access front end + sql backend) onto each laptop....

Microsoft Access / VBA

5976

Access Back-End Over the Internet?

by: Raphi | last post by:

Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving to a 2nd office 15 minutes down the road. Only one office will be open at a time, so theoretically it'd be possible to copy the back-end manually every night from one office to another, but frankly, that's pretty annoying.

Microsoft Access / VBA

3936

Jet 4 Replication Service Pack

by: David W. Fenton | last post by:

See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4 synchronizer. This allows anyone to do indirect replication, even without

Microsoft Access / VBA

1877

Regarding Replication in DB2 UDB

by: sat | last post by:

Hi Everybody ! I want to know about REPLICATION in DB2 UDB in detail.As i'm going to work on this i would like to know about it.I want to do it on my PC (if possible) before i can implement it on production systems.So,can anyone let me know the SCENARIOS of DB2 UDB REPLICATION in detail.What is replication? what are the steps we need to do while/before/after starting the replication.To be in brief i want to know the implementation and...

DB2 Database

2789

Regarding db2 udb Replication

by: sat | last post by:

Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now i want the source db to be under one instance and target db to be under another instance. what i have done is i kept the source db(say sample) under same instance (say db2) as it was before.Now i created a new

DB2 Database

1211

Regarding Replication Concept

by: ParasakthiGuru | last post by:

hai, i don't know Replication concept if anybody can know that replication concept pls sent to me replication brief tutorials By Guru

Microsoft SQL Server

4552

SQL Replication Migration from V8 to V9

by: Gert van der Kooij | last post by:

Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to migrate from V7 to V8 but that's fully described so that's no problem). The PDF 'Migrating to Replication Version 9' doesn't contain a description about migrating SQL Replication, only Q replication. I found some links to PDF manuals which should...

DB2 Database

1238

Regarding SQL Replication

by: FM | last post by:

Hello: Question's on replication. My replication-scenario: Server A -source-tables and capture-server Server B -destination-tables with CD tables federated in it and apply-server Inert method: ASNLOAD with crossloader

DB2 Database

1866

Need help regarding replication in MySql database.

by: Abhinay | last post by:

Hi there, I am C++ programer, new in MySql database, I am using linux OS. Is MySql supports pear to pear replication ( I wanted to duplicate data of master database to salve database at run time for each and every transaction ) ? If no then how to achive it ? I know SqlServer provides pear to pear replication and I wanted to know about similar facility in MySql database. your help would make me happy.

MySQL Database

9686

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10475

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10250

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10222

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6805

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5463

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5585

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3757

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General