(Ravinder Bahadur) Here is a simple way to provide a format for date fields in DB2. More complicated formating will need to use the to_char() function available on IBM’s web site. (R)

(Bob Swart) This article shows how to extend an ASP.NET Web Service application to let clients update the database.

(Michael Dougherty) Information security is a critical element of business operations. Yet, surprisingly few organizations have integrated security policies, measures, and technologies to protect their information assets against internal and external threats. Billions of dollars’ worth of productivi

(John Irwin) This article looks into some of the steps necessary to locate and tune DB2 application performance problems. It will: –Discuss the tools and structures needed for DB2 tuning. –Address the identification of DB2 performance problems, and the initial reports and processes used for t

(Kenneth Chen, Peter He, Tawei Hu, Ed Gallagher) The inevitability of e-business is a reality. Today, as e-business evolves, it is more than Websites that offer e-Commerce transactions. Instead it represents an entire business process transformation, from back office to front office, requiring not o

(Peter Gulutzan and Trudy Pelzer) This article describes how IBM implemented the DATE data type for DB2 and discusses what calendar is used, what the JULIAN_DAY function really does, why date arithmetic is random, how to calculate birthdays, and how to find month ends using DB2. (R)

(Brian Venn) Picture the scene, you are responsible for the installation of DB2 in a department where machines are constantly being cleaned and re-imaged, with developers and testers alike requesting “I need DB2 V8 with fixpack X installed on machines X,Y, and Z ASAP”. You could end up spending hour

(Robert Westervelt) A vulnerability in IBM’s DB2 could allow attackers to gain administrative privileges on systems running version 8.1 Enterprise Edition of the database on Windows. (R)

(Lijun Gu) IBM DB2 Replication (called DataPropagator on some platforms) is a powerful, flexible facility for copying DB2 and/or Informix data from one place to another. The IBM replication solution includes transformation, joining, and the filtering of data. You can move data between different plat

(Dan Tuck) This quickly generates a command to force off applications connected to a specific database. The DB2 command “force application all” is too wide in its effect. This tip provides the needed command for a specific database. Just cut-and-paste the command to execute it. It has been tested on