Re: Speaking of ( real ) Databases

    Hi Mike,

    Well, ask a stupid question...  My question, if that wasn't clear.

"DB2 Express-C for Linux and Windows Edition specific information" at

    http://www-306.ibm.com/software/data/db2/udb/edition-expressc.html

clearly states that Replication Data Capture, included in the for-purchase
version, is not included in DB2 Express-C.  I expect you'd have to look
around for an IBM/third party product or write your own, as in the DRDA
suggestion form Michael.  The latter would take some effort to get it right.

    There is a forum at:

http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=805&cat=19

and an entire DB2 zone at developerWorks that may be helpful.  Keep in mind
that DB2 Express-C was just announced.  Also, "Comparing the distributed DB2
UDB servers" at:

http://www-128.ibm.com/developerworks/db2/library/techarticle/0301zikopoulos/0301zikopoulos1.html

may be worth a review.

    I'll stay out of the politics, other than leave everyone to give their
own response to

> since they said that server was already too flaky

    Good luck!


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Mike Cunningham" <MCUNNING@xxxxxxx>
To: "Joe Shirah" <jshirah@xxxxxxxxxxxxx>
Sent: Tuesday, January 31, 2006 11:22 AM
Subject: Re: Speaking of ( real ) Databases


> Two issues. We do nightly backups like most iSeries shops and when we do
> that we shutoff all access to everything. We also install PFTs, a
> monthly savsys, and usually 24 hours for a release update once a year.
> The web group wants to have apps running 24x7x365. So we went the data
> replication via upload/download so the web apps can run when the iSeries
> is offline.
>
> Second issue is political. Our web team (they do not work for ITS)
> insists on using FrontPage and from what I have seen FrontPage does not
> play nice in any world other than SQL Server. I wanted to create some
> stored procedures in DB2/400 that the web team could run in a FrontPage
> app but no one here could get FrontPage to execute stored procedures
> from any database other than SQL Server. ODBC was an option but our
> server group was not thrilled about installing Client Access on the IIS
> server since they said that server was already too flaky and the web
> team are not programmers and I really do not want to expose the database
> to them as would be required with ODBC.
>
> If I could show DB talking with DB I think I could get both these
> groups to move to something that is more open. Dreamweaver or Cold
> Fusion and maybe Apache on Windows and relieve some of the strangle hold
> MS has and continues to tighten.
>
> >>> "Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx> 1/31/2006 10:24:05 AM >>>
>
>
>     Hi Mike,
>
>     I don't know your requirements, but clearly you'll have to write
> data
> access code whether you use DB2, SQL Server or something else.  I
> assume you
> have, um, blockage there, but wouldn't the cleanest, and probably more
> secure, thing be to access the AS/400 database directly?
>
>
>                                                          Joe Sam
>
> Joe Sam Shirah -        http://www.conceptgo.com
> conceptGO       -        Consulting/Development/Outsourcing
> Java Filter Forum:       http://www.ibm.com/developerworks/java/
> Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
> Going International?    http://www.jguru.com/faq/I18N
> Que Java400?            http://www.jguru.com/faq/Java400
>
>
> ----- Original Message ----- 
> From: "Mike Cunningham" <MCUNNING@xxxxxxx>
> To: <jshirah@xxxxxxxxxxxxx>; "Java Programming on and around the
> iSeries /
> AS400" <java400-l@xxxxxxxxxxxx>
> Sent: Tuesday, January 31, 2006 8:45 AM
> Subject: Re: Speaking of ( real ) Databases
>
>
> > Does anyone know if a Windows DB2 database (like this free one) can
> be
> > synced up with an iSeries DB2 database ?  e.g. define tables that
> when
> > changed in one DB are automatically replicated in the other DB. We
> have
> > a bunch of processes where we FTP data down from our iSeries to a
> > windows server to be served up by IIS. We also have some IIS asp
> apps
> > that collect data on forms that we then upload to the iSeries. DB
> syncs
> > would eliminate both these processes. If DB2 databases can be synced
> I
> > might be able to keep SQL server out of our shop, at least for
> inhouse
> > developed applications
> >
> > >>> jshirah@xxxxxxxxxxxxx 1/31/2006 8:31 AM >>>
> >
> >
> > Update: IBM Frees DB2 Express
> >
>
http://www.computerworld.com/databasetopics/data/software/story/0,10801,108192,00.html
> >
> >
> >                                                          Joe Sam
> >
> > Joe Sam Shirah -        http://www.conceptgo.com
> > conceptGO       -        Consulting/Development/Outsourcing
> > Java Filter Forum:       http://www.ibm.com/developerworks/java/
> > Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
> > Going International?    http://www.jguru.com/faq/I18N
> > Que Java400?            http://www.jguru.com/faq/Java400
> >
> >
>
>
>