Transfering data tables between two remote databases

[b***@hotmail.com]

Hi,

Could you describe the procedure to copy data tables in
a remote database and store them in another remote database?


Thank you.

[Larry]

Post by b***@hotmail.com
Hi,
Could you describe the procedure to copy data tables in
a remote database and store them in another remote database?
Thank you.

Can you provide more detail as to exactly what you mean by "copy"? What
are the requirements?

Larry E.

[Mark A]

Post by b***@hotmail.com
Hi,
Could you describe the procedure to copy data tables in
a remote database and store them in another remote database?
Thank you.

If you just want the data, then look at the db2move command in the Command
Reference manual.

[Knut Stolze]

Post by b***@hotmail.com
Hi,
Could you describe the procedure to copy data tables in
a remote database and store them in another remote database?

If you want to do this via SQL statements and no utilities, then this would
be one way (assuming you have a proper federated setup):

INSERT INTO <nickname1>
SELECT ...
FROM <nickname2>

[Mark A]

Post by Knut Stolze
If you want to do this via SQL statements and no utilities, then this would
INSERT INTO <nickname1>
SELECT ...
FROM <nickname2>
--
Knut Stolze

Unless the tables are small, it might be too much data for a single unit of
work (no intermediate commits).

[Knut Stolze]

Post by Mark A

Post by Knut Stolze
If you want to do this via SQL statements and no utilities, then this would
INSERT INTO <nickname1>
SELECT ...
FROM <nickname2>

Unless the tables are small, it might be too much data for a single unit
of work (no intermediate commits).

Yes, of course. Breaking down this statement into a loop with intermediate
commits doesn't change anything significantly at this approach.

p.s: You could also increase the log size sufficiently -
whatever "sufficiently" would be in this case. ;-)

[Kelly Schlamb]

Again, assuming federated is setup, I think you could probably do a "load from cursor" rather than an insert/select. Logging should be minimal.

declare loadcurs cursor for select * from sourceTable
load from loadcurs of cursor insert into targetTable

Regards,
Kelly Schlamb