Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Granting Authorities for Access to DB2 Resources

Granting Authorities for Access to DB2 Resources

Grant the appropriate authorities to PowerExchange to execute the PowerExchange DB2 plan and to access the DB2 catalog and source and target tables.
To grant authorities for access to DB2 resources:
  1. Issue the following SQL GRANT statements:
    GRANT EXECUTE on PLAN
    db2_plan_name
    to
    user_id              
    [for the DB2 plan] GRANT SELECT on SYSIBM.SYSTABLES to
    user_id                 
    [for the DB2 catalog] GRANT SELECT on SYSIBM.SYSCOLUMNS to
    user_id
    GRANT SELECT on
    creator
    .
    table
    to
    user_id                   
     [for each DB2 source table] GRANT INSERT on
    creator
    .
    table
    to
    user_id                   
     [for each DB2 target table]
    Where:
    • db2_plan_name
      is the DB2 plan name that is specified in the DB2PLAN statement in the DBMOVER configuration member.
    • user_id
      is the z/OS user ID or PowerExchange Listener user ID that is associated with the user request to access DB2 source or target data by means of the PowerExchange Listener.
    • creator
      .
      table_name
      identifies a specific DB2 source or target table that is involved in bulk data movement.

0 COMMENTS

We’d like to hear from you!