(Samir Kapoor, Sudharsan Selvarajah and Kaarel Truuvert) Evaluating real time cardinality in IBM DB2 Universal Database (DB2 UDB) versus the estimated cardinality in the access plan can help DBAs make various decisions to improve query performance. Here are all the details to create count queries to

(Chris Eaton) In my last few postings I’ve mentioned some new features that were shipped in 8.1.4 and 8.1.7. Let’s take a look at another useful feature that may have eluded you from 8.1.4 (who reads the README anyway 🙂 ).

(Birgit Roehm, Thomas Erker, Carrie Finneran, Ken Klingensmith, Vijay Mann, Kwan-Ming Wan and Peter Wiedeking) This redbook gives a broad understanding of IBM WebSphere Extended Deployment V6.0. It explains the various functions and features of this product and will help you to design and create a s

(Chris Eaton) This posting is a follow-up to the comments made on my last posting. Enrique Valdez asked if it was possible to change the lock wait behavior for a given application from within the application itself. For example, would it be possible for a given transaction to never wait for a lock w

(Debra R. Eaton) The IBM DB2 Universal Database (UDB) plug-ins for Rational Application Developer give developers the ability to connect, browse and alter DB2 databases. In this tutorial learn how the Rational Application Development perspectives, views and wizards assist you with defining and worki

(Robert Catterall) I hate to be the bearer of unpleasant news, but you should know that bad things happen to good computer systems. Sometimes the problems are facilities-related: power failures, cooling-system failures, plumbing problems, and the like. Sometimes a server or disk subsystem or some ot

(Craig Mullins) We have an issue in our OLTP and Datamart 24/7 design (both on DB2 UDB V8.1 on AIX). While running ETL against the OLTP database, if the ETL process uses “Cursor Stability” isolation, it potentially locks out other users. So we changed isolation to “Uncommitted Read.” This added a ne

(Chris Eaton) In addition to the DB2_SKIPINSERTED registry variable I discussed in my last posting IBM delivered the DB2 _EVALUNCOMMITTED feature in 8.1.4. By setting this registry variable to ON, DB2 will examine rows that are currently locked as the result of a currently uncommitted transaction.

(Wally Terhune) Database and system administrators who are responsible for a UniData system that has the Recoverable File System (RFS) feature enabled will find this article most helpful. All RFS status and error messages are recorded in the $UDTBIN/sm.log file. You will find examples to help you fi

(Nagraj Alur, Neale Armstrong, Tadakatsu Azuma, Christian Daser and Manuel Mueller) This IBM Redbook provides an overview of IBM’s event publishing solution delivered via its WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher products, and d