Cobol - Re: OT (Maybe): ERPs

Author

Re: OT (Maybe): ERPs

Frank Swarbrick

2005-01-28, 8:55 pm

jce<defaultuser@hotmail.com> 1/27/2005 11:16:15 PM >>>
>A great example is at my location before I arrived there was an IMS to DB2

>migration. The old IMS code was rewritten to "work". It runs like a dog
>because it still accesses the data in a hierarchical and not relational
way.
>We are still finding instances of open cursor a to get b...open cursor b
to
>get c ....open cursor c to get the answer....where DB2 could handle this
>much more efficiently as a combination of joins.

This bit is certainly discouraging. Our new Chief Technology Officer (who
was in charge of the "distributed applications" and network side and is now
also over the mainframe side) has us to looking at converting from DL/I
(IMS, but for VSE) to a RDBMS. On the surface it sounds great -- I'd love
to have a relational database system. But I have a hard time imagining
coverting hundreds of programs. First of all it seems pretty much
"impossible" on its surface, at least unless you stop all other development
on the system until the conversion is complete. Second, do you really want
people who are used to only a hierarchical database doing the conversion?
We'd probably end up in the same position your company did.

Anyway, with all of that said I'd be curious as to the effort involved at
your shop, and if in the end it was determined to be worth doing.

---
Frank Swarbrick
Senior Developer/Analyst - Mainframe Applications
FirstBank Data Corporation - Lakewood, CO USA

Howard Brazee

2005-01-31, 3:55 pm

On 28-Jan-2005, "Frank Swarbrick" <Frank.Swarbrick@efirstbank.com> wrote:

> Second, do you really want
> people who are used to only a hierarchical database doing the conversion?

If the database is designed right, what difference does this make?

Sponsored Links