(Craig S. Mullins) Today’s blog will walk you through a sorting "trick" that you can use when you are dealing with days of the week. A relatively common problem involves sorting a column that contains a day-of-the-week not in alphabetical order by in the order it appears in the week…

(Aish Khare) Data Corruption is something that no one really wants. Yet every now and then, we see some customers run into this. Any such issues are almost always the result of disk or SAN level issues. You will see errors like this:

(Joe Pluta) Moving from traditional DDS environments to a pure SQL configuration requires some rethinking and sometimes a little re-engineering. One case has to do with duplicate keys. We sometimes end up with databases where we have “almost” duplicate records.

(Craig S. Mullins) Today’s blog will walk you through a sorting “trick” that you can use when you are dealing with days of the week. A relatively common problem involves sorting a column that contains a day-of-the-week not in alphabetical order by in the order it appears in the week…

(Aish Khare) Data Corruption is something that no one really wants. Yet every now and then, we see some customers run into this. Any such issues are almost always the result of disk or SAN level issues. You will see errors like this:

(Joe Pluta) Moving from traditional DDS environments to a pure SQL configuration requires some rethinking and sometimes a little re-engineering. One case has to do with duplicate keys. We sometimes end up with databases where we have “almost” duplicate records.

(Ember Crooks) There are some things to be aware of with ongoing support of a HADR system. I thought I’d group them together to provide a primer of do’s and don’ts for support of HADR.

(Ludovic Janssens) The subtitle of this article refers to Alan Reddings blog[1] who calls the mainframe a ‘Dancing Dinosaur’. The sturgeon, who produces caviar, is one of the oldest animals on our planets. As DB2 for z/OS is still regarded as a high quality RDBMS, caviar is wanted by those who can a

(Michael Sansoterra) In part 1 of this series, I discussed the row permissions portion of the new row and column access control (RCAC) security feature that was introduced in DB2 for i 7.2. In this tip, I will demonstrate how to use RCAC to hide sensitive information without hiding entire rows from

(Ember Crooks) There are some things to be aware of with ongoing support of a HADR system. I thought I’d group them together to provide a primer of do’s and don’ts for support of HADR.