RE: Replication between as/400 and Sql Server 2000

["Lopez, Eduardo (Tijuana)" <lopeze@xxxxxxxxxxxxxxxxx>]

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.
>