In the

Access Method

list, select

ESDS

,

KSDS

, or

RRDS

, depending on type of VSAM data set that you are using as the source or target.

Select the

Import Record Definitions

option to be prompted to import metadata for VSAM records from a COBOL or PL/I copybook. If you do not select this option, you can import a copybook later by clicking

File

 

>

 

Import Copybook

.

Select the

Prefix record with XRBA value

option for an ESDS data set or the

Prefix record with RRN value

option for an RRDS data set if you want PowerExchange to add an 8-byte XRBA or RRN value as a prefix in each record. If you select either option, make sure that the record layout in the data map includes sufficient space to accommodate the XRBA or RRN length.

Select the

CI ACCESS

option if you want the PowerExchange to access the contents of the entire control interval rather than individual data records when reading VSAM data set. If you want to extract all data from the control interval, this option might improve sequential read performance. However, if you specify a WHERE clause, this option does not improve performance.

For KSDS data sets, set the

Offload Processing

option to control if PowerExchange offloads processing for converting and merging data records from the PowerExchange Listener on the z/OS system to the system where extraction processing occurs. The extraction system is usually the system where the PowerCenter Client and PowerCenter Integration Service run.

In the

Number of Data Buffers

field, enter the number of I/O buffers to use for the data control intervals that PowerExchange requests VSAM to allocate. Increase the number of buffers to improve sequential access performance. In the

Number of Index Buffers

field, for KSDS, RRDS, and VRDS data sets only, you can also specify the number of I/O buffers to use for index control intervals. These buffer values override the VSAM statement, if specified, in the DBMOVER configuration member on the z/OS system.

Complete the other fields as needed. Click

Finish

when you are done.

Restriction:

PowerExchange does not support the CI ACCESS option for compressed data or spanned records.

If you did not select the

Import Record Definitions

option, go to step Moving VSAM Bulk Data.

If you selected the

Import Record Definitions

option, The

VSAM Copybook - Source Details

page is displayed.