(Willie Favero) Today’s blog post is a continuation of my earlier post on real time statistics (“An update on Real Time Statistics”) made just last week (March 21, 2013). Continuation is my way of saying I forgot to mention something that I really should have mentioned to make my real time statistic

(Susan Visser) Today a friend of mine asked for advice on how she can learn more about DB2. She’s just starting in this area and is wondering how she can spend 40 hours of dedicated learning to increase her competence.

(Jack Vamvas) Question : A server is short on disk space . I created a list of the largest file, and the largest is C000000.LRG. What is a LRG file and how can I make it smaller?

(Guido Verbraak) Did you ever wonder how you can collect performance data about your DB2 system in a simple way without using extra tools? In this article, learn how to leverage the new DB2 for Linux, UNIX, and Windows monitoring framework available in V10.1 (initially introduced in version 9.7).

(Troy Coleman) Unless you’ve been living under a rock I’m sure you’ve heard the term big data. Of course hearing about something isn’t the same as understanding it.

(Willie Favero) Once again I was asked about DSNDB01.SPT01 compression in DB2 10. Some still remember a few commits made just as DB2 10 became generally available (GA) discussing how SPT01 compression wouldn’t be needed in DB2 10.

(Carlo Randone) Leveraging the capabilities of the Advanced Integration Services (AIS) in IBM Business Process Manager V8 Advanced, this series describes how to implement a distributed ACID transactional scenario in IBM Business Process Manager that includes two databases on different machines. The

(Norberto) The script is all yours. Just change “” to the name of your user OR group, and have fun! (You can also use more than one grantee in the IN clause.)

(Jack Vamvas) Sorts are part of processing queries , but excessive sorts , especially in an OLTP databases can kill performance. Sorts hit IO,CPU and lead to slow response time. A typical DB2 Sort occurs if a sql statement uses an ORDER BY but can’t find a relevant index.

(David Radley) Having good data backing Enterprise Marketing Management (EMM) solutions reduces the number of duplicate, missing, and incorrect offers that you send to your customers and prospects. In this article, learn the design considerations and patterns for supplying master data to EMM solutio