(Martin Hubel) As a mainframe DB2 person who moved onto DB2 for Linux, Unix and Windows, I regularly compare the differences between the DB2 products that run on the z/OS platform and wide range of platforms supported by DB2 for LUW.

(Craig Mullins) DB2 9 for z/OS introduces a bevy of new built-in functions (BIFs) for programmers to use in their SQL statements. It is important to keep track of the BIFs available in DB2 because BIFs simplify your coding and development. Invoking a function is always easier than trying to write th

(Jeff Dutton) This article introduces you to the Enterprise Service Bus (ESB) concept and to the IBM products that provide ESB capabilities. It focuses on using an ESB on z/OS (System z). In addition to describing the IBM products that provide sophisticated ESB functionality, it describes some earli

(Scott Hayes) The secret to successful database performance tuning and optimization requires an intimate understanding of workload costs. You can become a Performance Hero in your organization by determining current workload costs, and then making physical design and configuration changes to lower t

(Kevin Forsythe) Despite our best efforts to achieve excellent database normalization, sometimes it’s necessary or simply more efficient to create a temporary table containing some data as of a certain time. SQL satisfies this need with Materialized Query Tables (MQT). These specialized SQL objects

(Dorian Birsan, Allen Chan, Anita Dave and David Van) This series of articles will evaluate the different approaches and design issues that you need to consider when you design an ESB solution. Part 1 describes usage patterns and design considerations for invoking services based on message content,

(Peter Plevka) With the number and size of DB2 database objects continually growing and the requirements of availability getting tougher every month, it is imperative to plan the reorganization of tables and indexes. This article examines options to consider for reorganization and automation, and it

(Bo Li, Wei Wang and LaiFeng Zhang) This article is the second in a series of three articles that guide you in learning how to build your own custom Business Process Management Web application. You’ll start from scratch, using the IBM FileNet P8 platform and the Business Process Framework (BPF), wit

A materialized query table (MQT) is a table whose definition is based on the result of a query, and whose data is in the form of precomputed results that are taken from one or more tables on which the materialized query table definition is based.

(Harald Smith and Ian Schmidt) IBM WebSphere Information Analyzer includes the IBM WebSphere AuditStage product, providing users with the capability to create, deploy, and monitor data validation rules over time. The reach of WebSphere AuditStage can be extended by leveraging the IBM WebSphere Feder