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.