The MVSDB2AF statement specifies which DB2 for z/OS attachment facility PowerExchange uses for DB2 bulk data movement operations.
z/OS
DB2 for z/OS
No
MVSDB2AF={
CAF
|RRSAF}
CAF
.
PowerExchange uses the DB2 call attachment facility (CAF) to connect to DB2.
When you use CAF, PowerExchange and DB2 use the user ID of the PowerExchange Listener or netport job for authentication of DB2 resources.
RRSAF.
PowerExchange uses the DB2 Resource Recovery Services attachment facility (RRSAF) to connect to DB2. To control user access to DB2 tables, specify RRSAF.
RRSAF enables PowerExchange to sign on to DB2 and use the user ID of the user that requested the bulk data movement operation for authorization of DB2 resources.
To use RRSAF, you must configure and run RRS on the z/OS system.
Default is CAF.
If you specify RRSAF, PowerExchange uses the following values for correlation-id and accounting-token when signing on to RRSAF:
correlation-id
PowerExchange uses one of the following values:
If provided, PowerExchange uses the value specified for the Correlation ID connection property in the PowerCenter Workflow Manager or informatica Developer tool.
If no value is specified in the client for the Correlation ID connection property, PowerExchange uses the value specified in the SESSID statement in the DBMOVER configuration file on the PowerExchange Listener machine.
If no value is specified in the client Correlation ID connection property or in the DBMOVER configuration file on the PowerExchange Listener machine, PowerExchange uses the default value of DETAIL.
accounting-token
PowerExchange concatenates the 8-byte job name, 8-byte user ID, and 6-byte task ID: