(Troy Coleman) Have you ever been asked to define a backup and recovery strategy for your DB2 subsystem? Or was your task was something smaller, like developing a recovery strategy for the DB2 tables used in a given application within your business area? The process of planning for an entire system

(Vikram Khatri) Thanks to Max Petrenko of DB2 Toronto Lab for sharing a very useful script to remove check pending status from the DB2 tables after LOAD or other operations. It is easy to generate a check pending script, but the importance of this script is that it builds the sequence in such a fash

(Holger Karn, Ute Baumbach and Torsten Steinbach) Distributed applications, although key to your business, often create serious challenges for DBAs who get panicked calls when response times go bad. Although a system administrator might be able to tell that there is a problem with a database applica

(Leon Katsnelson) We are in the process of refreshing free DB2 Express-C to the new level i.e. v9.5.2. There are lots of enhancements that you will get as a result of this refresh. Customers that had DB2 Express-C subscription did have these enhancements delivered as part of FixPack 1 and FixPack 2.

Julian Stuhler addresses DB2s ease of use, compression capabilities and his experience of working with IDUG. (video)

(Mark Baldridge) In this installment of the UniVerse performance series, explore the cost of opening files in BASIC programs. Measure opening simple hash files, dynamic files, and directory files, and measure the impact of adding indices to files. Time open distributed files, with and without indice

(Robert Catterall) Stored procedures have long been a mainstay of enterprise-class applications built on a DB2 for Linux/UNIX/Windows foundation. They provide for robust security (among other things, keeping the SQL DML statements server-side helps to restrict what people with ill intent can learn a

(Mark Mulligan) A critical part of any database disaster recovery plan is to make sure that the environment surrounding the database is the way it was before the disaster in order to provide the same level of performance and level of service to users after a recovery. This article explains a process

(Matthias Nicola and Martin Sommerlandt) The values of XML elements and attributes are, by definition, case sensitive. For example, if you search elements for the value “Paris,” you will not find “PARIS” or “paris.” This can be solved with XQuery functions such as fn:upper-case(), but the per

(Craig Mullins) I’m sure you’ve heard that age old expression that there is no such thing as a free lunch, right? Well, sometimes even the old tried and true sayings can be wrong. No, I’m not going to tell you how to eat lunch for free, but you can get some helpful DB2 mainframe software for free!