(Mary Taylor and Li (Tony) Wei) This article is the second in a series of articles that address data integration in the development of Composite Business Services (CBS). The ability for a company to provide a “single view of the customer” is critical for effective SOA transformations. WebSphere Cust

(Willie Favero) For all those ODBC applications running around out there, and you know who you are, here’s an APAR you’ll love. I know that everyone who deals with ODBC is always looking for any method they can find to improve ODBC’s performance. This is also another excellent example of why it’s im

(Genaro Nieto Fernandez) This tutorial takes you through the steps to enable drag-and-drop functionality of items between two portlets that run in the WebSphere Portal V6 environment. Portlet developers can use drag-and-drop capabilities to provide end users with richer environments that are easier

(Susan Visser) This one is Exam 732 – DB2 for z/OS V9 Database Administration exam.

(Dirk Fechner) When several DB2 users access a database concurrently, lockwait situations can cause bad response times. Locks on database objects cannot be avoided, as locks are essential for database integrity. But in many cases it is possible to limit the number of locks for transactions to a mini

(Craig S. Mullins) Applications that access relational databases are only as good as the performance they achieve. And, every user wants their software to run as fast as possible. As such, performance tuning and management is one of the biggest demands on the DBA’s time. When asked what is the singl

(Chris Eaton) Based on the number of questions and comments in my initial HADR posting I know that many of you are using HADR for high availability or disaster recovery. If you are using HADR, here is an administrative views that you can use to monitor your cluster via SQL.

(Ivan Popivanov, Scott Walkty, Angela Yang and Beck Tang) The autonomic capabilities of IBM DB2 for Linux, UNIX, and Windows lighten the load of the DBA and enable you to maximize performance. This article demonstrates how to enable and configure automatic reorganization, monitor automatic reorganiz

(Willie Favero) Sometimes I get so excited about posting what seems like something really cool, that I forget to check out what repercussions might befall you by following my advice. DSNTEP4 may be one of those times.

(Vikram S. Khatri) This article presents a logging framework that you can use with IBM DB2 for Linux, UNIX, and Windows stored procedures to log informational, error, and debug messages directly from the procedure itself. The logging framework methods use shared memory concepts to coordinate and cha