This week IBM announced DB2’s newest feature, DB2 pureScale. This new feature within the DB2 Family of products represents the next step in overall database performance because of its unlimited capacity, application transparency and continuous availability. The DB2 pureScale feature provides the ability to balance the workload across a dynamic number of DB2 servers . . . → Read More: DB2 pureScale – Next Step in Database Performance
|
|
||
|
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. Another one of the enhancements with DB2 Version 9 for z/OS that helps . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 7 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 SQLAnother one of the enhancements . . . → Read More: 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. . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 5 I received some great comments and questions based on the last blog entry/video about the many new features in DB2 Cobra. One of the more interesting questions was asked “How much work or how compatible is the new DB2 with Oracle?” The . . . → Read More: Four More Reasons to Migrate from Oracle to DB2. As each version of DB2 for z/OS comes out there are always the projects that need justification for going to the next DB2 version. The huge number of performance features in DB2 Version 9 for z/OS should make your summer of 2009 your time to get to the new release. This large number of performance . . . → Read More: DB2 Version 9 for z/OS Performance Features Another great feature that is in the new Version 9.7 of DB2 is its new compatibility with Oracle. This compatibility takes many forms within the database such as understanding operational syntax, stored procedures keyword syntax and improved operational concurrency that I covered last week. The DB2 compatibility with Oracle was developed because many clients are . . . → Read More: DB2 Compatible with Oracle Make sure that the interface with CICS works wellValidate the settings between your CICS transaction configurations. Make sure the maximum workload from one TOR, AOR or DOR is not overwhelming another CICS processing partner. If your system is heavily dependent on CICS transactions: Make sure that you are reviewing the CICS Statistics DB2 Connections . . . → Read More: DB2 Performance Summary Part 3 Make sure that you are using the correct database designUse partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partition for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and different devices. Use database . . . → Read More: DB2 Performance Summary Part 2 Over the last four months, we have examined in-depth the DB2 performance problems that might be found in a typical DB2 installation. My purpose in doing this was to show you how A methodical review can help you discover ways to reduce system costs. Good application review and positive changes can even save substantial investment . . . → Read More: DB2 Performance Summary Part 1 |
||
|
Copyright © 2012 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy |
||
Find Me On