Re: yipeee!
From: Mike <mikee_at_mikee.ath.cx>
Date: Wed, 04 Feb 2004 20:13:58 -0000
Message-ID: <1022kk6o1ko4r89_at_corp.supernews.com>
>
> Is HA a real requirement, or just a nice-to-have? Because if you can
> live with something like 99.9% availability then perhaps log-shipping
> would suffice and you might be able to set up a db2 udb prototype in a
> single afternoon. If it's one of those rare applications that really
> needs 99.999% well then you've got some real work ahead - regardless
> of the product chosen.
>
> Oracle has more functionality and capability here but it's more
> expensive, more complex/error-prone to use, and while i'm not sure of
> RAC, OPS was a manageability nightmare. Still, for many situations it
> is great.
>
> However - one more thing: I find that my database choices usually
> hinge more on the strategic direction of the company - rather than on
> the specific needs of the application. If you go
> application-by-application you'll end up with a half-dozen different
> databases, and the skillset problem that results is typically more
> challenging than the minor technical differences between commercial
> databases.
Date: Wed, 04 Feb 2004 20:13:58 -0000
Message-ID: <1022kk6o1ko4r89_at_corp.supernews.com>
[Quoted] In article <66a61715.0402041122.27cdc560_at_posting.google.com>, Buck Nuggets wrote:
> Mike <mikee_at_mikee.ath.cx> wrote in message news:<10220krn5h7jh4a_at_corp.supernews.com>...
>> Just recieved a 'thought experiment' assignment from my boss. >> Does it make sense, and how would it be accomplised, to move >> the databases from the mainframe (small VSE 390?) to AIX? >> I mentioned that we should then look at possible programs from >> IBM to convert the mainframe database (VSAM?) files into DB2/AIX, >> or Oracle databases. And that I thought Oracle had some facility >> such that we could cluster and load-balance two+ nodes running >> something like Parallel Oracle so that should a node need booting >> or modifying off-line the application is still running (at >> reduced capacity) for the users.
>
> Is HA a real requirement, or just a nice-to-have? Because if you can
> live with something like 99.9% availability then perhaps log-shipping
> would suffice and you might be able to set up a db2 udb prototype in a
> single afternoon. If it's one of those rare applications that really
> needs 99.999% well then you've got some real work ahead - regardless
> of the product chosen.
>
> Oracle has more functionality and capability here but it's more
> expensive, more complex/error-prone to use, and while i'm not sure of
> RAC, OPS was a manageability nightmare. Still, for many situations it
> is great.
>
> However - one more thing: I find that my database choices usually
> hinge more on the strategic direction of the company - rather than on
> the specific needs of the application. If you go
> application-by-application you'll end up with a half-dozen different
> databases, and the skillset problem that results is typically more
> challenging than the minor technical differences between commercial
> databases.
The HA is a must. That's why if I could get it to work with either oracle or db2 in this parallel fashion then I have built in HA without having to mess with IBM's HACMP on AIX.
Agreed on the strategic direction.
Turns out this would probably be a phased project. First possibly move the mainframe stuff to CICS on AIX. Then migrate the VSAM stuff outside of CICS into DB2 as a phase 2. Then re-write the CICS applications to run CICS native as a phase 3+. Received on Wed Feb 04 2004 - 21:13:58 CET