Identify and authorize operating users - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

The UDB Log Reader Capture operates under the sqdaemon process. The minimum permissions required on the source capture systems is DBADMN because Connect CDC (SQData) uses the Db2 logreader API. Request the assignment of the User-ID with those permissions. The user-id <sqdata_user> will be used throughout this document when referring to that user.

Create a Source UDB profile containing the UDB environment variables that give the capture information about the instance to connect to and the libraries to use. This should be setup in the logon script of the user that runs the capture.

$ source /home/<sqdata_user>/sqllib/udbprofile