Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    16

    Question Unanswered: transferring data from DB2/LINUX to DB2/NT

    Hi,
    My OLTP database lies in DB2/LINUX and my OLAP database lies in DB2/NT.Now,I need to transfer data from just some specific columns of tables from OLTP to OLAP.How do I go abt it?Any ideas??

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

    Re: transferring data from DB2/LINUX to DB2/NT

    What do you mean by transfer ?

    Is it a one time process ? Or do you want to do it on a daily basis ? Or do you want it near 'real-time' ?

    For the first two cases, you can use EXPORT on OLTP and IMPORT/LOAD on the OLAP ...

    For the third case, you can use DB2 Replication ..

    You will need to provide more details for people here to provide more information

    HTH

    Sathyaram


    Originally posted by sarah28
    Hi,
    My OLTP database lies in DB2/LINUX and my OLAP database lies in DB2/NT.Now,I need to transfer data from just some specific columns of tables from OLTP to OLAP.How do I go abt it?Any ideas??
    Last edited by sathyaram_s; 07-16-03 at 05:35.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Re: transferring data from DB2/LINUX to DB2/NT

    I think if you want to transfer data from OLTP to OLAP it will be a daily process. So you have to use the replication with the capture and apply program (data propagator),

    Rui

Posting Permissions

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