(Roman Kharkovski) Not every performance problem can be fixed with caching, but assuming you have done your due diligence and your “slow” application is already tuned and well designed, adding caching can dramatically improve response times and reduce the load on backend systems.

(Troy Coleman) Last month I wrote about IBM’s just-released draft Redbook on the DB2 Analytics Accelerator. Since then, I’ve researching the IDAA more closely.

(Norberto) Need to save all foreign keys for a table or an entire schema? Just run the command below against your database (replace YOURSCHEMA and YOURTABLE by your values) and send the results to a file:

(Scott Hayes) In our Season #3 finale, Scott Hayes was joined by Andrew Endicott, DBA Manager at Cardinal Health, for a lively discussion about DB2 LUW Performance Tuning.

(Michael.Krafick) To eliminate any confusion – I am not Ember. Ember is a little shorter, with a big smile, and glasses. I was lucky enough to meet her through a mutual friend at the IDUG 2012 Conference in Denver just a few weeks ago. After enough networking events and sessions, we found we had sim

(Gunjan Verma) Learn how IBM DB2 10 for z/OS compares with its predecessors and get an introduction to some of the salient features of DB2 10 for z/OS.

(Yunming Wang and Tim Steele) Data security is always a concern for database administrators. This tutorial helps you understand how to secure your data by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database serve

(Ember Crooks) In some situations where there are uncommitted updates to a row, this parameter defers the acquisition of a lock on a row for CS or RS isolation levels until the row is know to satisfy the predicates of the query. This can improve concurrency.

(Willie Favero) This is my attempt at an SQL statement that describes the PLAN_TABLE contents in a comma delimited format that can easily be brought into a spreadsheet. The query not only looks at the PLAN_TABLE, but also a couple of the statistical columns from SYSIBM.SYSTABLES.

(Nigel T. Crowther and Jonathon Carr) The second part of this series extends the Generic Ruleset Signature pattern, which can be applied to business rules in IBM WebSphere Operational Decision Management to improve productivity and maintainability of rules projects using a flat business model.