Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

MVSDB2AF Statement

MVSDB2AF Statement

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:
jobname
||
user_id
||
task_id