(Alex Woodie) Profound Logic last week announced from COMMON the general availability of iData, its new Web-based database editor for DB2/400 that it first unveiled late last year. The company will sell three versions of the tool, including one version that’s free and other versions that allow users

(Jarek Miszczyk ) With V6R1 DB2 for i5/OS, the transition of SQL workloads from Classic Query Engine (CQE) to the new SQL Query Engine (SQE) has been basically completed. So far, the SQE functionality has been delivered in six waves: 1. V5R2 GA 2. Mid-V5R2 (Check APAR II13486) 3. V5R3 GA

(Troy Coleman) The SQL enhancements that have been delivered in recent DB2 releases is amazing. To answer some business questions, programs must be written to process multiple SQL statements. However, with each release of DB2, more and more processing can be pushed into SQL, removing the need to wri

(Abdelilah Lali) Your mission, should you choose to accept it, is to learn the fundamentals of business process management (BPM). Play the strategic IBM BPM-simulation game, Innov8, in which you focus entirely on BPM activities. Interact with other virtual employees, participating in their daily act

(Willie Favero) A few weeks ago I posted why it’s important to belong to your local DB2 Regional User Group (RUG) (read post HERE). One of the things I did NOT mention in that post was the potential financial advantages that exist as a RUG member.

(Dirk Fechner) The combination of the db2pd tool and the db2cos script can be used to gather information about the reason for a SQL0911N lock timeout error, as discussed in “Analyzing lockwait situations in DB2 for Linux, UNIX, and Windows” (developerWorks, Jul 2007). With DB2 9.5, the options for l

(Roger Sanders) Here are more sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.

(Vivek Agarwal) Recently, I installed Quickr v8.1 in a VMWare instance and wanted to share the VM with my co-workers. For this to work, I gave my original VM a generic hostname (quickr) and intended that once co-workers copied the VM over to their VMWare Server, they would end up renaming the hostna

(Willie Favero) I have a couple of hipers today and one special attention / new function APAR for DB2 9 that looks like something most should be interested in.

(Laura Olson and Andre Tost) In this article, learn how you can integrate IBM WebSphere Service Registry and Repository (WSRR) with IBM DB2 pureXML. The WSRR product helps you establish governance around your use of XML schema, while the DB2 pureXML XML schema Repository ensures integrity of your XM