Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Post Unanswered: Transfer Data from Table A to Table B in Different Database in Different Systems

    HI ALL

    Have table A in DataBase1 on Systems1
    and table AA in Database 2 on System2

    Table A and Table AA have same structure.

    How can I transport data from Table A to Table AA without creating a datafile and importing to the the table.

    What are the various options that I can utilizes to transfer data ?

    Please comment regarding the above ASAP.

    Thank You
    Bollin99

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Federated Database support. But export and import is a lot easier and faster than setting up Federated Support unless you are thinking of a long term solution that will be used frequently.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Transfer Data from Table A to Table B in Different Database in Different Systems

    Replication

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Feb 2004
    Posts
    24

    Re: Transfer Data from Table A to Table B in Different Database in Different Systems

    Hi,

    if your DB2 is running on os390 osr zOS and the DB2 Version is 7 or higher i think u can use the cross load functionallity, but i'm not sure about the different systems. maybe you can qualify the tables like
    system.creator.tablename within the neede incursor for the load.

    It's only an idea - i could be wrong

    regards

    marc

    Originally posted by bollin99
    HI ALL

    Have table A in DataBase1 on Systems1
    and table AA in Database 2 on System2

    Table A and Table AA have same structure.

    How can I transport data from Table A to Table AA without creating a datafile and importing to the the table.

    What are the various options that I can utilizes to transfer data ?

    Please comment regarding the above ASAP.

    Thank You
    Bollin99

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Transfer Data from Table A to Table B in Different Database in Different Systems

    Cross loader can work across systems also ..

    It can even get data from DB2 - Unix and Load into Mainframe DB2 Tables ...



    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Sep 2002
    Posts
    30

    The above Question is for DB2 Database

    Can we create unix pipes and transfer data from Table A and connect to the remote database and transfer the data ?

    Please let me know how to connect to remote database and access from the current database.

    Thank You
    Bollin99

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would assume that it is not DB2 for OS/390 or z/OS because of the mention of "database". Databases on those platforms are not seperate entities (table names have to be unique accross all databases in a sub-system).

    If it were on the mainframe, then DDF might be a possibility if it were set up.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Creating pipes does sound a good idea ... I tried it on a small table and it works ... But make sure you test it before doing anything for producton ..

    For your other question, search the manuals for Federated Databases ..
    The steps will be to define a wrapper, server, usermapping and a nickname ,

    Cheers
    Sathyaram




    Can we create unix pipes and transfer data from Table A and connect to the remote database and transfer the data ?

    Please let me know how to connect to remote database and access from the current database.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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