Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2011
    Posts
    27

    Lightbulb Answered: Load cursor from remote node

    Node 1 - One table has 500GB of data
    Node 2 - Similar table structure is create on a db
    I want to transfer the Node1's 500GB data to Node 2.
    How can do this?
    If I do this by catalog the Node 1 db on Node 2 and by load cursor whose resource will be used ? Node 1 or Node 2 ?

  2. Best Answer
    Posted by przytula_guy

    "as indicated by Mark, federation is not needed anymore - declare cursor supports dbname info for reading data from remote db
    the load/target must be local
    connect to target - declare cursor ..for remote.... - load from cursor"


  3. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Setup federation from Node2 to node1. Create nickname on node2 for table on node1. connect to node1, create cursor for select on nickname, and do load from cursor.

    You will use resources on both systems Node1 will for the data read, and Node 2 for the data write.

    Andy

  4. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Setup federation from Node2 to node1. Create nickname on node2 for table on node1. connect to node1, create cursor for select on nickname, and do load from cursor.

    You will use resources on both systems Node1 will for the data read, and Node 2 for the data write.

    Andy

  5. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    There are some details on the subject at the link below.
    http://www.ibm.com/support/knowledge.../c0005437.html
    Regards,
    Mark.

  6. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated by Mark, federation is not needed anymore - declare cursor supports dbname info for reading data from remote db
    the load/target must be local
    connect to target - declare cursor ..for remote.... - load from cursor
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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