(Scott Hayes) In episode #36, special guest Klaas Brant, IBM DB2 GOLD Consultant and owner KBCE b.v., shared with us his expertise on database high availability solutions. High Availability was defined and discussed, then Klaas took us on a deep dive into DB2 9.8 pureScale, Oracle RAC, and SQL Serve

(Michael Schenker and Thomas Conrad) When you experience a problem with one of your IBM DB2 for z/OS queries that you need to report to IBM Software Support, the most critical step in resolving the problem is to capture the query environment, which includes tables, indexes, views, statistics, EXPLAI

(Serge Rielau) Over the years DB2’s SQL Procedure Langiage (SQL PL) has taken on a more and more prominent role and those who know how to use it properly can do some amazing things.

(Robert Andrews) In my last TechTip, "How’d You Get Your SQL Server Data in My IBM i DB2 Data!?!," I explained how we could integrate Microsoft SQL Server data into the drag-and-drop world of DB2 Web Query reporting. In this TechTip, I will discuss how to integrate data from Oracle’s JD Edwards line

(Simon Evans) Recommendations and tips on using prompt parameters in the IBM Cognos Analytic Applications. Filter structures in the warehouse model, their use by Adaptive Analytics, and report manager controls are discussed.

(Susan Visser) This is an interesting concept! Education classes can be rather expensive and if the course doesn’t fit your needs, the price is even higher. Now you can try a class for free to see if it gets into the depth that you need or at the pace that you need.

(Dave Beulke) Is performance the number one issue for the DBA and the application teams or is security and governance? I guess it depends on your industry and point of view. With the latest WikiLeaks scandal, the new BASEL III requirements, HIPAA privacy requirements and many data breaches gaining p

(Bryan Patterson) This article provides guidance to database users in choosing XML tools to help them with the new responsibilities that arise now that IBM DB2 can efficiently store and manipulate XML data with pureXML. The size of XML, which can vary from a few kilobytes (KB) to many megabytes (MB)

(Rav Ahuja) IBM DB2 customers discuss how cost reduction, performance improvement and Oracle’s continuing rising costs influenced their data migration.

(Rav Ahuja) This is an interview with Tom Holdener, Senior Technical Specialist at BJC Healthcare and an early user of the IBM DB2 SQL Skin solution.