This is part 2 in the series that focuses on improving performance in Db2 Warehouse databases. The first part gave some background and discussed some basic concepts relevant to query optimization in the context of the Db2 column engine.
Part 2 : Identifying Costly Operations + Improving Joins
Recently a customer asked us what steps were required to download and install/configure/setup Advanced Copy Services (ACS) so snapshot backups can be performed.So I thought I would share these links that hopeful can help.
Video presentation showing us how to exploit Db2 capabilities.
Db2 recently simplified its editions structure to make the path from prototype to production deployment easier. All editions of Db2 V11.5 use the same code base, from the freely downloaded Db2 Community edition to the Db2 Standard and Advanced editions.
Here is Keri Romanufa with a presentation covering the architecture of Db2, including what is new with Db2 11.5