Bulk Data Movement Guide

10.5
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Using IMS Unload Data Sets as Data Sources

You can use an IMS unload data set as a data source for a PowerExchange bulk data movement operation. To create the unload data set, use either the IBM unload utility for your IMS database type or the Unload function of the BMC Database Management for IMS solutions.

For example, to materialize a target based on an IMS source, create an IMS unload data set that contains the source data of interest. Then use that data set as input to a PowerCenter workflow that materializes the target. After target materialization is complete, use PowerExchange change data capture (CDC) to synchronize the source and the target.

For unload data sets, PowerExchange can perform group source processing. That is, PowerExchange can process multiple IMS segments by reading the entire unloaded database in a single pass.

The following table shows the unload record formats and key definition methods that you can use for different types of IMS databases:

IMS Database Type	Format of Unload Records	Get CCK?	Get Key Value by Using GetDatabaseKey Function?	Get Key Value by Using GetIMSRBAByLevel Function?
Fast Path ¹	IBM	Yes	Not available	Not available
Fast Path ¹	BMC LONG	Yes	Yes	Yes
HALDB	IBM	Yes	Yes	Yes
HALDB	BMC LONG	Yes	Yes	Yes
HDAM	IBM	Yes	Yes	Yes
HDAM	BMC LONG	Yes	Yes	Yes
HDAM	BMC SHORT	Yes	Not available	Not available
HDAM	BMC XSHORT	Yes	Not available	Not available
HIDAM	IBM	Yes	Yes	Yes
HIDAM	BMC LONG	Yes	Yes	Yes
HIDAM	BMC SHORT	Yes	Not available	Not available
HIDAM	BMC XSHORT	Yes	Not available	Not available
HISAM	IBM	Yes	Not available	Not available
HISAM	BMC LONG	Yes	Not available	Not available
HISAM	BMC SHORT	Yes	Not available	Not available
HISAM	BMC XSHORT	Yes	Not available	Not available
1. PowerExchange does not support IMS Fast Path SDEP segments.

For BMC Software unload data sets, the record formats of LONG, SHORT, and XSHORT are specified by the DFSURGU1 keyword in the PLUSIN DD statement of the BMC Unload JCL.

The table shows that PowerExchange can get a concatenated key (CCK) for all unload record types. For unkeyed segments, PowerExchange can process any GetDatabaseKey and GetIMSRBAByLevel functions that you define in a user-defined field in an IMS data map to return a value that can be used as key. The GetDatabaseKey and GetIMSRBAByLevel functions return an 8-byte RBA value for a specific segment.

To add the segment RBA to segment data in an IMS data map, Informatica recommends that you use the GetIMSRBAByLevel function rather than the GetDatabaseKey function. The GetIMSRBAByLevel function enables you to get the RBA of an unkeyed or non-unique keyed parent segment.

Use the GetDatabaseKey and GetIMSRBAByLevel functions in IMS data maps used for bulk data movement operations or IMS synchronous CDC.

You cannot use the GetDatabaseKey or GetIMSRBAByLevel function in the following types of data maps:

IMS data maps used for IMS log-based CDC

IMS data maps used to access IMS unload files that contain the following types of records:

Unload records of any format for HISAM data sets

Unload records that have the format BMC SHORT or BMC XSHORT for HDAM and HIDAM data sets

Unload records that have the standard IBM format for IMS Fast Path data sets

Bulk Data Movement and IMS Unload Files

Materializing a Target from an IMS Unload Data Set

Download Guide

Watch

Comments