Export/Import functionality

[Alessio Pompigna]

Hello,

I'm going to setup a basic update between two DB2 instances (ver 4 and ver
8) via the export/import functionalities .
I'm very new to DB2, so any ideas is welcome.
I'm wandering if something like incremental features exist to do this job.
What I would like to do is:

- at time t0 a full export from A is performed and loaded into B;
- at time t1 a incremental export is performed and loaded.

I could find some key field and write some sql to create a differential
export, but it would be better if a native fuctionality to do this exists.

Thanks for your support,
Alessio

[Joachim Klassen]

Re: Export/Import functionality

One way to go would be to use DB2 Replication. In short: With
Replication DB2 captures changes on your original DB2 Tables and
stores them in separate Tables. On your other DB another process
called APPLY repeatedly gets the changes and applies them to the
target Tables. See the "DB2 Replication Guide and Reference" for
Details. You'll find it at

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main#V8PDF

HTH
Joachim

"Alessio Pompigna" <alessio_pompig na@hp.com> wrote in message news:<Fl4ub.909 3$lN3.8979@news .cpqcorp.net>.. .[color=blue]
> Hello,
>
> I'm going to setup a basic update between two DB2 instances (ver 4 and ver
> 8) via the export/import functionalities .
> I'm very new to DB2, so any ideas is welcome.
> I'm wandering if something like incremental features exist to do this job.
> What I would like to do is:
>
> - at time t0 a full export from A is performed and loaded into B;
> - at time t1 a incremental export is performed and loaded.
>
> I could find some key field and write some sql to create a differential
> export, but it would be better if a native fuctionality to do this exists.
>
> Thanks for your support,
> Alessio[/color]