Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2003
    Posts
    127

    Unanswered: Remote export/import ...

    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?

  2. #2
    Join Date
    Jun 2003
    Posts
    127
    I think even Federated load has the same issue of password being exposed.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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>".
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2003
    Posts
    127
    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.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The password is stored encrypted at the federated server.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jun 2003
    Posts
    127
    Thanks Knut.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •