(Nagraj Alur, Hennie Mynhardt, Gregg Palmer and Alicia Wangelien) This IBM Redbook describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use

(Paul Zikopoulos) In a previous series of articles, I showed you the integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).

(Roger E. Sanders) Have you ever needed a second (or third, or fourth) copy of a production database? Do you know what options are available when it comes to cloning a database? In this column, I’ll explain when you might want to clone a production DB2 database and show you several methods you can u

(Willie Favero) If you have been to any kind of DB2 Version 8 presentation, I can almost guarantee that at some point someone brought the changes in collating sequence you will experience once you move to NFM. A friend sent me another example of how easy it is to solve this potential problem.

(Ravindra Pratap Singh) This short article explains how to convert the Character Large Object (CLOB) data type for a table into the VARCHAR data type for any database by using a customized Java class. By writing your own Java class, you can easily convert the CLOB data type. This helps users and cus

(Willie Favero) Remember last week I started to discuss the bind keyword KEEPDYNAMIC? In today’s installment, we’ll start discussing the stuff that makes this interesting. The basic introduction to KEEPDYNAMIC is already out of the way so in the next few post I’ll take a look at how KEEPDYNAMIC work

(Judith Myerson) Gone are the days of storing XML data as a Character Large Object (CLOB) or shredding to relational tables. The problem was that after you decomposed an XML document, stored it and then put it back together, you did not end up with what you started with. Gone are the days of the ina

(Sebastian Nelke) IBM WebSphere Information Integrator OmniFind Edition 8.3 is full of features and functionalities that allow you to build powerful, high-value applications, and solutions based on IBM’s enterprise search functionality. Learn how to use Cas2Jdbc, the part of OmniFind that allows you

(Chris Eaton) As you may know, in DB2 v8.2 IBM moved to a pluggable authentication model whereby you can plug-in the authentication mechanism you prefer. In that release a Kerberos plug in was shipped with DB2 but other plug-ins could be implemented either from 3rd parties or by building one yoursel

(Sing Li) The combination of Eclipse, DB2 Express-C, and WebSphere Application Server Community Edition — all free to download, use, and deploy — is an excellent from-prototype-to-production suite for all of your Java and Java enterprise development needs. What might not be obvious is the relative