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 6

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.

FETCH WITH CONTINUE SQL

Another one of the enhancements . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 6

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

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.

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

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

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