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 Logger for z/OS
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for DB2 for i
  14. PowerExchange for DB2 for Linux, UNIX, and Windows
  15. PowerExchange for DB2 for z/OS
  16. PowerExchange for IMS
  17. PowerExchange for Microsoft SQL Server
  18. PowerExchange for MySQL
  19. PowerExchange ODBC
  20. PowerExchange for Oracle
  21. PowerExchange for PostgreSQL
  22. PowerExchange for SAP HANA
  23. PowerExchange for VSAM and Flat Files

PowerExchange Express CDC for Oracle Configuration File

PowerExchange Express CDC for Oracle Configuration File

PowerExchange 10.4.1 introduces a new statement in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
ASMSTAGING statement
New
. Enables PowerExchange Express CDC to use staging files in an ASM environment to hold chunks of redo log for CDC processing. You can optionally use staging files to improve CDC performance, increase data throughput, and reduce ASM CPU usage, without having to implement Oracle dual logging outside of ASM. When enabled, ASM generates one staging file for each active redo log thread.
Syntax:
ASMSTAGING STAGINGDIR="/
path
/
directory
" [LOCALDIR="/
localmountpoint
/
directory
"] [TARGETSIZE={
50
|
number
}] ;
Parameters descriptions:
STAGINGDIR
Required. The path to the directory that you created for staging files on the machine where the ASM instance to which PowerExchange connects resides. Enclose this value in double-quotation marks ("), for example:
"/oracle/staging"
To optimize ASM data throughput, ensure that the staging directory is on a fast storage device that is local to the ASM instance.
If PowerExchange Express CDC for Oracle is remotely accessing the staging directory, ensure the directory is in NFS storage or another type of shared storage.
LOCALDIR
Optional. The local NFS mount point for the staging directory. Specify this value only if it is different from the STAGINGDIR path. Enclose the value in double-quotation marks ("), for example:
"/localmountpoint/staging"
TARGETSIZE
Optional. The maximum size, in megabytes, of any chunk of redo log to be copied to the staging file. This value also determines the maximum file size.
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!