(David) As with all RDBMS implementation, DB2 UDB uses the statistics information in the catalog table to derive the best execution plan. We, as DBAs, should regularly run the RUNSTATS command to keep our database statistics updated for optimal query performance.

(Leons Petrazickis) Follow this case study for quickly creating an elegant, responsive Web application using IBM DB2 9 for Linux, UNIX, and Windows, XQuery, PHP, and the Dojo Javascript Framework. The case study is based on IOD Planner 2006, a Web application that was used for the IBM Information On

(Victor Rubba) In the last few weeks I’ve had the opportunity to get to know Coldfusion just a little bit better. One of the first challenges I faced is getting CF talking to Db2, so I could take advantage of the CF Extensions for Flexbuilder and that funky Wizard. To be precise I used ColdFusion MX

(David) DB2 has a nifty feature that allow you to view the list of active utilities on the instance.

(Sunil Sabat) The material in this tutorial primarily covers the objectives in Section 2 of the exam, entitled “Data manipulation.” (R)

(Diane Chalmers, Dana Duffield, Mark Luchini and Brian Stelzer) Planning is the key to maintaining uptime when migrating a high availability environment to a new version of IBM WebSphere Application Server. This article discusses key points to help you plan to successfully migrate your highly availa

(Bill Wilkins and Yasir Warraich) This article discusses lock waits, deadlocks, and escalations, and tells you how to monitor them, and what to do about them using DB2 for Linux, UNIX, and Windows. Sample monitoring scripts are included.

(Craig Mullins) As regular readers of this blog know, I regularly attend and speak at the SHARE user conferences held twice annually. The Spring 2007 SHARE conference is being held this week, February 12 thru 16, 2007, in Tampa, Florida. It is now Wednesday, mid-way through the week, and time for me

(Diana Lau and Ivy Ho) Welcome to the ninth tutorial in the “Hello, World” series, which provides high-level overviews of IBM software products. This tutorial gives you an introduction to WebSphere Federation Server. It includes two practical exercises where you will create data sources from a DB2 d

(Willie Favero) Hot Topics Newsletter is being distributed in hardcopy at SHARE this week. It is published twice a year and usually packed with interesting article about stuff that runs in z/OS. One of the article authors pointed out a nice article covering DFSORT and the DB2 V8 Utilities (page 8).