(Craig Mullins) Our examination of the new utility functionality in DB2 9 for z/OS continues today as we uncover what’s new with the IBM RECOVER utility.

(Michael Sansoterra) Everybody likes to export DB2 data to an Excel spreadsheet. It’s quick and easy, and there are plenty of ways to do it. On the other hand, I’m often asked by people, including fellow developers, to assist them with importing an Excel worksheet into a DB2 table. In fact, what dev

(Joe Pluta) I recently did my very first scratch install of i5/OS. And while IBM provides really good instructions for doing so, the nature of the process is such that a first-timer can get a bit uneasy even when things are going correctly. For example, there were places where the documenter knew th

(Willie Favero) This reminder, however, is about daylight savings time coming to an end. Remember all the noise last spring because daylight savings time was going to start a few weeks earlier this year. Well, hopefully you all also remembered that daylight savings time will end a week later starti

We had discussed the CHARINDEX() function in the previous post. Similar to the INSTR (Oracle) and CHARINDEX (MS SQL Server) functions, DB2 has a LOCATE function to search for a string within another string. It returns the starting position of the search string if it finds it within the string, else

(Craig Mullins) This week we continue our exploration of the features and functionality of DB2 9 for z/OS with a look at what’s new in the IBM LOAD and UNLOAD utilities. The first question people seem to ask with regard to LOAD is “Has performance been improved?” And the answer is yes, due mostly to

(Anil Mahadev) The purpose of this tutorial is to help newcomers to IBM DB2 9 learn how to use ASP.NET. It acts as a quick, interactive guide that teaches you to develop RAD Web Applications using the powerful IBM data platform DB2 9 and ASP.NET v2. After following the steps presented in this tutori

(Chris Eaton) For those that have been using DB2 for some time or those coming from other data servers, you are likely familiar with the RESTORE command. With RESTORE, you specify the backup image you want to restore (indicated by the timestamp the backup was TAKEN AT) the media you are restoring fr

(Craig S. Mullins) In this data-breach and regulation-laden world we currently find ourselves working in, the topic of data encryption has become increasingly popular. If we encrypt our sensitive data then only authorized folks who know the decryption key will be able to access it. And that signific

(Samuel Poon and Fraser McArthur) Learn about IBM DB2 for Linux, UNIX, and Windows with this reading list, compiled especially for the database administrator community. This popular article is updated to cover DB2 9, formerly codenamed “Viper.” There is also an application development reading list t