Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    57

    Unanswered: One instance,two databases - moving data from one to another

    Hello all,

    I have a question about posibility of "connecting" data between two databases under the same instance.

    AIX 5.x
    DB2 v 7.1 fix 7

    For example is it possible to do select from one db and in the same time importing selected data into another db. Or select that connects datas from two different db under the same instance?

    Thanks in advance,
    Nicole

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

    Re: One instance,two databases - moving data from one to another

    Setting up Federated databases is a possible solution ...

    But remember, you need to have suffiecient log space to select all rows from one table and inserting into another in a single unit of work ...

    I would prefer to do an export and load/import or db2move



    HTH

    Sathyaram

    Originally posted by NNicole
    Hello all,

    I have a question about posibility of "connecting" data between two databases under the same instance.

    AIX 5.x
    DB2 v 7.1 fix 7

    For example is it possible to do select from one db and in the same time importing selected data into another db. Or select that connects datas from two different db under the same instance?

    Thanks in advance,
    Nicole
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Posts
    57

    Thanks

    Thank you...
    I'm going to look at manuals how to do it...

    Cheers,
    Nicole

Posting Permissions

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