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

Access Requirements for PowerExchange Jobs

Access Requirements for PowerExchange Jobs

To perform bulk data movement and CDC operations, PowerExchange jobs and tasks require certain authority.
The following table lists the access authority that the PowerExchange Listener requires for bulk data processing:
Library and File Name
Authority Required
datalib
/CFG
*USE
datalib
/LOG
*CHANGE
datalib
/P
nnnnn
If you use PowerExchange alternative logging, the PowerExchange Listener creates a file named P
nnnnn
in the data library, where
nnnnn
is the port number of the PowerExchange Listener.
*CHANGE
dtllib
/DTLMSG
*USE
dtllib
/LICENSE
*USE
stdatamaps
*CHANGE
The following table lists the access authority that the PowerExchange Listener and PowerExchange Condense require for bulk data and CDC processing:
File Name
PowerExchange Listener Authority
PowerExchange Condense Authority
cndlib
/CFGCOND
*USE
*USE
cndlib
/PWXJRNLCKP
*CHANGE
*CHANGE
cpxlib
*CHANGE
n/a
datalib
/CCT
*CHANGE
*USE
datalib
/CDCT
*USE
*CHANGE
datalib
/CDEP
*CHANGE
*CHANGE
datalib
/CFG
*USE
*USE
datalib
/LOG
*CHANGE
*CHANGE
datalib
/P
nnnnn
If you use PowerExchange alternative logging, the PowerExchange Listener creates a file named P
nnnnn
in the data library, where
nnnnn
is the port number of the PowerExchange Listener.
*CHANGE
n/a
datalib
/JOB
nnnnn
If you use PowerExchange alternative logging, the PowerExchange Condense job creates a file named JOB
nnnnn
in the data library, where
nnnnn
is the job number of the PowerExchange Condense job.
n/a
*CHANGE
dtllib
/DTLMSG
*USE
*USE
dtllib
/LICENSE
*USE
*USE
stdatamaps
*CHANGE
n/a
PowerExchange dynamically creates other objects, such as capture registrations and data maps. For users other than the user ID under which the PowerExchange Listener and PowerExchange Condense run, the default authority to access these objects depends on the following authority settings:
  • The Create Authority system value, QCRTAUT, which determines the system-wide public authority for new objects
  • The default public authority for the library that contains the objects