alternative to Replicating data between two DB2 Databases... 
Author Message
 alternative to Replicating data between two DB2 Databases...

We have created a Prod and Test database.  The prod one is the one
that we made first.  I am trying to copy the prod tables to the test
database.  I figured that Replication would be good to use here, but
then I ran into the dreaded Column name > 18 characters issue for
replication.  We have a ton of these tables and a ton of columns that
have > 18 characters for the column name.  So it looks like that I
will not be able to use the DB2 replication to copy the changes from
one DB to the other.

Wondering if anyone else has encountered this problem.  What other
options are there to copy the data over.  I am thinking that it would
have to be an export and then import of the tables that I am copying.
With an initial db2look to get the DDL to create the objects that I am
copying as to have them land in the correct tablespaces.  Along with
doing the export/imports have them run on with a cron job.  We are
running AIX 5.1 and DB2 7.2 FP8.



Mon, 27 Jun 2005 05:56:18 GMT
 alternative to Replicating data between two DB2 Databases...

can't you replicate from a view over the base table?

PM



Mon, 27 Jun 2005 21:44:44 GMT
 alternative to Replicating data between two DB2 Databases...
Murle,

Not done it for real myself, but the fastest/most elegant solution could
be online split mirror ?

http://www7b.software.ibm.com/dmdd/library/techarticle/0204quazi/0204...

Everything else is too much like hard work ! :-)

Paul.

Quote:

> We have created a Prod and Test database.  The prod one is the one
> that we made first.  I am trying to copy the prod tables to the test
> database.  I figured that Replication would be good to use here, but
> then I ran into the dreaded Column name > 18 characters issue for
> replication.  We have a ton of these tables and a ton of columns that
> have > 18 characters for the column name.  So it looks like that I
> will not be able to use the DB2 replication to copy the changes from
> one DB to the other.

> Wondering if anyone else has encountered this problem.  What other
> options are there to copy the data over.  I am thinking that it would
> have to be an export and then import of the tables that I am copying.
> With an initial db2look to get the DDL to create the objects that I am
> copying as to have them land in the correct tablespaces.  Along with
> doing the export/imports have them run on with a cron job.  We are
> running AIX 5.1 and DB2 7.2 FP8.



Mon, 27 Jun 2005 22:50:13 GMT
 alternative to Replicating data between two DB2 Databases...

Replication will be expensive in terms of performance in your
scenario ..

EXPORT/IMPORT sounds the best option ... In case, you have something
like UPDATED_TIMESTAMP in your source tables, you can do an
'incremental' export/import operation

Cheers

Sathyaram
Originally posted by Murle Meetze

Quote:
> We have created a Prod and Test database.  The prod one is the one
> that we made first.  I am trying to copy the prod tables to the test
> database.  I figured that Replication would be good to use here, but
> then I ran into the dreaded Column name > 18 characters issue for
> replication.  We have a ton of these tables and a ton of columns that
> have > 18 characters for the column name.  So it looks like that I
> will not be able to use the DB2 replication to copy the changes from
> one DB to the other.

> Wondering if anyone else has encountered this problem.  What other
> options are there to copy the data over.  I am thinking that it would
> have to be an export and then import of the tables that I am copying.
> With an initial db2look to get the DDL to create the objects that I am
> copying as to have them land in the correct tablespaces.  Along with
> doing the export/imports have them run on with a cron job.  We are

running AIX 5.1 and DB2 7.2 FP8.

--
Posted via http://dbforums.com



Tue, 28 Jun 2005 08:37:09 GMT
 alternative to Replicating data between two DB2 Databases...

Quote:

> We have created a Prod and Test database.  The prod one is the one that
> we made first.  I am trying to copy the prod tables to the test
> database.  I figured that Replication would be good to use here, but
> then I ran into the dreaded Column name > 18 characters issue for
> replication.  We have a ton of these tables and a ton of columns that
> have > 18 characters for the column name.  So it looks like that I will
> not be able to use the DB2 replication to copy the changes from one DB
> to the other.

> Wondering if anyone else has encountered this problem.  What other
> options are there to copy the data over.  I am thinking that it would
> have to be an export and then import of the tables that I am copying.
> With an initial db2look to get the DDL to create the objects that I am
> copying as to have them land in the correct tablespaces.  Along with
> doing the export/imports have them run on with a cron job.  We are
> running AIX 5.1 and DB2 7.2 FP8.

Depending on how offten the data needs to be updated, a backup restore has
worked the best for us after we set up scripts to do this nightly.


Mon, 15 Aug 2005 05:36:01 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Retrieve data from two tables, from two databases, in two registered servers

2. Is this alternative way to replicate database workable ?

3. Replicating data from a billing software on two SQL Servers

4. Move data from one DB2 database to another DB2 database

5. Data Transfer Between Two Databases on Two Different Servers

6. Merging records between two non-replicated databases

7. Replicating two servers into one database

8. Merging records between two non-replicated databases

9. Replicating data between Oracle and DB2

10. Replicate data from DB2 to MySQL

11. Moving a Access replicated database to a MSDE replicated database

12. Replicating database from DB2 to SQL Server


 
Powered by phpBB® Forum Software