(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.
Tag: IBM
Develop a Web application using Ajax with Dojo and DB2
(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
Setting up Db2 v9 as a Coldfusion Datasource
(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
Monitor db2 backup, restore and recover operations in real-time
(David) DB2 has a nifty feature that allow you to view the list of active utilities on the instance.
DB2 9 Application Development exam 733 prep, Part 2: DB2 data manipulation
(Sunil Sabat) The material in this tutorial primarily covers the objectives in Section 2 of the exam, entitled “Data manipulation.” (R)
WebSphere migrations: Planning an iterative migration of a high availability environment to WebSphere Application Server V6.1
(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
Diagnose and resolve lock problems with DB2 for Linux, UNIX, and Windows
(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.
A Report From SHARE
(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
Hello World, Part 9: WebSphere Federation Server
(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
Hot Topics Newsletter from IBM, DFSORT, and DB2
(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).
