Preface
Part 1: PowerExchange CDC Introduction
- Change Data Capture Introduction
Part 2: PowerExchange CDC Components
- PowerExchange Listener
- PowerExchange Logger for Linux, UNIX, and Windows
Part 3: PowerExchange CDC Data Sources
Part 4: Change Data Extraction
Part 5: Monitoring and Tuning
- Monitoring CDC Sessions
- Tuning CDC Sessions
Appendix A: DTL__CAPXTIMESTAMP Time Stamps
- Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source

CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Required User Authority

For PowerExchange to read change data from Db2 logs, the user ID that you specify for database access must have SYSADM or DBADM authority. Usually, you specify this user ID in the UDB CAPI_CONNECTION statement in the dbmover.cfg file.

If the user has SYSADM authority, ensure that the user also has SELECT, INSERT, UPDATE, and DELETE permissions to the PowerExchange capture catalog in the source database. You can use the GRANT DATAACCESS statement to grant these permissions on the database to the user.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Required User Authority

Required User Authority