(Robert Catterall) During a data warehousing presentation at the International DB2 Users Group conference in Warsaw last October, IBM’s Willie Favero showed text from the 1983 announcement letter that introduced the DB2 database management system. That announcement positioned DB2 as an excellent fou

(Chuck Ballard, Silvio Ferrari, Robert Frankus, Sascha Laudien, Andy Perkins and Philip Wittann) In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus

(Craig Mullins) BIND and REBIND are important components in assuring efficient DB2 applications. Because the BIND/REBIND process determines exactly how your DB2 data is accessed it is important that you develop an appropriate strategy for when and how to REBIND your programs.

(Bryan Patterson and Dexiong Terry Zhang) Form processing is one of the major daily tasks in many public and private businesses. Processes based on paper forms are resource intensive, time consuming, and often result in inaccurate or incomplete data. This article describes how you can build an effic

(Henrik Loeser) One question I hear a lot is: What XQuery features are supported by DB2 pureXML? My standard answer is “All the features you need!”. But what are they?

(Troy Coleman) DB2 V9 delivered new features that make it much easier to port applications to DB2 for z/OS. One of these features is the implicit creation of a database for the create table statement when an explicit database name isn’t given.

(Paolo Bruni, Felipe Bortoletto, Thomas Hubbard, Ernest Mancill, Hennie Mynhardt and Shuang Yu) In this age of complex regulatory oversight and wide ranging threats to corporate data, securing a company’s information assets from internal and external threats has become a primary focus and concern fo

(Bernard Z. Kufluk and Ian Hodges) Keep your Universal Description Discovery and Integration (UDDI) registry current with this simple utility for importing new canonical tModels (technical models). The utility ensures that newly defined canonical tModels are saved to your IBM WebSphere Application S

(David Beulke) Even though COBOL application development continues to grow, Java is the dominant development language used in applications that access DB2 for Linux, Unix, and Windows as well as for z/OS today. Most veteran DBAs already know how to debug COBOL applications. These performance tips wi

(Willie Favero) At about this time one week from now (May 11), I should be boarding a Continental Airline’s flight at Houston’s IAH airport heading for Denver, CO and IDUG 2009. I have to tell you, I’m not looking forward to the flight (seat map shows it is almost a completely full 757) but I am loo