ca.portal.admin

Re:Re: DB2 vs. IDMS

Discussion created by ca.portal.admin on Nov 28, 2006
Hi Jim,

Check with Greg Beedy, CA. During his Federal Gov't webcast, today, he
mentioned a conversion from one IDMS CV requiring nearly 100 DB2
regions.

He's in the Framingham office.


Take Care,
Bruce
NAVSISA - (717) 605-2019 DSN 430-2019
Cell - (610) 468-9506

________________________________

From: IDMS Public Discussion Forum on behalf of Ritterbusch, James (GE
Comm Fin)
Sent: Tue 11/28/2006 4:28 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: DB2 vs. IDMS



One of our Applications staff is trying to justify converting some
applications from DB2 to IDMS. In the past, conventional wisdom
suggested that the CPU and I/O costs were substantially lower by using
IDMS than by using DB2.

However, management don't want to know about wisdom, they want hard and
fast numbers. Has anybody done any recent benchmarks of the costs of
performing an equal unit of work on IDMS versus DB2? Of course, I know
that our mileage will vary, but any numbers would be greatly
appreciated.

If anybody can reply but wishes to protect their identity, feel free to
reply to me off-list and just say that you prefer confidentiality.
MailTo:james.ritterbusch@ge.com

Thanks,

Jim Ritterbusch Mail:
GE Capital Solutions 10 Riverview Dr.
101 East Ridge Danbury, CT 06811

T 203.749.3585 F 203.749.4016
D 8*662.3585 E james.ritterbusch@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB2 vs. IDMS
"Hi Jim,

Check with Greg Beedy, CA. During his Federal Gov't webcast, today, he mentioned a conversion from one IDMS CV requiring nearly 100 DB2 regions.

He's in the Framingham office.


Take Care,
Bruce
NAVSISA - (717) 605-2019 DSN 430-2019
Cell - (610) 468-9506

________________________________

From: IDMS Public Discussion Forum on behalf of Ritterbusch, James (GE Comm Fin)
Sent: Tue 11/28/2006 4:28 PM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: DB2 vs. IDMS



One of our Applications staff is trying to justify converting some
applications from DB2 to IDMS. In the past, conventional wisdom
suggested that the CPU and I/O costs were substantially lower by using
IDMS than by using DB2.

However, management don't want to know about wisdom, they want hard and
fast numbers. Has anybody done any recent benchmarks of the costs of
performing an equal unit of work on IDMS versus DB2? Of course, I know
that our mileage will vary, but any numbers would be greatly
appreciated.

If anybody can reply but wishes to protect their identity, feel free to
reply to me off-list and just say that you prefer confidentiality.
MailTo:james.ritterbusch@ge.com

Thanks,

Jim Ritterbusch Mail:
GE Capital Solutions 10 Riverview Dr.
101 East Ridge Danbury, CT 06811

T 203.749.3585 F 203.749.4016
D 8*662.3585 E james.ritterbusch@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
DB2 vs. IDMS
"One of our Applications staff is trying to justify converting some
applications from DB2 to IDMS. In the past, conventional wisdom
suggested that the CPU and I/O costs were substantially lower by using
IDMS than by using DB2.

However, management don't want to know about wisdom, they want hard and
fast numbers. Has anybody done any recent benchmarks of the costs of
performing an equal unit of work on IDMS versus DB2? Of course, I know
that our mileage will vary, but any numbers would be greatly
appreciated.

If anybody can reply but wishes to protect their identity, feel free to
reply to me off-list and just say that you prefer confidentiality.
MailTo:james.ritterbusch@ge.com

Thanks,

Jim Ritterbusch Mail:
GE Capital Solutions 10 Riverview Dr.
101 East Ridge Danbury, CT 06811

T 203.749.3585 F 203.749.4016
D 8*662.3585 E james.ritterbusch@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
IDMSIN01 return codes
"Where can I find the meanings of the return codes from IDMSIN01?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB2 vs. IDMS
"Oh, I am not so sure Jim, some data navigations are pretty hard to
translate into one size fits all SQL, regardless whether it's DB2 and
all. There is a lot more overhead, especially when it comes to
security, that SQL does for validation then IDMS. Even the security
overhead in IDMS SQL can be a handful. Couple that with a high
transaction load, high volume data access, a dynamic sql gui based app
replacing purpose built legacy code and I can imagine applications where
SQL, not necessarily DB2, would require 100 times more overhead.

Lutz Petzold



-----------------------------------------
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB2 vs. IDMS
"Lutz, Who said anything about one size fits all SQL? I am talking
about taking the functionality of an IDMS app and implementing the same
functionality in a DB2 app. If you start throwing in dynamic sql and
gui front-ends of course it's going to have more overhead. You CAN
purposely build DB2 applications......it just isn't done very often. I
will agree that IDMS does force you to know a little more about what
you're doing but, sad to say, that is not always seen as a plus.

Outcomes