DB2 Migration to DB2 10: Another Three More Items to Ensure your DB2 Performance

As everyone gets ready for the DB2 migration to Version 10 there are many things that need to get done to start implementing the system and application enhancements. Below are another three more items to do ahead of the schedule so your company, systems and applications can leverage the features as soon as you start . . . → Read More: DB2 Migration to DB2 10: Another Three More Items to Ensure your DB2 Performance

Performance features in DB2 V9 for z/OS – Part 10

As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations; improve application performance and overall availability of your systems and data.

There are many new enhancements with DB2 9 for z/OS that are especially . . . → Read More: Performance features in DB2 V9 for z/OS – Part 10

Performance features in DB2 V9 for z/OS – Part 9

ORDER BY and FETCH FIRST n ROWS in a Sub-Select
Another one of the new enhancements, ORDER BY and FETCH FIRST n ROWS in sub-select and full-select, is especially great for web and Java application programmers. You may be surprised because your programmers have been using ORDER BY and FETCH FIRST n ROWS for some time, but in DB2 Version 9 for z/OS . . . → Read More: Performance features in DB2 V9 for z/OS – Part 9

Performance features in DB2 V9 for z/OS – Part 8

Skip Uncommitted Inserts zParm
Another one of the enhancements with DB2 Version 9 for z/OS that helps with your very robust tables and their locking is the new zParm, Skip Uncommitted Inserts – SKIPUNCI. If your applications . . . → Read More: Performance features in DB2 V9 for z/OS – Part 8

Performance Features in DB2 V9 for z/OS – Part 4

As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations and improve application performance and overall availability of your systems and data.

One of the important new changes is Utilities Improvements which helps your . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 4

Performance Features in DB2 V9 for z/OS – Part 3

As I talked about the last two weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these really stand out and in the coming weeks I will continue to write about some that can really help you reduce the CPU demand on your system and application environments.

One of . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 3

Performance Features in DB2 V9 for z/OS – Part 2

As I talked about last week, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these really stand out and in the coming weeks I will write about some that can really help you reduce your CPU demand on your system and application environments.

One of the new features, selecting . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 2

Too Many Performance Features in DB2 Version 9 for z/OS

DB2 Version 9 for z/OS has over 50 plus great performance features. Many of these really stand out and can provide a dramatic impact on your existing applications. Over the coming weeks I will write about these performance features.

After converting to Version 9, the first performance feature that should be evaluated for your environment . . . → Read More: Too Many Performance Features in DB2 Version 9 for z/OS

Many Reasons to Go to the New DB2 9.7

Going through the DB2 9.7 Cobra beta was very educational for learning about the new features and functions. In the video below I and several of the other beta customers talk about their companies’ experiences with DB2 Version 9.7 and what features they liked best about the new DB2 release.

There are many reasons to . . . → Read More: Many Reasons to Go to the New DB2 9.7

More Compatibility and Concurrency with DB2 Version 9.7

Also at this year’s IDUG conference, Cobra DB2 9.7 was discussed with its many great new features. I experienced a number of these enhancements as I went through the DB2 Cobra beta program with IBM. Now that IBM has officially announced DB2 9.7, I can happily talk about it. Two of the many enhancements within . . . → Read More: More Compatibility and Concurrency with DB2 Version 9.7