(Serge Rielau) Anyone who has ever attended a talk of mine on SQL compatibility has heard my claim that “to support Oracle applications in DB2 we had to add a completely new date-arithmetic library of functions since no two functions operating on date appeared to be the same in DB2.”

(Joe DiPietro) New databases and new applications are continually being created and adopted to meet specific organizational needs. The requirement for data protection and auditing capabilities is required by mandate and is more critical than ever.

(Ron Powell) This BeyeNETWORK Spotlight features Ron Powell’s interview with Alan Meyer, Marketing Manager of Data Warehousing on System z, IBM Software Group. A few of the topics they discuss include business analytics, federation and how mainframes can reduce cost and complexity and also deliver d

(Robert Catterall) A DB2 for z/OS DBA recently asked me about the pros and cons of hash-organized tables — a physical database design option that is introduced with DB2 10 for z/OS running in new-function mode (NFM). Assuming that others in the mainframe DB2 community are also pondering this issue,

(Prabir Nandi, Vlad Klicnik and Steve White) The third part in this series explains how to use business entities (or business-significant data) with business processes to elegantly model complex, end-to-end business operations. A set of modeling patterns is extracted to catalog the interactions and

(Scott Hayes) 97% of our studio audience learned something! Our IBM Canada guests shared with us the latest news, tips, and advice for Data Warehouse Performance.

(Jack Vamvas) In DB2 database performance troubleshooting , one of the challenges is to collect the right amount and type of data to assist the DBA to get clues.

(Miso Cilimdzic, Peter Kokosielis and Mel Bakhshi) Learn how you can improve your return on investment when you deploy the IBM DB2 pureScale Feature with Linux on IBM System x servers. Modern System x servers have an ample number of cores and amount of memory and I/O capability. By using virtualizat

(Frank Fillmore) The fourth quarter of 2012 will close in just over one month. What will you close between now and then? If you attended the Break Free Forum at the IBM Information on Demand (IOD) conference in Las Vegas last month, you heard The Fillmore Group’s founder and principal, Frank Fillm

(Ember Crooks) DB2 has a number of ways of accessing the data it needs, but the most basic one – the one that will always work to get what it needs – is the table scan. A Table scan means that DB2 will read through every single row in a table to get the data it needs. Table scans appear […]