404 Resource at '/content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-5-2/_release-guide_powerexchange-for-cdc-and-mainframe_10-5-2_ditamap/powerexchange_for_postgresql/powerexchange_1052_-_new_features_and_changes_for_postgresql/parameter_and_option_changes_in_1052_9/dbmover_configuration_file_1/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Resource at '/content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-5-2/_release-guide_powerexchange-for-cdc-and-mainframe_10-5-2_ditamap/powerexchange_for_postgresql/powerexchange_1052_-_new_features_and_changes_for_postgresql/parameter_and_option_changes_in_1052_9/dbmover_configuration_file_1/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Cannot serve request to /content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-5-2/_release-guide_powerexchange-for-cdc-and-mainframe_10-5-2_ditamap/powerexchange_for_postgresql/powerexchange_1052_-_new_features_and_changes_for_postgresql/parameter_and_option_changes_in_1052_9/dbmover_configuration_file_1/_jcr_content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover on this server

Apache Sling
English
  • PowerExchange for CDC and Mainframe 10.5.2
  • All Products

Table of Contents

Search

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

Release Guide

Release Guide

Back Next

DBMOVER Configuration File

DBMOVER Configuration File

The DBMOVER configuration file contains the following changed statement:
PG CAPI_CONNECTION
Changed
. PowerExchange 10.5.2 adds the CAPTUREALL parameter to the PG CAPI_CONNECTION statement. Syntax is: 
CAPI_CONNECTION=(NAME=
capi_connection_name

                  ,TYPE=(PG
                  ,SERVER={
database_server
|
localhost
}[,
port
]
                 [
,CAPTUREALL={Y|
N
}]

                  ,DATABASE=
database_name

             )
CAPTUREALL={
N
|Y}
New
. This optional parameter controls whether PowerExchange captures and stores change data for all tables in the source database or only for the tables that are registered for CDC. Use this parameter to limit the amount of data that is stored in the replication store table to only the data from registered source tables.
Options are:
  • N
    . Store captured DML changes only for registered source tables in the replication store table. Use this option to limit the amount of data that is collected and stored in the store table.
  • Y
    . Store all DML changes captured from the source database, including changes for unregistered tables, in the replication store table. This setting is not recommended because it can cause more data than is needed for CDC processing to be stored in the replication store table.
Default is N.
For more information, see the "DBMOVER Configuration File" chapter in the
PowerExchange Reference Manual
.
0 COMMENTS
We’d like to hear from you!