473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Replication Center SQL Replication Subscription sets

I have a problem when using Replication Center on version 8.2 (fixpack 9)
when I try to manage my SQL Replication environment. When I add existing
Apply Control Servers I am not able to see existing subscription sets on
that Apply Server. The apply program works fine however and data are
replicated from the source without problems. My 'problem' is that I cannot
see old subscription sets from within the Replication Center. If I define a
new subscription set I see this new subscription set in the Replication
Center. I have tried to compare the contents in the IBMSNAP_SUBS_SET table,
but am not able to see any difference in the definition between the old and
the new subscription sets.

Has anybody any idea about what to do to be able to see the subscriotion set
in the Replication Center ?
--
Regards

Odd Bjørn Andersen
ErgoGroup
IKT-driftstjenester
N-0402 Oslo Norway
Nov 12 '05 #1
5 2056
Try running db2updv8 utilitiy on the server side. With fixpaks,
sometimes the internal procs/functions are changed and that might cause
this problem.

HTH

Vijay

Nov 12 '05 #2
I tried that now, but it dit not resolve the problem.

Regards
Odd

"UDBDBA" <vi***********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Try running db2updv8 utilitiy on the server side. With fixpaks,
sometimes the internal procs/functions are changed and that might cause
this problem.

HTH

Vijay

Nov 12 '05 #3
do you see the old entries in the replication tables or not even there?

....
dotyet

Odd Bjørn Andersen wrote:
I tried that now, but it dit not resolve the problem.

Regards
Odd

"UDBDBA" <vi***********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Try running db2updv8 utilitiy on the server side. With fixpaks,
sometimes the internal procs/functions are changed and that might cause
this problem.

HTH

Vijay


Nov 12 '05 #4
Yes, I see the old enitres in the replication tables. I try to compare the
old entries with entries from new definitions we have made, and I cannot see
any differences between the old and the new entries. I have looked on both
subs_set, subs_membr and subs_cols on the target side and pruncntl and
prune_set on the source side.

I wonder where Replication Center 'looks' to get the information about
subscription sets. Perhaps I have been checking the wrong places .......

Regards
Odd

"dotyet" <do****@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
do you see the old entries in the replication tables or not even there?

....
dotyet

Odd Bjørn Andersen wrote:
I tried that now, but it dit not resolve the problem.

Regards
Odd

"UDBDBA" <vi***********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Try running db2updv8 utilitiy on the server side. With fixpaks,
sometimes the internal procs/functions are changed and that might cause
this problem.

HTH

Vijay

Nov 12 '05 #5
Hi ,

i've setup two databases for replication on DB2 v7.x on a linux RH ES2
on the same instance and of course the same server (maybe the problem
lies here ...).

I've done the capture and the applying like this :

Source Side :
bind @applyur.lst isolation ur blocking all;

bind @applycs.lst isolation cs blocking all;

Target Side :
bind @applyur.lst isolation ur blocking all;

bind @applycs.lst isolation cs blocking all;

everything runs fine .

at the end , i ran this command line :

../asnccp MONG cold prune

but I got this message :

2005-06-16-15:12:39 ASN0000S: INTERNAL ERROR OCCURRED FOR MESSAGE
NUMBER ASN0048E. ITS SUBSTITUTION FIELDS ARE Permission non accordée.
THE RETURN CODE IS 0.

SQLCA SQL1024N A database connection does not exist. SQLSTATE=08003
Capture will stop.

FYI , MONG is the source database

I also read something about STRDPRCAP on AS/400 but I'm not sure if the
command exists on Linux .

Have you encounter something like this ?

If yes , any help will be welcomed.

TIA ,
Andy the beginner in DB2

UDBDBA a écrit :
Try running db2updv8 utilitiy on the server side. With fixpaks,
sometimes the internal procs/functions are changed and that might cause
this problem.

HTH

Vijay


Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Damian H | last post by:
Hi, For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the...
1
by: Laurence Breeze | last post by:
I don't know if anyone can help with this, I've got replication running between 2 SQLServer installations, the distributor is on the the same server as subscriber. Replication is a once a day...
2
by: ann | last post by:
I have problem with replication db2 database. Program Capture view error ASN5150W and ASN0059W. What i doing wrong?
5
by: Norbert Munkel | last post by:
Hello, Replication setup: Server 1: DB2 UDB Express 8.2 on SuSE Linux SLES 8 Instance: db2inst2 database: master Server 2: DB2 UDB Express 8.2 on SuSE Linux SLES 8 Instance: db2inst1...
9
by: ibm_97 | last post by:
Hi, Anyone can give me a link which shows how to setup DB2 (v8) replication step by step? Thanks. As a non-DB2 person, I find out IBM DB2 doc is not very helpful at all, espeically compare...
1
by: mikelbell2000 | last post by:
Using replication under 8.2 on AIX 5.3. Having mixed success getting what I want done. Scenario: Two database servers configured with identically named tables/columns. Currently both contain...
1
by: jan.gezels | last post by:
Hi We're use DB2 with Data propagator. When I open Replication Centre no config is shown (no capture or apply servers) but everything is still working like it should. If I try to reconfigure, I...
0
by: sk.rasheedfarhan | last post by:
Hi all, I set the configuration for Merge replication for Subscription on one database and I have created the Merge replication for publication on another machine. And I updated columns of...
0
by: Desmodromic | last post by:
I have two linux servers running DB2 v8.2 with SQL replication. I recently started a full refresh of a single subscription set via the Replication Center GUI. This was successful, but seemed to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.