The International DB2 User Group (IDUG) North American conference is always full of great DB2 Family presentations. I try to go through all of them because they are always full of great ideas, best practices, hints and tips. I guess that’s why IDUG celebrated both DB2 for z/OS’ 30-year anniversary and its own 25-year anniversary.
. . . → Read More: DB2 10.5 Upgrade – 10 Reasons to Implement immediately!
Reviewing the DB2 10 Data Warehouse DSNZPARM for z/OS
The previous two weeks’ Part 1 and Part 2 discussions highlighted and discussed the various DB2 Data Warehouse DSNZPARMS for z/OS within Versions 8 and 9. With the new DB2 Temporal Tables the system needs . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 3
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.
Better DB2 Business Intelligence Performance Management
2003 DB2 Magazine article shows how to get better DB2 business intelligence performance by taking advantage of DB2 views, especially a DB2 materialized view.
DB2 Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple DB2 MQTs is one technique that is good for providing all types of reporting capabilities and answers. By combining multiple DB2 MQTs, the DB2 SQL optimizer can sometimes automatically rewrite the queries . . . → Read More: Combining Multiple MQTs to Improve SQL Optimization and DB2 Performance for Data Warehousing