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.
|
|
||
 Comments are closed  Data Warehouse-  DB2 9, DB2 Business Intelligence, DB2 Data Warehouse, DB2 Data Warehousing, DB2 Performance, DB2 zOS, System Z 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. 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 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 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 2009 DB2 Magazine article talks about two DB2 performance features in DB2 9 for zos, DB2 index on expression and DB2 index compression. 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 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 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 Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When time is tight . . . → Read More: Many New Index Options in DB2 – Version 9 DB2 Performance Features – Part 19 |
 
  |
|
|
Copyright © 2013 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy |
||