Use the following procedure to move Adabas bulk data.
Before you begin, gather the following information:
TCP/IP address or host name of the host that contains the Adabas database
Adabas database ID
Adabas file numbers for the files to be accessed
Your z/OS user ID and password, if required by the security settings in the SECURITY statement in the DBMOVER configuration file
To move Adabas bulk data:
In the PowerExchange Navigator, create a data map.
Click
ADABAS
in the
Access Method
list. To import metadata about data source records and fields, also select the
Import Record Definitions
option, the
Import Key Fields/FDT
option, or both.
If you do not select the
Import Record Definitions
or
Import Key Fields/FDT
option, you can import the metadata later. Open the data map in the Resource Explorer and click
File
>
Import Copybook
.
Open the data map in the Resource Explorer, and click the nonrelational “record” or relational “table” view to verify that the metadata was successfully retrieved.
If the data map is for a data source, send it to the PowerExchange Listener on the remote Adabas system. In the Resource Explorer, select the data map and click
File
>
Send to Remote Node
. This step enables PowerExchange extraction routines to access the data map at runtime.
In the
Location
field, enter the PowerExchange Listener node name that is specified in the NODE statement of the dbmover.cfg file on the local PowerExchange system. Complete the other fields, as needed.
If you do not complete this step, you are prompted to send the data map to the remote node when you run a database row test.
Run a database row test on the table view of the metadata to test that actual data can be returned from the Adabas source database.
In the PowerCenter Designer, import the PowerExchange data map and create a mapping.
In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX NRDB Batch application connection. Then start the workflow to perform the bulk data movement.