Professional Web Applications Themes

iSeries tion to Windows - Part II - IBM DB2

Hi All; As usual any help GREATLY appreciated, but may require iSeries specialist... I have DataPropogator v8.1 installed on the iSeries box with source databases. I am connecting from Windows box with DB2 Connect and using tion Center to set up sources on iSeries and targets on the local (Windows) server. Do I need DataJoiner to move the data from iSeries, or does tion Center and DB2 Connect give me everything I need? I'm trying to use the configuration described in a recent announcement letter (URL below - beware of wrapping). http://www2.ibmlink.ibm.com/cgi-bin/master?xh=vF$G26MjQoT7f82USenGnN9332&request=annou ncements&parms=H%5f202%2d125&xhi=usa%2emain&xfr=N Help?!...

  1. #1

    Default iSeries tion to Windows - Part II

    Hi All;
    As usual any help GREATLY appreciated, but may require iSeries
    specialist...
    I have DataPropogator v8.1 installed on the iSeries box with source
    databases. I am connecting from Windows box with DB2 Connect and using
    tion Center to set up sources on iSeries and targets on the
    local (Windows) server.

    Do I need DataJoiner to move the data from iSeries, or does
    tion Center and DB2 Connect give me everything I need?

    I'm trying to use the configuration described in a recent announcement
    letter (URL below - beware of wrapping).
    http://www2.ibmlink.ibm.com/cgi-bin/master?xh=vF$G26MjQoT7f82USenGnN9332&request=annou ncements&parms=H%5f202%2d125&xhi=usa%2emain&xfr=N

    Help?!
    Pete Guest

  2. #2

    Default Re: iSeries tion to Windows - Part II

    You don't say what your target database is. Assuming it is DB2 on Intel/UNIX/Linux, you do not need Datajoiner (Datajoiner ... and now DB2
    Information Integrator ... are only for heterogeneous data source access). However (again assuming that DB2 on Intel/UNIX/Linux is your
    target), you do need a database and Data Propagator Apply on your target system (actually ... you can use an Apply program on the source
    system to "push" the updates out as an alternative, but a pull is preferred). This is not supplied by DB2 Connect.

    Larry Edelstein

    Pete H wrote:
     

    Larry Guest

  3. #3

    Default Re: iSeries tion to Windows - Part II

    Hi Larry;
    Thanks very much for the response - VERY helpful. My target DBs are on
    the Windows server that Connect is on. Based on the preferred "pull"
    configuration, do need DataPropagator on the iSeries box? Can I "pull"
    from iSeries sources using Connect using Capture and Apply definitions
    using tion Center on the Windows box? Or is DataPropagator
    required on both platforms?

    I'm really trying to understand the proper configuration for the
    simplest way to accomplish the movement of DB2 data from iSeries to
    Wintel. I've spent ALOT of time looking at multiple IBM doc sources,
    but so much is changing with V8 and iSeries V5R2 taht I find myself
    getting confused. I REALLY appreciate your response and if there's
    some single piece of doc I'm missing.

    Pete H


    Larry Edelstein <com> wrote in message news:<com>... 
    >
    > --[/ref]
    Pete Guest

  4. #4

    Default Re: iSeries tion to Windows - Part II

    Pete,

    DB2 Connect is merely a "transport" or connectivity mechanism and does not perform tion. It is a required prereq for movement of data
    from i-series to Intel/UNIX/Linux. You still didn't say what your target data source is on Windows. If they are DB2, you don't need Datajoiner
    or Information Integrator. DB2 Connect has nothing else to do with tion other than tion uses it to communicate.

    There are two types of tion supported by DpropR: Complete Refresh (completely replace the contents of the target table with the contents
    of the source table) and incremental updates/update propagation (capture updates to a given table as they occur and propagate them to the
    target). If you want to do update propagation, DataPropagator Capture is required on the iseries box. Based on the pull configuration,
    DataPropagator Apply is required on the target box. In either scenario, you can use the tion Center on the Windows box to create
    definitions.

    Hope this helps.

    Larry Edelstein

    Pete H wrote:
     
    > >
    > > --[/ref][/ref]

    Larry Guest

  5. #5

    Default Re: iSeries tion to Windows - Part II

    Hi Larry;
    I finally found the answer to all of my questions. The magic redbook
    is "A Practical Guide to DB2 UDB tion V8". It fills in all of
    the gaps between recent announcements, the tion Guide and
    various white papers that had my head spinning. Thanks again for your
    help, but I THINK I have the resource I need now.

    Pete H
    Larry Edelstein <com> wrote in message news:<com>... 
    >
    > --[/ref]
    Pete Guest

Similar Threads

  1. Coldfusion and iSeries
    By Bob_Johnson in forum Coldfusion Server Administration
    Replies: 4
    Last Post: December 12th, 02:01 PM
  2. is flash player an integrated part of windows ?
    By MMD3111 - Felix Sanchez - Erhvervsakademi Midtjylland in forum Macromedia Flash
    Replies: 2
    Last Post: January 12th, 10:16 PM
  3. Replies: 2
    Last Post: September 19th, 01:12 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139