469,943 Members | 2,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

sort of replication (how to)

hi,
i have db2 8.2
My problem i need to copy a set of tables (~500 - 40Go) from the production
database to the integration database by script every sunday. The name of the
database are not the same.
In production database i have ~2000 tables (50Go).
There are foreign key between the tables but there are comprised in the set
of tables.

So which is the best way to do this ?

1) i can't use db2 replication (don't ask me why...)
2) i thought to isolate the set of tables in particular tablespaces and the
backup only the tablespaces and then restore them in the ingreatio database,
but i don't know if it is possible ( like oracle transportable tablespaces)
3) export the set of tables, then load them in the ingreation database to
bypass the FKs and then set integrity
4) export important tables from integration database, backup the prod db,
restore the prod db over the integration db, and then import/replace the
important tables i've exported earlier

any opinion or advice ?

thx

Jan 22 '07 #1
1 1315
Nr 2) won't work, because you can only restore a tablespace to the
original tablespace.
Nr 3) will work.
You can also use federated access for a INSERT ... SELECT.
The advantage is, that you don't need file space for the export/load.
You can access the table data directly (federated system).
paul wrote:
hi,
i have db2 8.2
My problem i need to copy a set of tables (~500 - 40Go) from the production
database to the integration database by script every sunday. The name of the
database are not the same.
In production database i have ~2000 tables (50Go).
There are foreign key between the tables but there are comprised in the set
of tables.

So which is the best way to do this ?

1) i can't use db2 replication (don't ask me why...)
2) i thought to isolate the set of tables in particular tablespaces and the
backup only the tablespaces and then restore them in the ingreatio database,
but i don't know if it is possible ( like oracle transportable tablespaces)
3) export the set of tables, then load them in the ingreation database to
bypass the FKs and then set integrity
4) export important tables from integration database, backup the prod db,
restore the prod db over the integration db, and then import/replace the
important tables i've exported earlier

any opinion or advice ?

thx
Jan 23 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by HJ | last post: by
3 posts views Thread by dlesandrini | last post: by
9 posts views Thread by David W. Fenton | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.