473,387 Members | 1,897 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,387 software developers and data experts.

Problem with replication

Hello all !

I have DB2 7.2.7 on AIX 5.2. I have defined replication of two tables from
database1 to database2 (both databases are on the same DB2 node and in the
same instance). But this replication is/nt working.

Changed, or inserted rows on source tables are captured to capture tables on
database1, but apply process is'nt applying these changes to target tables
on databases2.

Target tables on database2 were created with replication and in
"applyqualname.PWD" file I have userid and password of instance owner. Even
thought applying of changes is'nt working. When i run apply process with
trace, I have still these messages:

Compiled(F) at 01:06:07 on Mar 4 2003 (Level 70113z)
CDSET: spill_file(0) = HUMANREPLICQUAL.000
FETSET: The number of rows fetched is 0.
PSET: Fetch answer set for member 1
Compiled(F) at 01:06:07 on Mar 4 2003 (Level 70113z)
CDSET: spill_file(1) = HUMANREPLICQUAL.001
FETSET: The number of rows fetched is 0.

But this is'nt right, because in capture tables are several new rows.

Can anybody help me please ?

Ing. Stanislav KESTER

mailto:ke****@zelpo.sk

tel.: +421-48-6452491

fax: +421-48-6452402

Nov 12 '05 #1
0 1466

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

Similar topics

0
by: I.P. | last post by:
------=_NextPart_000_03FF_01C368A4.75720DC0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Hi, it's my story. I have two 4.0.14 mysql server on...
3
by: Rodrigo | last post by:
Hi to all: I have build an application with Visual Basic .NET, to start SQL Server replication. For each replication initiated (50 replication each 10 minutes), I create a new thread. The...
0
by: Markus Enders | last post by:
Hi everybody, we are using version 7 of db2 and need to replicate a database. We are using two web-based systems, which access two different databases. One system is used for import data...
3
by: Juan Antonio Villa | last post by:
Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to the slave, an example update reads as follows:...
3
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...
8
by: Benzine | last post by:
Hi, I have an issue with my replication at the moment. I will try to describe the scenario accurately. I am using MS SQL 2000 SP4 with Merge Replication. Subscribers connect to the publisher...
7
by: m.gelosa | last post by:
Dear all, I got a problem on db2 for aix running a high workload messaging system with more than 5,000,000 of deliveries per day. During high peak hours it happens frequently that the...
0
by: Mannie | last post by:
Hi! I try to add a new subscription to one of my Servers, but I get an error: "Microsoft SQL Server Management Studio is unable to access replication components because replication is not...
0
by: shgzs33 | last post by:
I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a replication betwwen them: SERVER1 as Publisher and SERVER2 as subscriber. the problem is that SERVER2 is runnint on port...
0
by: tsharp89 | last post by:
We currently have SQL Server 2000 and have merge replication. We have the following process 1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
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...

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.