(Chris Eaton) If you are new to DB2 LUW from a DB2 for z/OS background then the first thing you probably noticed is that there is no subsystem on the LUW platform. Instead you will hear the term Instance used in a similar manner. An instance in DB2 for LUW is like a copy of the RDBMS including all t

(R. Vijaya) On AIX, and UNIX in general, DB2 instance creation fails with vague errors: Update DBM cfg SYSADM_GROUP errcode = 8 DBI1281E The database manager configuration file could not be initialized.

(Mark Chiang and Daniel Debrunner) Some of the functionality described in the IBM DB2 Universal Database (DB2 UDB) SQL Reference for Cross-Platform Development Version 1.1 is not supported by Derby. This article lists these differences. This comparison was developed by reviewing the DB2 UDB SQL Refe

(Saida Davies and Peter Broadhurst) This Redbook describes the fundamental concepts and benefits of message queuing technology. It is an update of a very popular redpaper (REDP0021), based on WebSphere MQ V5.2.

(Peter Sa) Much has been written about how IBM’s autonomic technologies have made the iSeries easier to manage. When it comes to high availability solutions, however, self-managing, self-healing, self-auditing, and adaptively self-learning solutions were considered out of reach. Not so any longer.

When you are using Microsoft Host Integration Server 2004 OLE DB Provider for DB2 or Host Integration Server 2000 OLE DB Provider for DB2, you may receive an error message that is similar to the following when you run a query: OLE DB provider ‘DB2OLEDB’ returned an unexpected data length for the

(Reinhold Engelbrecht) This article explains a sample DB2 CommonStore for Lotus Domino (CSLD) customization of a R6.5 mail template when accessing it from the Notes Client. This article focuses minimizing the necessary user intervention for retrieval (retrieve on open) for the typical office user wh

The concept of “packages” in the DB2 Universal Database (UDB) system is often not well understood. This paper provides both general information about what packages are and how they are created and bound, as well as specific information about both the DataDirect Connect for ODBC (32-bit) and DataDire

(Marina Greenstein) Many relational databases (including Sybase, Oracle, Microsoft SQL Server, and Informix) support the bit data type or Boolean data type for column definitions, and provide bitwise or Boolean functions for these types of data. T-SQL also provides bitwise operations – AND, OR,

(Kevin Czap) Do you want to know how to build a PHP database application from scratch? This tutorial shows you how to install the IBM DB2 Run Time Client, which allows you to access the IBM Cloudscape database. We also install and configure the Apache Web Server to host the application and compile a