(Ember Crooks) Don’t call them indices in the United States – most American DBAs agree that they are ‘indexes’, though either plural form is grammatically acceptable in American English.

(Henrik Loeser) In my post yesterday I started to look into retrieving and processing the automated maintenance policies using pureXML. The article ended with the conclusion to use the stored procedure AUTOMAINT_GET_POLICY to fetch the policy document.

(Dave Beulke) Recently I discussed DB2 SQL tips that have provided application performance for decades with my clients’ SQL developers. These DB2 SQL tips provide developers with performance guidelines that can help their application designs and SQL coding get the best performance the first time.

(Kim May) At the International DB2 Users Group meeting in Berlin Dan Luksetich shared a drink with two other DB2 experts, Melanie Stopfer and Joe Geller, and recorded their discussion on DB2 for LUW performance tuning.

(Charek Chen, Vijaya Bashyam and Lei Sun) This article describes the integration and performance tuning of WebSphere Commerce V7 Feature Enhancement Pack 5 and IBM Sterling Order Management V9.2. The article provides business stakeholders, architects, administrators, and performance engineers with k

(Craig S. Mullins) Although it is a cliché, it is also true that change is the only constant in today’s complex business environment. An ever-changing market causes businesses to continually adapt. Businesses need to strive to meet customer expectations that are constantly changing, while sustaining

(Henrik Loeser) To help reduce administrative costs, DB2 supports automatic collection of statistics, automatic database backups, automatic reorganization of tables and indexes, and some more.

(Shelly Gupta) The Web Services Reliable Messaging (WS-RM) and Web Services Security (WS-Security) specifications describe protocols that enable encrypted messages to be delivered reliably between distributed applications, even when there are software component, system, or network failures.

(Cindy Russell) This webcast discusses how DB2 fits in a big data world that involves both structured and unstructured data in volume. DB2 is well known for its relational database capabilities, but did you know it has handled XML data for some time and that RDF Graph store capabilities were introdu

(Ember Crooks) Especially with TSA and db2haicu, sometimes you see an error, and you have a bag of tricks that you try, even though you don’t understand exactly why they work.