grant.epstein

DB2 to IDMS

Discussion created by grant.epstein on Aug 7, 2014
Latest reply on Aug 12, 2014 by grant.epstein

Tired of hearing that IDMS is a dinosaur, we decided to buck the trend and recently converted our DB2 databases & batch applications to IDMS SQL. Overall the process was rather simple and the code changes minimal. The only down side was the need to create additional indexes that contained all the columns in the predicate in order to maintain performance. The driving factor behind the conversion was cost, since we already had our main applications running in IDMS.

Outcomes