In addition to direct data mapping of DB2 tables, you can also map DB2 unload files.
For DB2 unload files, PowerExchange supports the following IBM and BMC Software formats:
DB2 for z/OS online REORG TABLESPACE utility with UNLOAD EXTERNAL
DB2 for z/OS online UNLOAD utility
DB2 for z/OS sample unload program DSNTIAUL
BMC Software Unload Plus
DB2 for Linux, UNIX, and Windows High Performance Unload utility
When you run a database row test to test a DB2 unload file data map, select the NRDB data source type.
When you add a DB2 unload data map and select
DSNUTILB UNLOAD
for the
Unload Type
, PowerExchange includes a field for the OBID in the record. If you create DB2 unload files specifying HEADER NONE in the DB2 UNLOAD control statements, select
UNDEFINED
for the
Unload Type
.
PowerExchange cannot read large format sequential data sets. If you specify DSNTYPE=LARGE in the DD statement when you create the unload file, PowerExchange cannot read the file. Instead, you can specify DSNTYPE=EXTREQ in the DD statement.