(Craig Mullins) In DB2 does ‘width’ refer to the number of bytes (average) in a row? (R)

(Tony Lau) This article provides the instructions and sample scripts for setting up SPECjAppServer2002 on DB2 UDB and WebSphere. The scripting approach can turn the setup task from a whole day of struggling to a single enjoyable learning hour.

(Kulvir Singh Bhogal) Many users of DB2 data don’t have the ability or desire to roll up their sleeves and use the DB2 command line to manipulate DB2 data. End users of the database might be business users who would not touch SQL with a ten foot pole. However, the business may require these individu

(Victor Alvarez) An upcoming release of DB2 UDB for Linux, Unix, and Windows contains a slew of new features and support for emerging technologies. Among those features is support for Microsoft’s Common Language Runtime, the software giant’s answer to Java.

(George Baklarz and Bill Wong) Access to both local and remote databases uses entries in the DB2 directories. The directories hide the requirement for the user to know where a database actually resides. Users are able to connect to local databases and remote databases (including DRDA databases) by s

(Bob Swart) In this article, I will use Borland Kylix 3 for C++ on Linux to work with IBM DB2 Universal Database (UDB) tables. Kylix 3 produces native Linux executables, and is available for Delphi and C++ as a development language.

(Craig Mullins) Will a clustering index prevent an ORDER BY? (R)

(Charles Babcock) Software developers at Northern Trust Corp. earlier this year made a change in one of the bank’s IBM DB2 database systems that resulted in an error that, if left unattended, could have interrupted the bank’s ability to produce a handful of timely reports.

(Craig Mullins) What effect, if any, would hardware compression have on the storage of NULLs in a DB2 databse? Would it save any space? (R)

(Sean McCown) Being able to merge, query, and transform transmitted data with relational data is becoming as essential to businesses as data warehouses themselves. The good news is that the four leading relational databases, namely Oracle Database, IBM DB2, Sybase ASE (Adaptive Server Enterpri