copy db2 tables from region to region

[Yosef]

I need to copy a production table to the acceptance region. The tables
exist already in both regions, we just want to update the data in acpt with
that in prod.
We are running DB2 v 6 on MVS 390.
Is there any way to simply do this without a copy/recover? I just want to
move data.

Thanks!

[Mark A]

Re: copy db2 tables from region to region

"Yosef" <jbcotton@earth link.net> wrote in message
news:YEHjb.5935 6$mQ2.14779@new sread1.news.atl .earthlink.net. ..[color=blue]
> I need to copy a production table to the acceptance region. The tables
> exist already in both regions, we just want to update the data in acpt[/color]
with[color=blue]
> that in prod.
> We are running DB2 v 6 on MVS 390.
> Is there any way to simply do this without a copy/recover? I just want to
> move data.
>
> Thanks!
>[/color]
You mean different DB2 subsystems? If you have DDF (distributed data
facility) between the two you should be able to that. Contact your DB2 DBA
or DB2 systems administrator to see is DDF is installed between the
sub-systems, and then check out the manuals for how to use it in a single
SQL statement.

However it will not perform as well as using unload/load (where the unload
was taken from an image copy). You would not use recover to do this.