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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

Security for Capture Registrations and Extraction Maps - Examples

Security for Capture Registrations and Extraction Maps - Examples

You can grant data set and RACF class level authority for different types of users.
A
super user
can add and edit capture registrations and extraction maps, run database row tests against extraction maps to preview data, and extract change data. To permit a user to complete these tasks, grant the user all the following levels of access:
  • UPDATE access to the data set assigned to the DTLAMCPR DD name in the PowerExchange Listener JCL
  • UPDATE access to the data set assigned to the DTLCAMAP DD name in the PowerExchange Listener JCL
  • UPDATE access to the CAPX.REG.* resource profile
  • READ access to the CAPX.CND.* resource profile
To permit a user to view capture registrations and extract change data, including running a database row test against an extraction map and running workflow extractions, grant the user all the following levels of access:
  • UPDATE access to the data set assigned to the DTLAMCPR DD name in the PowerExchange Listener JCL
    This level of access does not grant the user the ability to create or amend capture registrations.
  • READ access to the data set assigned to the DTLCAMAP DD name in the PowerExchange Listener JCL
  • READ access to the CAPX.REG.* resource profile
  • READ access to the CAPX.CND.* resource profile
For example, to permit a user to run a database row test against an extraction map name with a prefix of CIW* for data captured from DB2 subsystem DB2P, grant the user READ access to the following resource profile:
CAPX.CND.DB2P.CIW*
To permit a user to run a database row test against an extraction map and run workflow extractions, but not view capture registrations, grant the user all the following levels of access:
  • READ access to the data set assigned to the DTLCAMAP DD name in the PowerExchange Listener JCL
  • UPDATE access to the data set assigned to the DTLAMCPR DD name in the PowerExchange Listener JCL
  • READ access to the CAPX.CND.* resource profile