(Boudhayan Chakrabarty and Yogesh Gawali) IBM Tivoli Security Operations Manager gathers massive amounts of information that is stored in a relational database such as DB2. Learn how tuning IBM DB2 for Linux, UNIX, and Windows helps you get the best performance from your IBM Tivoli Security Operatio

(Henrik Loeser) Earlier this week I had asked “What pureXMLness do you have?”. Let me explain the query that computes the pureXMLness today.

(Scott Hayes) In episode #34, special guest George Baklarz, IBM Toronto Lab, shared with us a demonstration of some very cool (and free) tools that can be used to estimate DB2 compression results, simulate DB2 pureScale operation, and learn about the plethora of DB2 features and capabilities.

(Chris Smith) If you want to access data in the DB2 for i database from a remote computer, it’s not that difficult. However, if you are working on an iSeries and you wish to connect to a remote database server to manipulate data, it can be a bit of a challenge.

(Daniel Millwood and Susan Malaika) This article is the second part of a series of articles. The first article focused on augmenting CICS Web services with two general purpose routines (pipeline handlers) that support two scenarios to store and retrieve XML in DB2(R) pureXML.

(Serge Rielau) The meaning of pivoting a table is to turn n-rows into n-columns.

(Rebecca Bond) I just returned from IBM’s Information on Demand 2010 with a cranium that is crammed full of great technical information about DB2 LUW. Attending IOD each year is a highlight for me, not just for the technical knowledge I acquire there, but also for the opportunity to interact with my

(Sreedevi Veluri and Sanjeeva Kumar Ogirala) Are you someone who likes to get things done from a command line? If so, and you’re implementing an IBM DB2 pureScale environment, here’s the help you’re looking for. This article introduces the DB2 pureScale Feature and then illustrates the syntax for co

(Nancy Perkinson) DB2 locking conflicts happen all the time at every shop. Mostly they go by unnoticed because they are resolved quickly and efficiently behind the scenes, but occasionally locking conflicts can cause frustrating abends and/or greatly lengthen clock response times.

(Robert Catterall) In a couple of entries that I posted to the blog I maintained while working as an independent DB2 consultant (one written this past summer, and the other in the spring of 2009), I mentioned the LASTUSED column of the DB2 for z/OS catalog table SYSIBM.SYSINDEXSPACESTATS.