Guest post by Mike Jones, Technical Marketing Manager
Here are some more reasons to migrate to DB2 10.
Plan stability, introduced as maintenance to DB2 9, is part of the DB2 10 base code. Plan stability makes it safer to rebind static packages after a DB2 upgrade. If performance degrades after a REBIND, you can switch back to the previous access path by running REBIND again with the SWITCH parameter.
SQL enhancements. The days of applications and data living solely on the mainframe are coming to and end. IBM recognizes this fact, and they delivered enhancements in DB2 10 that make it easier to port applications from other platforms and database management systems to DB2 for z/OS. Enhancements include faster native SQL procedure language (SQL PL), implicit casting, and more flexibility in the number of digits for fractions of seconds, timestamps with time zones, moving sums, and moving averages.
Support for DB2 V8 is ending. Moving to DB2 V8 was a daunting task for many IT organizations because V8 was so different from any previous versions of DB2. According to informal polls we have conducted, about one third of DB2 users are still on V8 and will move directly to DB2 10. Some are moving specifically because support for V8 is scheduled to end in April 2011. Whatever the reason for the migration, users will see significant benefits from DB2 10.
Temporal tables. DB2 10 supports system time (where DB2 maintains the beginning and ending timestamps for a row and business time (where you maintain the timestamps). This is especially useful when you need to know the state of the data at a certain time. For example, if you had a car accident last week but did not report it until this week, your insurance company would need to know what policy you had at the time of the accident. While they can find that information now through complex application programming, temporal tables will make it much easier. The insurance company can use business time to determine what policy you had at the time of accident.
Performance improvements. When was the last time your manager told you that performance could slip? Chances are, you are being told to improve performance. And it’s easy to do with DB2 10. IBM says that most users can see 5-10% performance improvement out-of-the box and up to 20% for specific workloads. DB2 10 reduces CPU usage with better memory access and shorter processor times, adds more memory, and exploits z/OS enhancements. For optimal performance, you will need to REBIND.
Let us know why you are migrating to DB2 10.
The postings in this blog are my own and don't necessarily represent BMC's opinion or position.