There’s good news from the IBM lab: IBM dashDB for Transactions now offers high availability plans, and offers “pay per use” plans that are billed by-the-day.
Understanding DB2 for LUW Buffer Pool I/O
You will get virtually no argument from anybody that buffer pool management is important to good DB2 and application performance. Large buffer pools are a well known wisdom. There are many ideas on buffer pool management, including the number of buffer pools
By now, most DB2 for LUW users have probably heard about the release of DB2 11.1 that became available in June of this year. In this article I’d like to provide more information on some performance optimizations in DB2 11.1 that will benefit queries accessing both row and column-organized tables.
The purpose of this article is to decode the DB2 backup and restore performance statistics that are now logged in the db2diag.log. It will also discuss some factors that influence backup performance and how the performance stats can be used to identify where performance bottlenecks exist.
DB2 is rich with built-in functions. There are simple scalar functions (LENGTH, SQRT, ABS), functions that deal with columns of data and grouping (AVG, SUM, OVER), row functions and specialized statistical functions (CORRELATION, STDDEV).