(Scott Hayes) Use this tuning methodology for accurate input to the DB2 Design Advisor and optimum performance results.
Tag: IBM
Data Warehousing with IBM DB2 Clusters using an Intel-based Server Farm
IBM has long been a leader in parallel database technology with its Universal Database (UDB) DB2. Until recently, a special version of DB2 was required for those who wished to partition a database across multiple systems and allow those systems to work in parallel on a single database operation (suc
IBM’s Tivoli tackles IT processes
(Martin LaMonica) In a move that reflects an industrywide focus on improving day-to-day IT operations, IBM is developing a systems management product line designed to make companies’ technology staffs more effective.
Dispelling the Myths of Java and WebSphere on the iSeries
(Chris Wilson) Much has been made of IBM’s apparent shift in marketing strategy for the iSeries. To many, it’s seen as some form of capitulation, given the fact that WebSphere has a low adoption rate in the iSeries community. The flip side of that is that you need to qualify what “WebSphere” really
South Carolina School Gives DB2 A’s in Efficiency, Cost Savings
(Anne Chen) By leveraging IBM DB2 Universal Database 8.2 features such as autonomic computing and Microsoft Corp. .Net application support, Richland School District Two has been able to provide real-time Web access to mission-critical information residing on legacy systems.
Best Practices for SAP Business Information Warehouse on DB2 for z/OS V8
(Mike Ebbers, Brenda Beane, David Bellion, Nick Dyke, Andrew Hartman, Veng Ly, Mike Mardis, Bala Prabahar, Michael Thelosen, Theodor H. Kuebler, Mark Gordon, Terry Purcell, Joachim Rese and Lydia Parziale) This IBM Redbook describes the benefits of DB2 V8 for SAP Business Information Warehouse. It c
Quick start for Q replication to Oracle and Sybase
(Dell Burner) Find out about the newly released federated capability in WebSphere Information Integrator Q replication, and walk through the process of setting up and using WebSphere MQ, WebSphere Information Integrator Replication Edition, and DB2 Universal Database to replicate to Oracle and Sybas
Automated Statistics Collection in DB2 UDB
(A. Aboulnaga, P. Haas, M. Kandil, S. Lightstone, G. Lohman, V. Markl, I. Popivanov and V. Raman) The use of inaccurate or outdated database statistics by the query optimizer in a relational DBMS often results in a poor choice of query execution plans and hence unacceptably long query processing
Fastrack to federated replication
This tutorial shows you how to replicate data over WebSphere MQ queues from a table in a DB2 Universal Database (UDB) database to a table in an Oracle database on Windows. Replication over WebSphere MQ queues is called Q replication. If you are interested in learning about federated Q replication fr
Advise and Consent
(Howard Goldberg) One of DB2’s most advanced autonomic features, the DB2 Design Advisor analyzes performance options and makes recommendations faster than any human. The final decisions, though, are all up to you.
