By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,918 Members | 1,923 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,918 IT Pros & Developers. It's quick & easy.

Regarding db2 udb Replication

P: n/a
sat
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
instance(say db2inst1) and created a db (say dbinst) under that
instance.Now i want "dbinst" as my target database.
So can anyone please help me out.

Thanks in Advance
sat.

Sep 15 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
In article <11*********************@e3g2000cwe.googlegroups.c om>,
vi*********@gmail.com says...
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
instance(say db2inst1) and created a db (say dbinst) under that
instance.Now i want "dbinst" as my target database.
So can anyone please help me out.

Thanks in Advance
sat.

You might need to add them to the COntrol Center before you can use the
Replication Center but it should work without a problem. Did you run
into problems? If so, please tell us what you did and which error
messages you got etc..
Sep 15 '06 #2

P: n/a
sat

First of all Thanks for the reply and i added the instance in the
control center .
Then thru the command editor i attached to this instance (i.e.)
db2inst1
and i even i connected to the database (i.1) db inst.I catalogged the
databse in the DB2 instance.Which is the default instance and where i
did my initial replication.

coming to my initial replication both the source and
target server (i.e) databases reside under the same instance.And at
that time after the replication setup is over i tried it by inserting a
record in the source table and it was working fine the change was
updated in the target server.
Now i'm facing a new problem with the initial
replication.
Like i added some records to the table present in source server.And
i've noticed that those changes are not applied to the COPYDB (which is
the target server) and the table name in the target server is
TGDEPTCOPY.I don understand why it is happening like this.
Can anyone please help me out with this issue.
Thanks in Adavance,
Sat.
Gert van der Kooij wrote:
In article <11*********************@e3g2000cwe.googlegroups.c om>,
vi*********@gmail.com says...
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
instance(say db2inst1) and created a db (say dbinst) under that
instance.Now i want "dbinst" as my target database.
So can anyone please help me out.

Thanks in Advance
sat.

You might need to add them to the COntrol Center before you can use the
Replication Center but it should work without a problem. Did you run
into problems? If so, please tell us what you did and which error
messages you got etc..
Sep 16 '06 #3

P: n/a
In article <11*********************@d34g2000cwd.googlegroups. com>,
vi*********@gmail.com says...
>
First of all Thanks for the reply and i added the instance in the
control center .
Then thru the command editor i attached to this instance (i.e.)
db2inst1
and i even i connected to the database (i.1) db inst.I catalogged the
databse in the DB2 instance.Which is the default instance and where i
did my initial replication.

coming to my initial replication both the source and
target server (i.e) databases reside under the same instance.And at
that time after the replication setup is over i tried it by inserting a
record in the source table and it was working fine the change was
updated in the target server.
Now i'm facing a new problem with the initial
replication.
Like i added some records to the table present in source server.And
i've noticed that those changes are not applied to the COPYDB (which is
the target server) and the table name in the target server is
TGDEPTCOPY.I don understand why it is happening like this.
Can anyone please help me out with this issue.
Thanks in Adavance,
Sat.

Did you check that again after more than an hour? If data has been
replicated succesfully if might take an hour for the next replication
cycle to replicate again.
Sep 16 '06 #4

P: n/a
sat
This is the source server sample and source table is department.The
no.of records before was 9 records and added a2 more records yesterday
night.
db2 =connect to sample

Database Connection Information

Database server = DB2/NT 8.2.0
SQL authorization ID = ADMINIST...
Local database alias = SAMPLE

db2 =select count(*) from department

1
-----------
21

1 record(s) selected.

db2 =select * from department

DEPTNO DEPTNAME MGRNO ADMRDEPT LOCATION
------ ----------------------------- ------ -------- ----------------
A00 SPIFFY COMPUTER SERVICE DIV. 000010 A00 -
B01 PLANNING 000020 A00 -
C01 INFORMATION CENTER 000030 A00 -
D01 DEVELOPMENT CENTER - A00 -
D11 MANUFACTURING SYSTEMS 000060 D01 -
D21 ADMINISTRATION SYSTEMS 000070 D01 -
E01 SUPPORT SERVICES 000050 A00 -
E11 OPERATIONS 000090 E01 -
E21 SOFTWARE SUPPORT 000100 E01 -
E22 CUSTOMER SUPPORT 000300 A00
A00 SPIFFY COMPUTER SERVICE DIV. 000010 A00 -
B01 PLANNING 000020 A00 -
C01 INFORMATION CENTER 000030 A00 -
D01 DEVELOPMENT CENTER - A00 -
D11 MANUFACTURING SYSTEMS 000060 D01 -
D21 ADMINISTRATION SYSTEMS 000070 D01 -
E01 SUPPORT SERVICES 000050 A00 -
E11 OPERATIONS 000090 E01 -
E21 SOFTWARE SUPPORT 000100 E01 -
E22 CUSTOMER SUPPORT 000300 A00
E23 RESEARCH CENTER 000500 E10

21 record(s) selected.
This is the target server and the target table is tgdeptcopy.So the
records are not updated.
db2 =connect to copydb

Database Connection Information

Database server = DB2/NT 8.2.0
SQL authorization ID = ADMINIST...
Local database alias = COPYDB

db2 =select count(*) from tgdeptcopy

1
-----------
4

db2 =select * from tgdeptcopy

DEPTNO DEPTNAME MGRNO ADMRDEPT LOCATION
------ ----------------------------- ------ -------- ----------------
E01 SUPPORT SERVICES 000050 A00 -
E11 OPERATIONS 000090 E01 -
E21 SOFTWARE SUPPORT 000100 E01 -
E22 CUSTOMER SUPPORT 000300 A00

4 record(s) selected.

1 record(s) selected.
Gert van der Kooij wrote:
In article <11*********************@d34g2000cwd.googlegroups. com>,
vi*********@gmail.com says...

First of all Thanks for the reply and i added the instance in the
control center .
Then thru the command editor i attached to this instance (i.e.)
db2inst1
and i even i connected to the database (i.1) db inst.I catalogged the
databse in the DB2 instance.Which is the default instance and where i
did my initial replication.

coming to my initial replication both the source and
target server (i.e) databases reside under the same instance.And at
that time after the replication setup is over i tried it by inserting a
record in the source table and it was working fine the change was
updated in the target server.
Now i'm facing a new problem with the initial
replication.
Like i added some records to the table present in source server.And
i've noticed that those changes are not applied to the COPYDB (which is
the target server) and the table name in the target server is
TGDEPTCOPY.I don understand why it is happening like this.
Can anyone please help me out with this issue.
Thanks in Adavance,
Sat.


Did you check that again after more than an hour? If data has been
replicated succesfully if might take an hour for the next replication
cycle to replicate again.
Sep 16 '06 #5

P: n/a
In article <11**********************@k70g2000cwa.googlegroups .com>,
vi*********@gmail.com says...
This is the source server sample and source table is department.The
no.of records before was 9 records and added a2 more records yesterday
night.
.....
This is the target server and the target table is tgdeptcopy.So the
records are not updated.
....
Use the replication center and read the docs to find out if the capture
and apply programs are running without a problem. This basic replication
setup should work if everything is set up correctly so you have to
educate yourself. If you find any error message which you don't
understand you can always ask how to handle it.

Keep on learning :)
Gert van der Kooij wrote:
In article <11*********************@d34g2000cwd.googlegroups. com>,
vi*********@gmail.com says...
>
First of all Thanks for the reply and i added the instance in the
control center .
Then thru the command editor i attached to this instance (i.e.)
db2inst1
and i even i connected to the database (i.1) db inst.I catalogged the
databse in the DB2 instance.Which is the default instance and where i
did my initial replication.
>
coming to my initial replication both the source and
target server (i.e) databases reside under the same instance.And at
that time after the replication setup is over i tried it by inserting a
record in the source table and it was working fine the change was
updated in the target server.
Now i'm facing a new problem with the initial
replication.
Like i added some records to the table present in source server.And
i've noticed that those changes are not applied to the COPYDB (which is
the target server) and the table name in the target server is
TGDEPTCOPY.I don understand why it is happening like this.
Can anyone please help me out with this issue.
Thanks in Adavance,
Sat.
>

Did you check that again after more than an hour? If data has been
replicated succesfully if might take an hour for the next replication
cycle to replicate again.

Sep 16 '06 #6

P: n/a
Gert van der Kooij wrote:
Use the replication center and read the docs to find out if the capture
and apply programs are running without a problem. This basic replication
setup should work if everything is set up correctly so you have to
educate yourself. If you find any error message which you don't
understand you can always ask how to handle it.
Another good idea when just playing around with this (which is what the OP
is doing at the moment) would be to set the interval between replication
cycles to just 1 minute. Then you don't have to wait very long to see some
effects.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 18 '06 #7

P: n/a
sat
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.

Knut Stolze wrote:
Gert van der Kooij wrote:
Use the replication center and read the docs to find out if the capture
and apply programs are running without a problem. This basic replication
setup should work if everything is set up correctly so you have to
educate yourself. If you find any error message which you don't
understand you can always ask how to handle it.

Another good idea when just playing around with this (which is what the OP
is doing at the moment) would be to set the interval between replication
cycles to just 1 minute. Then you don't have to wait very long to see some
effects.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 18 '06 #8

P: n/a
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 18 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.