Re: COBOL and DB2 vs. Java and DB2
- From: "Judson McClendon" <judmc@xxxxxxxxxxxxx>
- Date: Sun, 16 Sep 2007 08:59:05 -0500
"Charles Hottel" <chottel@xxxxxxxxxxxxx> wrote:
What I find particularly interesting in this regard is that the specifications for the new system say 95% of the transactions must
be processed in 30 seconds, and 99% of the transactions must be processed in 60 seconds. Wow! To say I am underwhelmed is a gross
understatement! Currently using COBOL and Datacomm/DB we process transactions in less than one second. This is from the time the
transaction (a message) is removed from the queue (MQSeries is used) until the time when the reply is placed onto the outbound
queue. If this is modernization then I just don't see the point especially when it is costing 300+ million a year. Or many
making money is the point!
In the situations I am familiar with, traditional mainframe databases blow
the doors off SQL type approaches. Whoever designed SQL must have
been entirely clueless, or indifferent, to machine efficiency.
Last year the State of Alabama went from a mainframe based driver's
license system to a client server based SQL system. Processing times went
from about a second to several *minutes*.
About seven years ago the local county commission decided to "dump the
mainframe and go strictly client/server and Oracle." After seven years and
nearly $100 million, the mainframe still does at least 95% of the processing.
Plans to scrap the mainframe have been abandoned for the foreseeable
future. I don't think it's because they learned anything, but the county is
having serious money problems, and they simply can't afford to keep
throwing money at it.
--
Judson McClendon judmc@xxxxxxxxxxxxx (remove zero)
Sun Valley Systems http://sunvaley.com
"For God so loved the world that He gave His only begotten Son, that
whoever believes in Him should not perish but have everlasting life."
.
- Follow-Ups:
- Re: COBOL and DB2 vs. Java and DB2
- From: Robert
- Re: COBOL and DB2 vs. Java and DB2
- References:
- COBOL and DB2 vs. Java and DB2
- From: Charles Hottel
- COBOL and DB2 vs. Java and DB2
- Prev by Date: Re: COBOL and DB2 vs. Java and DB2
- Next by Date: Re: COBOL and DB2 vs. Java and DB2
- Previous by thread: Re: COBOL and DB2 vs. Java and DB2
- Next by thread: Re: COBOL and DB2 vs. Java and DB2
- Index(es):
Relevant Pages
|