(Troy Coleman) One of the challenges of using ERP applications such as Oracle or SAP is that the SQL can’t be rewritten to improve the performance. However, with the optimizer enhancements in DB2 11, predicates can be automatically rewritten as stage 2, making them indexable.

(Craig S. Mullins) In this third entry of our series on the DISPLAY command, we take a look at using the DISPLAY command to monitor DB2 utility execution and log information. Part 1 of this series focused on using DISPLAY to monitor details about you database objects; Part 2 focused on using DISPLA

(Neha Tomar) Big SQL, a SQL interface introduced in InfoSphere BigInsights, offers many useful extended data types. In general, a data type defines the set of properties for values being represented, and these properties dictate how the values are treated.

(Robert Catterall) A lot of DB2 for z/OS people know about the hash mode of organizing data in a table — something introduced with DB2 10 (I’ve blogged about this topic multiple times, most recently in an entry I posted a few months ago).

(Willie Favero) As promised, here is the second installment in my summary of changes made to the subsystem parameters (AKA DSNZPARM keywords) by migrating to DB2 11 for z/OS.

(Eugene Kharlamov, John Reeve and Sarah Styles) This article shows you how to use new service discovery and workload management features in IBM Integration Bus V9 to discover services by interrogating WebSphere MQ or a database, use the discovered service to configure integration flows, and contro

(Lester Knutsen and Mike Walker) IBM Informix Warehouse Accelerator (IWA) software integrates seamlessly into IBM Informix server and can make database queries faster by many orders of magnitude than ever before.

(Willie Favero) As with all releases of DB2 for z/OS, there are always changes to the subsystem parameters (AKA DSNZPARMs) DB2 uses. Those changes come in the form of old parameters being removed, new parameters being added, and existing parameters having their meanings altered (for example, minimu

(Robert Catterall) Lots and lots of mainframe DB2 people know about the native SQL procedure technology delivered with DB2 9 for z/OS.

(Ember Crooks) One of the features I would most like IBM to add into DB2 is the managing of TSA States through DB2 commands. I’m not a TSA expert, but I would like to find a class or opportunity to study it further. There are plenty of scenarios where I have to go in as root and run various commands