(Phil Francisco) Success in any enterprise depends on having the best available information in time to make sound decisions. Anything less wastes opportunities, costs time and resources, and can even put the organization at risk.

(Ember Crooks) If you’re not familiar with MONREPORT, see my DB2 Basics entry on MONREPORT first.

(Lockwood Lyon) With access path tuning addressed, the database administrator can now turn to the details of query execution to determine if a long elapsed time can be reduced.

(Henrik Loeser) Well, a boring headline for an interesting topic. Originally I had planned to title today’s blog entry “Forget about Black Friday and Cyber Monday – Save big by moving to DB2”. But then writing this entry has dragged on for some days…

(Maobing Jin, Aditya Joag, Rohit Gargate and Mohana Kera) In this tutorial, we will demonstrate a catalog management system for e-commerce solutions through an application on top of InfoSphere MDM Collaborative Edition and WebSphere Commerce Enterprise Edition. The application will provide a simple

(Kent Milligan) Almost all of the DB2-related TechTips that I have written highlight new DB2 for i functions and features. While it’s good to raise awareness of new DB2 capabilities, this does result in existing DB2 features being overlooked. This is especially true of the more ordinary database fun

(Richard J. Kinard, Andre Manriquez and Johnson YS Chiang) The AS2 Filename Preservation feature is a common requirement for customers in the banking industry. WebSphere DataPower B2B Appliance supports this feature by using the processing policy. This tutorial describes how to configure a trading r

(Lockwood Lyon) Another aspect of efficient clustering is that tables are commonly joined by their primary and foreign key columns. In an order entry system containing a customer table and an order table, each might be clustered by their primary key (customer number and order number, respectively).

(Julian Stuhler) As a follow-up to my “DB2 10 upgrade – 23 Things to think about now” blog I’ve created a version for DB2 11. Once again this is intended for organisations who are planning an upgrade to DB2 11 and would like some guidance on what needs to be done prior to the upgrade.

(Craig S. Mullins) Just a short blog post today to point folks to a very well-written article on database consistency models titled On the Futility of Custom Consistency Models (posted on the Hacking, Distributed blog by Emin Gün Sirer).