(Chris Eaton) The last video I wanted to highlight in this series is from Mr. Paul Turpin from Wachovia on how they are leveraging DB2 for Linux, UNIX, and Windows to support their business needs.

(Dave Beulke) There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application. Within most of the system and application performance reviews done at one recent client

(Sanjit Chakraborty) Everyones looking for strong IT strategies that limit business downtime due to data unavailability. Using a hot backup solution with Informix Dynamic Server can dramatically reduce business downtime.

Yes, you almost need nothing to set up before you try out pureXML in DB2 9 for z/OS if you are in DB2 9 NFM and have SPUFI for DB2 9. Here is how: download XMLQuickDemo I just posted in my previous blog entry. And log on to TSO and get to SPUFI, and copy the SQL statements from the […]

(Raul F. Chong) IBM DB2 Express-C has been enhanced with several important features and improvements that were previously available only with fee-based versions of DB2 for Linux, UNIX, and Windows. Learn how you can take advantage of new capabilities such as DB2 Text Search, the administrative task

(Tom Glaser) When you hear the term query monitor, what are the first things that come to mind? Most people think of performance issues with an SQL statement, excessive CPU, or reviewing elapsed or wait times. Some think of checking to see how many times an SQL statement is executed or what objects

(Vikram Khatri) If you use MTK (Migration Toolkit from IBM) to migrate your database to DB2 on Windows platform, the migration goes smooth but you may see problem when you FTP data file and LOAD script to Unix platform if you do not do it right.

(Jeffrey Benner) I believe that the IBM LDAP authentication plug-in version 1.2 for DB2 version 9 on Solaris 10 does not correctly failover to a new LDAP server on the IBMLDAPSecurity.ini file keyword LDAP_HOSTS when a prior server on the LDAP_HOSTS list becomes unresponsive.

(Willie Favero) DB2 for z/OS Version 8 had some significant changes to its product documentation in December also. I didn’t mean the slight the older DB2 release in my DB2 9 post yesterday. I had originally intended making to two post yesterday, one or each version. However, once the first first pos

(Roger Sanders) This latest round of DB2 9 DBA sample questions tests what you know about system catalog queries and utilities for presenting Explain information. After you’ve conquered this set, browse past questions here.