Technical Articles

The Technical Articles section provides a wide variety of detailed technical content covering a wide area of material which has been written by our technical team members.

 


Easy IWA: Part 3 Creating and Loading Data Marts under IBM Informix 12.10.FC4 and IBM Informix Warehouse Accelerator

Abstract

This third article in the Easy IWA series provides specific worked examples of creating two Data Marts under IBM Informix Dynamic Server and IBM Informix Warehouse Accelerator 12.10.FC4. Both examples use the “smart mart” utility, with the first example loading from external tables into IBM Informix tables and subsequently into an IWA Data Mart; the second loads directly into an IWA Data Mart from external tables. Both examples use the TPCH data generation utility and schema as detailed in a previous article, with the addition of the removal of unsuitable “*_comment” columns via a simple in-line pipe and sed or awk approach.


Easy IWA: Part 2 Creating an IBM Informix Warehouse Accelerator under 12.10.FC4

Abstract

This second article in the Easy IWA series details how to create an Accelerator under IBM Informix 12.10.FC4 Workgroup and Advanced editions. Worked examples to establish initial memory requirements are provided, which is key to effective and efficient resource usage and ensuring that initial provisions are reasonable. The Accelerator provides the interface between IBM Informix and the Warehouse Accelerator, performing mart administration and query processing.


Easy IWA: An Introduction to the Easy IWA Technical Articles Series

Abstract

This article provides an overview of the Easy IWA Technical Articles Series. Using the TPCH database schema, Data Generation utilities and sample queries from http://www.tpc.org, this series covers everything to get up and running with IBM Informix Warehouse Accelerator including data generation, creation of an accelerator, loading a Data Mart and running a set of queries.


An Introduction to the IBM License Metric Tool (ILMT)

Abstract

ILMT is an ever increasingly more important piece of software with the growth in usage of virtualized technology. This article provides a brief overview of what ILMT is, why it may be relevant and some considerations with deployment.


Pages