(Jack Vamvas) Question: How can I terminate a DB2 backup ? Using db2 list utilities I can see a BACKUP in progress , but how can I terminate the BACKUP from within DB2?

(Craig S. Mullins) Left to their own devices, DB2 databases and applications will accumulate problems over time. Things that used to work, stop working. This can happen for various reasons including the addition of more data, a reduction in some aspect of business data, different types of data, more

(Willie Favero) Before we jump into discussing the last two variable buffer pool thresholds, the defaults for the previously discussed fixed buffer pool thresholds are: immediate write threshold (IWTH) – 97.5%, data management threshold (DMTH) – 95%, and prefetch threshold (SPTH) – 90%.

(Isaac Yassin) Part 1 of this series offers a detailed look at the various options for copying data in IBM DB2 database deployments to back up the data as an insurance policy against permanent loss or extended downtime. This concluding installment focuses on the details to consider when recovering d

(Dave Beulke) As I talked about last week, good DB2 SQL performance is vital for efficient processing. I also talked previously about DB2 SQL performance here, here, and here describing the many attributes that can impact and improve DB2 SQL performance.

(Willie Favero) Let’s start today’s post with a short discussion about what a buffer pool is. I know most of you all know this stuff already, so this explanation will be short and just enough to get us all on the same page. Thresholds are usually easier to understand when you have some idea of h

(Jeff J. Li and Shweta R Sugurmath) In this article, learn how to use the Cloudant database and CouchDB with the IBM InfoSphere DataStage V11.3 Hierarchical stage (previously called XMLConnector). Detailed examples show how to invoke the Cloudant API, using the REST service of the Hierarchical Data

(Roman Kharkovski) One of the most important aspects of a complex system is its serviceability. For example, cars are made in a way that mechanics can quickly diagnose and fix issues, perform tuning and maintenance.

(Michael Sansoterra) In the first tip, I showed various ways to test DB2 functions, procedure results, and triggers for logic accuracy and security. However, the tip never covered how these tests, once written, are to be processed. In particular, questions such as these need further discussion:

(Ember Crooks) There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would share.