DB2 11 for z/OS Features and Resources

Information overload is the constant at all conferences and the recent European IDUG and US IOD conferences were both tremendous at providing great detailed information. All the enhancements in DB2 11 for z/OS, DB2 10.5 BLU Acceleration, and all the latest Pure Data systems were detailed at both conferences. DB2 11 for z/OS has many . . . → Read More: DB2 11 for z/OS Features and Resources

DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications

DB2 Leads with Innovation Benefiting DB2 Business Intelligence Applications

2008 DB2 Magazine article shows how DB2 on the System Z platform supports cost efficiencies and DB2 performance for DB2 business intelligence applications.

DB2 9 Provides a DB2 Performance Boost

DB2 9 Provides a DB2 Performance Boost

2007 DB2 Magazine provides specific examples of DB2 SELECT, DB2 FETCH and more to show how DB2 9 for DB2 zos can improve DB2 performance.

DB2 XML and DB2 LOB Design

DB2 XML and DB2 LOB Design

2008 DB2 Magazine article talks about DB2 XML and DB2 LOB support in DB2 9.

Follow Through on Best DB2 Performance Practices to Achieve DB2 Scalability

Follow Through on Best DB2 Performance Practices to Achieve DB2 Scalability

2006 DB2 Magazine article by DB2 consultant, Dave Beulke, discusses DB2 8 for Z/os and DB2 LUW 9 with their improved DB2 performance and DB2 scalability.

Boosting DB2 9 Performance and DB2 Scalability for DB2 9

Boosting DB2 9 for zos Performance and DB2 Scalability

2007 DB2 Magazine article shows how improvements to DB2 locks in DB2 9 for DB2 zos improves DB2 performance and DB2 scalability.

Top DB2 Performance Features in DB2 9 for zOS

Top DB2 Performance Features in DB2 9 for zOS

2009 DB2 Magazine article talks about two DB2 performance features in DB2 9 for zos, DB2 index on expression and DB2 index compression.

Get the SQL Cache Anyway--Even Without OSC

It seems that I hit a nerve when I was talking about DB2 tools. It seems many shops are upset at the rising costs of third party tools. IBM’s responses of some free tools that have limited capabilities are also getting limited enthusiasm.

What has been interesting is there really seems to be support for . . . → Read More: Get the SQL Cache Anyway–Even Without OSC

Free Tools for DB2 Help You Improve SQL Access and DB2 Performance

Analyzing SQL access and DB2 performance is difficult without any tools. The Optimization Service Center (OSC) is a great tool and resource within DB2 V9 for z/OS. This tool helps you with the cost of the SQL, Visual Explain of the access path and provides the ability to dump and then look through the Dynamic . . . → Read More: Free Tools for DB2 Help You Improve Access Performance

Plan Stability - Version 9 DB2 Performance Features - Part 20

DB2 Version 9 offers a new way to handle testing out a new version of a DB2 application through the Plan Stability enhancements. The Plan Stability enhancements offer a way to save a static DB2 access package for an application and then BIND a new one. If the access package is not as efficient, Plan . . . → Read More: Plan Stability – Version 9 DB2 Performance Features – Part 20