Using PowerExchange ODBC Connections in a Data Archive Retirement Project

Back Next

Step 5: Create PowerExchange Data Maps

For each IMS and VSAM data source that you want to retire, create a PowerExchange data map.

Before you create the data maps, select to use a two-tier naming convention for the data maps. To use a two-tier naming convention, click

Options > Preferences

, and on the

Data Maps

tab in the

Preferences

dialog box, select the

Use 2-tier names

option.

On the

Resources

tab in the

Resource Explorer

, click

Add

Data Map

In the

Name

dialog box, enter the following information:

Option	Description
Schema Name	Enter a user-defined schema name. PowerExchange uses this name as the first part of the data map name, as follows: `schema_name`.`data_map_name` The name must consist of alphanumeric characters and begin with a letter. Maximum length is 10 characters.
Data Map Name	Enter a user-defined map name. PowerExchange uses this name as the second part of the data map name, as follows: `schema_name`.`data_map_name` The name must consist of alphanumeric characters and begin with a letter. Maximum length is 10 characters.
Access Method	Select one of the following access methods: DL/1 BATCH . IMS database on z/OS. ESDS . VSAM Entry Sequenced Data Set (ESDS) on z/OS. IMS ODBA . IMS database accessed through a PowerExchange Listener on z/OS. KSDS . VSAM Key Sequenced Data Set (KSDS) on z/OS. RRDS . VSAM Relative Record Data Set (RRDS) on z/OS.
Import Record Definitions	Select this option to import a copybook into the data map. Clear this option to add only the data map. By default, this option is selected.