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.4
  • 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 ODBC
  19. PowerExchange for Oracle
  20. PowerExchange for PostgreSQL
  21. PowerExchange for SAP HANA
  22. 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.1includes the following new or changed parameters in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
DICTIONARY statement
Changed
. The DICTIONARY statement contains the following changed and new parameters for the dynamic dictionary:
MODE={
STATIC
|DYNAMIC}
Changed
. Specify the new DYNAMIC option to enable the dynamic dictionary feature. The dynamic dictionary can avoid data loss and corruption after a restart, which can otherwise occur when a static dictionary is used. For more information, see Dynamic Dictionary for Oracle Sources. The default value is STATIC.
RETENTIONPERIOD
New
. When MODE=DYNAMIC, optionally specify the period, in hours, to retain data in the dynamic data dictionary. Operations are rolled up into the data dictionary base snapshot at Express CDC initialization and once every 24 hours thereafter until this retention period elapses. Valid values are 1 through 744. The default value is 168 hours (or 1 week).
SNAPSHOTONCOLDSTART
New
. When MODE=DYNAMIC, optionally set this parameter to Y if you want to force a snapshot of the database to be taken of the current Oracle catalog when a PowerExchange Logger cold start is requested. The default value is N, which causes no snapshot to be taken.
If you use the default value of N and cold start the PowerExchange Logger when data exists in the dynamic dictionary and the cold start restart point SCN is greater than the dynamic dictionary SCN, the cold start uses the dictionary SCN as the restart point. This behavior ensures that the dictionary contains any changes that occur in the gap between the restart points.
UPDATEINTERVAL
New
. When MODE=DYNAMIC, optionally specify the interval, in minutes, that must elapse before PowerExchange Express CDC advances the SCN value in the data dictionary, during a period when no DDL changes of interest are occurring for a data source. When a restart occurs, PowerExchange Express CDC uses the data dictionary restart SCN when calculating how far back in the redo logs to start processing change records so that no DDL changes of interest are missed.
Valid values are 1 through 1440. The default value is 0, which causes the RSTRADV parameter value in the OPTIONS statement to be used.
OPTIONS statement
Changed
. The OPTIONS statement contains the following new and changed parameters:
MEMOPS
Changed
. Default is the greater of 5120 or the number of RAC members * 2 * 1024. For example, if you have three RAC members, the default is 6144. Previously, the default was 5120.
SPILLFILEBUFFSZ=
kilobytes
New
. The block buffer, in kilobytes, that is allocated for spill file I/O. Increase this value to reduce physical I/O and improve performance, if an increase in memory usage is acceptable.
Valid values are 0 through 1024. Default is 0, which causes the operating system to allocate the block buffer when the first write operation occurs. The size of the buffer then depends on the operating system.
STATESTORAGE statement
Changed
. Configures state table or file system storage for DDL change information from the in-memory dynamic dictionary for tables of CDC interest. Previously, this statement covered state storage only for checkpoint information.
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!