Ims vs db2 who is faster




















The department of corrections has to undergo constant changes due to legislative mandates, court orders, and user requests, such as workers needing better ways to track offenders, including inmates and parolees. In IMS, changes are too slow. The department of corrections needed to move to Db2 so that they could make all of these changes quickly and safely.

Now all future development can be done using existing program calls. Db2 makes it easier to access the data due to the hierarchical way data has to be accessed in IMS. In IMS, you essentially have to drill down to find the data.

This software makes the migration process less risky. Learn how to leverage your mainframe for maximum value. Cloud migration projects are happening in virtually every large enterprise throughout the world, and in many small and midsize companies as well. For most, cloud data migration is an ongoing journey, In fact, we know customers who have run their production IMS system for many years with no interruptions at all.

The latest analyst figures for comparative availability show mainframes at How much does it cost your company per hour for critical applications to be offline? In the IMS world, we are used to sub-second response time and find it amazing that people are satisfied with response times measured in seconds or even longer.

Not only are long response times annoying, they are also a major waste of user productivity and money. Returning to cost estimates, if you accept that a fair cost comparison should take account of time wasted because a computing system is slow to respond, Arcati, in the report referenced earlier, has estimated the following five-year costs per end user:. Arcati has compared its results with other analysts, and there is universal agreement that the mainframe costs are or less than the alternatives.

We have seen that moving off IMS to a distributed world does not improve performance. How about moving to DB2? Is it worth the effort of converting all your application code, databases, and operating procedures? The simple answer is no. The only time that IMS falls down in comparison is ad hoc query, and the way to counter this is to run an extract from IMS at regular intervals and use this extract for the reporting.

IMS was designed to be an extremely high performance, online transaction processing system, and it has delivered on that promise from the beginning. Another reason for moving to DB2 in the past was that IMS had a limit on database size, but this limitation has now been removed with the introduction of partitioning in IMS.

One of the reasons that IMS was designed in the first place was integrity. The whole ethos of mainframe database management systems is that you will never lose your data. We have helped customers recover from disasters over the years, and we have never failed to recover the IMS data, using a combination of IMS and vendor tools. Furthermore, IMS now enables you to share across multiple systems with complete integrity - which is not trivial, considering the realm of multiple systems updating shared database records, a common scenario.

This sharing is only possible if you have the following mechanisms in place:. And here is my short response:. The benefit of sticking with IMS is the good performance you currently enjoy as well as no need to convert the database structures or the 7 million lines of application code.

Converting database structures is not horribly difficult, but there are some gotchas that can arise. This will not be a simple 1 to 1 conversion and it will very likely be quite time-consuming. DB2 optimizes queries internally whereas IMS programmers construct access paths to data. But, of course, that additional CPU brings with it the enormous benefit of database optimization and better ad hoc query support. I have never used it so I cannot recommend for or against its functionality, but it looks like it might save you some work.

Craig Mullins. Thanx in advance. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options.



0コメント

  • 1000 / 1000