To Next Page

To Previous Page

IBM Licensed Programs: Database Accessories 529

IBM Licensed Programs: Database Accessories

spill files. This results in a significant performance gain. Users of the remote journal

set-up are the primary beneficiaries of this performance enhancement.

iSeries Replication Extensions

• Remote Journal: DB2 DataPropagator Version 7.1 can use the remote journal

function. The

Capture

component can capture changes from a journal setup for remote

journal. Journal receivers are replicated to another system by the operating system

function of the remote journal. The

Apply

component is modified to access the actual

source to a staging area that eliminates work file processing.

• Relative Record Number Support: This function addresses the problem where a

unique key could not be found for a copy table. It allows a user to have a unique key

for CCD and Point-in-time target tables when no combination of target columns is

unique.

IBM DB2 DataJoiner Version 2.1.1 (5801-AAR Feature #3049)

DB2 DataJoiner Version 2.1.1 allows access to the joining of data from different data sources

with a single Structured Query Language (SQL) statement and a single interface. That single

interface hides all the differences that cause problems when accessing information from

different vendor databases on different vendor platforms. With DataJoiner, there is one

interface to one database image. It's like having one big database.

DB2 DataJoiner Version 2.1.1 is available on two platforms: AIX and Windows NT.

With DB2 DataJoiner Version 2.1.1, you only need to send one query to get the answer from

different data sources. These sources include DB2, IMS, VSAM, Oracle, Oracle Rdb, Sybase,

Sybase SQL Anywhere, Microsoft SQL Server, Informix, and others. Global schema allows

the creation of joins or views across all of these data sources, easily and transparently. There

is only one SQL interface to deal with.

IBM DB2 DataJoiner Version 2.1.1

Product number 5801-AAR Feature #3049

Replaces product IBM Data Joiner Version 2.1

Minimum OS/400 level AIX and Windows NT (on the IXS) only

Installation prerequisites

Related products DB2 Spatial Extender Version 2.1.1

IBM i Series Handbook

Other manuals for IBM i Series