Archive for the ‘IBM: DB2 Articles’ Category

Migrate from EJB 2 container-managed persistence to pureQuery for IBM Master Data Management Server, Part 1: Evaluating pureQuery technology

Thursday, July 3rd, 2008

Source

If you’ve been curious or confused about the new release of WebSphere Customer
Center (now named IBM InfoSphere Master Data Management Server), then this series is
for you! This series describes how and why pureQuery technology was used in the new
release, the implementation and migration to pureQuery, and the results of
performance and capability testing to validate this critical decision. Part 1 focuses on the evaluation of persistence mechanisms and our plan to validate the technology.

Replication technologies in Informix Dynamic Server

Thursday, July 3rd, 2008

Source

IBM Informix Dynamic Server (IDS) has long been a database with powerful
replication technologies. Enterprise Replication (ER) and High-Availability
Data Replication (HDR) have been faithfully serving customers for years.
Recent versions of IDS, 11.1 and now 11.5, add some new technologies to these
stalwarts: the Remote Standalone secondary and the Shared-Disk secondary
servers. In this article, get a brief characterization of each replication
technology and details on the basics of using each.

IBM Migration Toolkit support for migrating data from MySQL to DB2 and Informix Dynamic Server

Thursday, July 3rd, 2008

Source

The IBM Migration Toolkit has been enhanced to include new capabilities
for migrating from MySQL to DB2 or Informix. In this article, you’ll learn how
the toolkit can help you migrate DDL and DML statements, and see how to map
data types.

Shrink your DB2 for Linux, UNIX, and Windows database using value compression

Thursday, June 26th, 2008

Source

Since Version 8.1, IBM DB2 for Linux, UNIX, and Windows has had a
compression feature called value compression. This feature is not well-known, but it
provides a cost-efficient way to reduce the size of your database with almost no
impact on performance. In this article, find background information on value
compression, and learn about a script-based method to easily find tables that
benefit from value compression.

IBM Mashup Center and the InfoSphere MashupHub, Part 1: Get started with InfoSphere MashupHub

Thursday, June 26th, 2008

Source

Learn about the architecture, tools, and utilities of InfoSphere MashupHub, part of the IBM
Mashup Center product. Then, explore a simple use case scenario that showcases the
different components and illustrates the advantages of using Web 2.0 concepts. This
article is the first in a two-part series.

IBM Cognos 8 BI tips and techniques: Change the name of a PowerPlay report in Cognos Connection as it appears in Upfront

Thursday, June 19th, 2008

Source

Download a Java sample that gives you a way to rename Cognos PowerPlay
Enterprise Server views and reports so that they are the same as they appear in Cognos
Upfront. Get step-by-step instructions for implementing this code sample.

Using IBM Lotus Domino and IBM DB2 integration features to enhance the functionality and performance of Lotus Domino applications

Wednesday, June 18th, 2008

Source

Learn how to use IBM® DB2® as a data store for IBM Lotus® Domino® data. This article uses a sample application to describe four possible usage scenarios for the Lotus Domino and DB2 integration features in pure Lotus Domino applications.

Dynamic SQL support in Informix Dynamic Server Stored Procedure Language

Wednesday, June 18th, 2008

Source

Review the SPL and the capabilities uniquely available
with dynamic SQL, and then explore many examples that help you get started with
implementing this feature in your own databases. Also, take a look at security issues and see how to avoid pitfalls.

Compare the Informix Dynamic Server Version 11 editions

Wednesday, June 18th, 2008

Source

Get an introduction to the various editions of IBM Informix Dynamic Server, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, IDS brings you legendary ease-of-use, reliability, stability, and access to extensibility features.

IBM DB2 for i 6.1 — Sophistication simplified

Wednesday, June 18th, 2008

Source

The IBM DB2 for i 6.1 enhancements provide a great foundation for taking
your business solutions to new levels. In this article, discover how IBM has
delivered the new, sophisticated technology while still maintaining the easy-to-use
nature of DB2 for i that has spoiled developers and administrators through the
years.