RE: Replication between as/400 and Sql Server 2000

Make your administrator disappear? :)

In reality whatever method you choose will have some impact on the machine,
after all
you are implementing a new process or application.  What ever method you
choose will still
take some processing power.  Ultiimately, I guess you will have to 'sell'
the chosen method to your internal
people.

Journalling is relatively easy to set up without extra programming, requires
little maintenance and will also provide better protection of your data
against machine failure.  The extra overhead of journalling is primarily on
your disks and the correct configuaration can reduce that.  Some of the
overhead can be clawed back through changes in your backups as you won't
need to perform full saves if you manage your journals.

The overhead in journalling would be less than accessing your data from an
external source as you will still impact DB2 as well as consuming other
memory and processor resources when retrieving or selecting your required
data.

Regards
Nathan


-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
Behalf Of Lopez, Eduardo (Tijuana)
Sent: Friday, July 11, 2003 8:32 AM
To: 'SSA's BPCS ERP System'
Subject: RE: Replication between as/400 and Sql Server 2000


Nathan,

Well I actually don't think that journaling will impact that much the
as/400... the one that thinks it'll impact the journal is the as/400
administrator... because she has read the IBM Redbook "Striving for Optimal
Journal Performance on DB2 Universal Database for iSeries" and she concluded
that it wasn't good for our as/400... and yes I told her to reconfigure the
ASP's... but still she doesn't want to implement the journals... quite a
dilemma =)... what would you do in my case?

Regards,
Eduardo

>-----Original Message-----
>From: Nathan Bennett [mailto:nabennis@xxxxxxxxx]
>Sent: Thursday, July 10, 2003 12:31 PM
>To: SSA's BPCS ERP System
>Subject: RE: Replication between as/400 and Sql Server 2000
>
>
>What makes you think the DB journalling will impact the
>iSeries so much?
>
>I'll assume your going to 'pick' the files you want to
>replicate so it's not the entire database.  With the correct
>use of ASP's and other techniques you can reduce the impact on iSeries.
>
>Regards
>Nathan
>
>-----Original Message-----
>From: bpcs-l-bounces@xxxxxxxxxxxx
>[mailto:bpcs-l-bounces@xxxxxxxxxxxx]On
>Behalf Of Lopez, Eduardo (Tijuana)
>Sent: Thursday, July 10, 2003 3:54 AM
>To: 'bpcs-l@xxxxxxxxxxxx'
>Subject: Replication between as/400 and Sql Server 2000
>
>
>Hi to all,
>
>I have a big "dilemma"... hope somebody can help... this is my
>situation
>
>We want to built a custom data warehouse with SQL Server for
>the QMS, API and CAP modules... why use SQL Server?...
>
>   * We already have the license for SQL Server 2000
>Enterprise this means that we can use Analysis Services for
>free... the product/solutions from IBM and also from Cognos
>are very expensive!!
>   * We'll be very integrated with Microsoft Office... using
>for example Pivot Tables, the Office Web Components, etc...
>and for free because we already have the licenses for Microsoft Office
>   * The time to implement it is very short... three months!!
>   * We already have all the tools from the Windows side
>   * I'm very skilled in SQL Server
>
>
>Please follow..
>I'm evaluating a replication tool... the tool name is
>DB2Motion from Hit Software... this tool operates in two modes
>refresh and mirroring... the first one uses the DB2 Journal
>feature which is very cool because we can have in some parts
>of the data warehouse "real-time" data!! and the other mode is
>using primary keys on the tables to get the last records (not
>real-time data)... and now my "dilemma"
>
>   * I can't use the DB2 Journal feature because it'll impact
>to much the
>as/400... so this means that I can't use "real-   time"
>data... that's fine
>for now...
>   * I can't use primary keys because the BPCS tables doesn't
>have primary keys!!... Ohh my god why?
>
>the only "good" option that I can think is using the ODBC
>driver from Hit Software or the one from IBM's Client/Access
>with the Data Transformation Services (DTS) feature from SQL Server
>
>Can somebody guide me on any more options... there has to be
>another way...
>
>Thank you,
>
>Eduardo Lopez
>Software Developer
>Tyco Adhesives
>
>US Phone (San Diego, CA)
>+1  (619) 424-4244
>Mexican Phone (Tijuana, MX)
>+52 (664) 647-4359
>
>"Man finds God behind every door that science manages to open"
>"El hombre encuentra a Dios detrás de cada puerta que la
>ciencia logra abrir" Albert Einstein
>
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.
>

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.