Similat to db2move, I remotely catalog a database on the target server. Then extract source data from target itself (to avoid ftp,scp ...). Then locally load/import. Is there a way to encrypt the passwd during export on the remote server?

I think even Federated load has the same issue of password being exposed.

You don't do an export on the remote server - you do it at the federated server. Under the covers, the data happens to be extracted from the remote server.

However, have you considered avoiding the dumping to a file at the federated server (what you call target server)? You can do a simple "insert into ... select ... from <nickname>".

Thanks for responding. When I meant export on the target side, I was planning to dump the exported(ixf or del) files on the target server. I agree with you about the Federated server setup. Isn't the password visible in Federated as well? Just looking to see if there is any alternate process where the password is not visible.

The password is stored encrypted at the federated server.

Thanks Knut.