(Robert Heath) Take advantage of the section explain feature in IBM DB2 for Linux, UNIX, and Windows 9.7.1 and later when you tune SQL with InfoSphere Optim/reg> Query Workload Tuner 3.2.

(Willie Favero) There’s always seems to be “something” behind everything great. For example, you can’t have a great race car without a great engine or a great team of mechanics, you can’t have an unforgettable meal without an exceptional chief chef, and you can’t have exceptional warehouse performan

(Marinus Van Sandwyk) In POWER environments running legacy IBM i systems, a two-phased approach is required to enable the integration of multiple databases across different platforms.

(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.

(Dave Beulke) When companies and projects are considering their Big Data applications, it seems that everyone forgets the decades of advancement, computing platforms and databases technologies have gone through. Platform and database are critical to the success of your company’s Big Data initiative

(Ember Crooks) This post should be a quick one. In older versions of DB2, we had to worry a lot more about tablespace states. Within my career, I can remember that a LOAD operation would put a whole tablespace into “LOAD PENDING”, and if that LOAD operation failed in certain ways, the tablespace wou

(Bhavik Shah) In this tutorial, use the data extension and pre-written SQL capabilities to create a custom search object and enable the use of the new party attributes as part of a classic party search service.

(Troy Coleman) I initially wrote about the IBM DB2 Analytics Accelerator (IDAA) more than a year ago. Now there’s a new version — IDAA for z/OS 3.1 — that has some very impressive performance improvements.

(Soid Quintero) Burt Vialpando, Executive IT Specialist at IBM, describes how InfoSphere Optim High Performance Unload for DB2 for LUW can be used for rapid data extraction to help you reduce restoration and migration times for large volumes of data.

(Frank Fillmore) The asntdiff utility is used to compare the contents of two tables, primarily in the context of SQL and Q Replication. The problem has been that very large tables can take a very long time to compare.