What’s the main difference between single-row and multi-row inserts? Simply the performance. If you are inserting many rows in a loop via a single-row insert, you call DB2 for every single row, which means you spend some time for the communication with the DB2.
April 2015 “Fun with SQL” Challenge 2
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
Let’s speak today the database monitoring. DB2 is usually presented as a black box that stores and retrieves data for you. Usually we don’t care much about what is happening inside it. However as soon as a trouble arises, information about its internals becomes critical.
In this article Saurabh Agrawal discuss a technique utilized to shorten the amount of time it takes to purge a large amount of data from a DB2 for LUW database. The article includes a very detailed description of the process along with some script examples.
In this session from the IDUG 2014 Technical Conference in North America, Randy Ebersole highlights some of the new features of DB2 11. He introduces some of the new functionality to get you thinking about moving to DB2 11!