Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe 10.5.3
  • All Products

Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Client for PowerCenter
  5. PowerExchange Condense
  6. PowerExchange Listener
  7. PowerExchange Logger for Linux, UNIX, and Windows
  8. PowerExchange Navigator
  9. PowerExchange Monitoring and Tuning
  10. PowerExchange Utilities
  11. PowerExchange for Adabas
  12. PowerExchange for DB2 for i
  13. PowerExchange for DB2 for Linux, UNIX, and Windows
  14. PowerExchange for DB2 for z/OS
  15. PowerExchange for IMS
  16. PowerExchange for Microsoft SQL Server
  17. PowerExchange for MySQL
  18. PowerExchange for Oracle
  19. PowerExchange for PostgreSQL
  20. PowerExchange for SAP HANA
  21. PowerExchange for VSAM and Flat Files

Release Guide

Release Guide

Back Next

PowerExchange Express CDC for Oracle Configuration File

PowerExchange Express CDC for Oracle Configuration File

PowerExchange 10.5.2 includes the following new or changed parameters in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
ASMSTAGING statement
Changed
. This statement contains the following new parameter:
ASYNC=
n
New
.Optional. Queue and send multiple non-blocking staging requests to ASM sequentially. Specify a value greater than 0 to optimize performance when the log reader thread spends long periods deprived of resources because of slow network writes to the PowerExchange Logger, or when delays occur when large UOWs are being processed.
DIRSUB statement
Changed
. Use this statement to improve efficiency when ARCHIVECOPY mode is enabled in the READER statement. In ARCHIVECOPY mode, you can specify DIRSUB to substitute ASM directories. Do not use the DIRSUB statement if the reason the archive logs are being copied is because of an aggressive archive deletion policy on the database.
OPTIONS statement
Changed
. The statement contains the following new or changed parameters:
CAPIEVENTS=
queue_size
New
. Controls the queue size between PowerExchange Express CDC and a consumer, such as the PowerExchange Logger or network. Increasing the queue size can help performance for intermittent data loads by allowing more data to be queued before PowerExchange Express CDC stalls waiting for resources.
MEMOPS_MEMORY=
megabytes
New
. Specifies a memory limit, in megabytes. When the maximum memory used during a monitor interval begins to decrease, the resources will begin to be released. The draw down stops when either the number of resource events reaches the value specified by MEMOPS, or its default value, or more memory resources are needed.
PERFORMANCESTATS={
Y
|N}
New
. Controls whether statistics messages are included in monitor messages.
SPILLFILEBUFFSZ=
kilobytes
Changed
. Default is now 64 KB. Previously, the default was 0.
SPILLMAX=
kilobytes
Changed
. Default is now 1048576 KB. Previously, the default was 10240.
SUPPORT_DIRECT_PATH_OPS={
Y
|N}
Changed
. Default is now Y. Previously, the default was N.
SUPPORT_COL_ENCRYPTION={Y|
N
}
New
. Controls whether PowerExchange supports column-level encryption. When enabled, PowerExchange can decrypt encrypted data in Oracle source columns during CDC processing.
Options are:
  • Y
    . Support column-level encryption of source columns. PowerExchange can decrypt data from encrypted source columns and continue CDC processing.
    The PowerExchange capture user must have the following Oracle privilege: 
    GRANT SELECT ON "SYS"."ENC$" TO 
    capture_user
    If the MODE parameter in the DICTIONARY statement is set to DYNAMIC, you must take a new snapshot of the dictionary after enabling column-level encryption.
    When capturing data from a PDB that is configured in isolated mode and that contains encrypted tablespaces and source tables with encrypted columns selected for change capture, you must specify both the CDB and PDB wallet information in the TDEKEYSTORE parameter of the DATABASE statement.
    If Express CDC is running in either dynamic or static dictionary mode, PowerExchange detects Oracle row updates made as a result of re-entering the encryption algorithm or integrity mode and then excludes them from capture processing. If Express CDC is not running and is configured for static dictionary mode, decryption failures can occur, causing CDC processing to terminate. To avoid this problem, remove the source tables from the list of source tables of CDC interest.
  • N
    . Do not support column-level encryption of source columns. If PowerExchange encounters encrypted column data in source tables, it cannot decrypt the data. In this case, CDC processing ends abnormally with error message PWX-36335.
Default is N.
READER statement
Changed
. This statement contains the following changed parameters:
MODE > ARCHIVECOPY
Changed
. If you run the PowerExchange Logger in continuous mode, it now attempts to detect and recover from situations where it begins to read logs before they are fully copied. Previously, the PowerExchange Logger might fail if it read the archive copy before the copy was fully written. Directory scanning is now more efficient because it retains information about the files that it has scanned and validated and does not attempt to re-validate them unless they change.
READBUFFSIZE=
kilobytes
Changed
. The maximum value you can specify is now 1048576 KB. Previously, the maximum value was 262144 KB.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.
0 COMMENTS
We’d like to hear from you!