(Carol) It’s well known that DB2 10.1 for LUW delivers new capabilities to help us all save time and money. The new version reduces the complexity of management, improves your developers and DBAs’ productivity, eases the effort with deploying new applications and lowers your overall data management

(Michael.Krafick) One of my favorite commercials is from a motor oil company. The scene begins with a man who is sleeping soundly. His slumber ends abruptly when he is physically grabbed by the collar, shoved on a treadmill and forced to run in an all out sprint from a cold start to prove a point a

(Mihai Iacob, Paolo Cirone, Walid Rjaibi and Mang Tang) Restrictive DB2 databases provide an out of the box least privilege approach to databases and database objects. This least privilege approach makes it much easier for you to secure your databases, compared to non-restricted databases.

(Robert Catterall) SQL statement tuning — most often in the form of query tuning — is important when it comes to boosting the CPU efficiency of a DB2 for z/OS application workload.

(Henrik Loeser) On Monday I posted a small quiz about an SQL error reported by DB2. In the comments were guesses about the solution, including generated columns, triggers, or the table actually being a view causing the error.

(Bruce Jackson, Dale McInnis, Effi Ofer, Nailah Ogeer Bissoon, Punit Shah, Roger Zheng, Vincent Kulandai Samy and Yuke Zhuge) Beginning in DB2 LUW version 10.1, the high availability disaster recovery (HADR) feature supports up to three standby databases, allowing you to provide both high availabili

(Philip Nelson) For as long as I’ve been involved with IDUG, performance tuning has always been one of the most popular subject areas for conference presentations and technical articles. From the wide range of possible topics in this area, two perennial favourites are buffer pool tuning and indexing

(Shashi R Thambrahalli and Bala Subramanian Vetrivel) This article shows you how to use Ant scripts and Java classes to customize WebSphere MQ FTE to automatically transfer new and modified files from a source folder to a destination folder, and ensure that files in source and destination folders ar

(Ember Crooks) This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this:

(Henrik Loeser) I have been playing with some new DB2 10.1 features and thought that a small SQL quiz at the beginning of the week is appropriate. Consider the following SQL statements and the related output: