473,545 Members | 2,716 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data Replication DB2 VM to UDB with DPROP

Hello hello,

I am having a horrible time trying to set up some data replication
stuff.

source: DB2 Server for VSE/VM
target: DB2 UDB 7.2 on Windows

I am trying to do the definitions using Control Center and Data Joiner,
as well as a lot of hand-written stuff.

I just cannot get the nasty little blighter to work, and I have a
feeling that it won't, no matter how much I bang my (or its) head
against the wall.

I have tried to ask big Blue, but "The guy who is doing UDB and DROP
support is absent for weeks" is the response.

After creating all the definitions according to the (appallingly
written) instructions on the manual, I start the capture program on VM
and get the following:

=============== =============== =============== =============== ==========
TAKE SYNCHPOINT dont update REGISTER because commitseq was ZEROľn in
setting n
seqrb 00000000094B000 00AB8

not time to update CD_NEW_SYNCHPOI NT

compared tmp_index 1 CD_NEW_SYNCHPOI NT 000000000000000 00000

with last CD_NEW_SYNCHPOI NT 000000000000000 00000

SYNCHPOINT not Updated at time be806096

TAKE SYNCHPOINT dont update REGISTER because commitseq was ZEROľn in
setting n
seqrb 00000000094B000 00AB8

not time to update CD_NEW_SYNCHPOI NT

compared tmp_index 1 CD_NEW_SYNCHPOI NT 000000000000000 00000

with last CD_NEW_SYNCHPOI NT 000000000000000 00000

SYNCHPOINT not Updated at time be8060d2

TAKE SYNCHPOINT dont update REGISTER because commitseq was ZEROľn in
setting n

=============== =============== =============== =============== ==========

puzzled? Join the club. I cannot even work out what nationality the
person who wrote those messages is...

I have progressed in my knowledge a wee bit - that is, I know that the
initial table load is being done (what is called a FULL REFRESH in
these places) but then the CAPTURE program does not record nor capture
any changes.

Have looked at the tables on both sides of the replication and the
thing that bugs me is that the SYNCHPOINT field is always null.

Also, I am obviously talking with IBM on a regular basis, and they
asked me to check if I had got a message in a table called
IBMSNAP_TRACE (on the VM side) where "message ASN0104 was recorded
(which means "The Capture program successfully processed a CAPSTART
signal. If this is the first CAPSTART signal associated with a
particular source table, this message indicates that the Capture
program is now capturing updates to the source table)" - needless to
say I have no such message.

other, random, messages that unnerve me are ones like "--* A SYNCHPOINT
value in the pruning control table at the source server has not been
translated by CAPTURE" that I get in DataJoiner when I try and force an
off-line load.
From my point of view, it is a matter of the stoopid initial load

programs that put the wrong values in the tables - but I really would
give quite a bit to know what values I can manually put where...

Any ideas or suggestions, again?

ciao!

Aurora Dell'Anno
DB2 Systems Engineer - DBA Team
tel.: +32 (0)2 739 7578
e-mail:
Au************* ********@riziv. fgov.be
ad*****@bigfoot .com
_______________ _______________ _______________
No trees were killed in the sending of this message. However - a large
number of electrons were terribly inconvenienced.

Mar 17 '06 #1
0 1536

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

Similar topics

3
12223
by: Daniel | last post by:
Ok..here is my problem. I have two SQL servers that I need to have identical, at least semi-real time data on. One is in a public DMZ with full access to and from the internet, and one is behind a corporate firewall and the box can get out to the internet but cannot be hit directly from the internet in. The two are on seperate networks and...
0
2031
by: Philip Trim | last post by:
General Brief: 3 SQL Servers as MS SQL Server 2000 Standard Edition with Service Pack 3 All using FTP for snapshots All Servers are both Publishers and Distributors. Server A has the correct data needed to be replicated to Server B and C. Server B and C and have blank data. Server B and C are blank databases ready for replication. Server...
4
1414
by: someguy | last post by:
Hi, We are going to be running two SQL Server 2000's from the same physical server, with Windows Server 2003, and I need to have certain tables between them syncronized. Database A is a backend to a website and database B is going to be used by a different department. Both the databases have certain data in common but it isn't stored in...
7
3547
by: Lyn Duong | last post by:
Hi all I'm trying to transfer data from sqlserver 2000 to ibm db2 AIX 8.1.4 using dts packages This works when I use db2 ole db drivers but the problem is that the transfer is very slow as the rows are committed 1 by 1. I want to use th odbc driver but it doesn't seem to work. Has anyone experienced this? any ideas to speed up the...
2
1791
by: Ray | last post by:
Hi, I have an Access 97 Database on the server, which gets updated from Desktops thru a LAN. Employees who have to go to offsite locations, carry the latest copy of the MDB. At the end-of-the day when they return to the office or they send the copy of the MDB, the Laptop version (with their current entries) has to be synchronized with the...
3
1636
by: SimonDB | last post by:
The replication of my database was successful and it works well. I can modify tables and forms, except for one thing : VBA ! I canít add code in VBA, the error message : "incorrect data format". I worked on the database before the replication, and all was ok. After replication, on the master-replica I managed to add some code only one time,...
4
2084
by: Jeff Smith | last post by:
Hi Is there a way to do partial replication of data? I'm looking at having a central back end data file which contains all the data from all users. But when each user synchronises the mobile data files with the main data file, I only want data which is relevant to that user to be synchronised to their data file. Example:
0
323
by: adpucci | last post by:
Hello hello, I am having a horrible time trying to set up some data replication stuff. source: DB2 Server for VSE/VM target: DB2 UDB 7.2 on Windows I am trying to do the definitions using Control Center and Data Joiner, as well as a lot of hand-written stuff.
3
1992
by: Veeru71 | last post by:
We have got 2 DB2-UDB databases (DB1 & DB2) running on separate instances( Inst1 & Inst2). DB1 has got Schema1 and DB2 has got Schema2. We would like to setup some kind of replication to replicate both Schema1 & Schema2 onto a 3 rd database (DB3) running on a 3 rd instance (Inst3). This is basically to separate out Data Reads (Reports...
0
7502
marktang
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...
0
7434
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7946
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7457
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...
0
6026
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectóplanning, coding, testing, and deploymentówithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5078
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...
0
3491
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...
1
1921
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1045
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.