hi

Moving large data (number of tables) from one server to another server. Different database, db2 move or declare cursor would be the best option.

Catalog the source db in target server and we can use this option ?

declare c1 cursor database dbname user username password pwd
select * from tabname
load from c1 of cursor insert into tabname nonrecoverable.

regds
Paul

you can not connect to server-a and read data from server-b
you need to setup federated (free for db2 source)
and work on nicknames..

hello sir,

if for example server a and server b,
server a is cataloged in server b in that case can we use this
declare c1 cursor database dbname user username password pwd
select * from tabname
load from c1 of cursor insert into tabname nonrecoverable.

Coz doc says this.

Ease of use
There is no need to enable federation, define a remote datasource, or declare a nickname. Specifying the DATABASE option (and the USER and USING options if necessary) is all that is required. While this method can be used with cataloged databases, the use of nicknames provides a robust facility for fetching from various data sources which cannot simply be cataloged. To support this remotefetch functionality, the load utility makes use of infrastructure which supports the SOURCEUSEREXIT facility. The load utility spawns a process which executes as an application to manage the connection to the source database and perform the fetch. This application is associated with its own transaction and is not associated with the transaction under which the load utility is running.

regds
Paul

if the doc indicates this = ok
I can see it is documented in detail in the datamovement guide.....
so what was your question about ...or just an indication that you have read the book and found something we did not know about ? to check us out ..

no sir,

actually there is upcoming work related to migration of windows to aix the db2, so was checking out all possibility of data movement, Currently i don't have any dev server to check this, just went thru the doc and wanted know any one has used this way too.

So just posted what the doc was saying.

regds
Paul

Hi Paul,

yes, both ways are possible. I used both methods to replicate data from prod to test-environment. For the "declare cursor" you need to configure federation first, but it's a lower consumption of resources.

hi nvk,

thks for your reply, actually the discussion was for the later option in which if ur db is cataloged in another db2 server, there is no need to configure federation i believe you can use.
declare c1 cursor database dbname user username password pwd
select * from tabname
load from c1 of cursor insert into tabname nonrecoverable.
not sure coz i have not chked this.
regds
Paul

Hi Paul,

it seems to be there, but it's not documented. There's an option in the LOAD using ADMIN_CMD.
LOAD using ADMIN_CMD

I've never worked with it.

Tried the same from command line, and it works