| By Dave Beulke, on September 22nd, 2009 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 By Dave Beulke, on September 8th, 2009 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 By Dave Beulke, on September 1st, 2009 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 By Dave Beulke, on August 18th, 2009 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 By Dave Beulke, on August 11th, 2009 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 By Dave Beulke, on August 4th, 2009 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 By Dave Beulke, on July 28th, 2009 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 By Dave Beulke, on July 14th, 2009 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 | |