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 VSAM and Flat Files
  24. PowerExchange ODBC

DBMOVER Configuration File Statements

DBMOVER Configuration File Statements

The DBMOVER configuration file includes the following new and changed statements:
CAPI_CONNECTION=(NAME=
capi_connection_name
,TYPE=(MSQL,...[LOCKAVOIDANCE=
{N|Y}]))
New
. The LOCKAVOIDANCE parameter in the MSQL CAPI_CONNECTION statement controls whether PowerExchange SELECT statements use the NOLOCK hint when querying the SQL Server distribution database for change data. The NOLOCK hint can avoid lock contention with SQL Server utilities but might cause PowerExchange to miss some change records. Options are:
  • N
    . PowerExchange SELECT queries that retrieve data from the distribution database do not use the NOLOCK hint. If locks are held on some change records, PowerExchange queries cannot retrieve the data until the locks are released. With this setting, PowerExchange queries might take longer to complete. However, no changes are skipped and data integrity is preserved. Use this option only when the MULTIPUB parameter is set to Y.
  • Y
    . PowerExchange SQL SELECT queries that retrieve data from the distribution database use the NOLOCK hint. Use this option only when the MULTIPUB parameter is set to N. If the MULTIPUB parameter is set to Y, SQL Server might use allocation order scans to retrieve data for PowerExchange queries, which can result in missed change data and data corruption.
    Instead of using LOCKAVOIDANCE=Y, Informatica recommends that you set the isolation level for the distribution database to READ_COMMITTED_SNAPSHOT ON to avoid data integrity problems.
Default is
N
if MULTIPUB is set to Y, or
Y
if MULTIPUB is set to N.
CONSOLE_MSG={N|
Y
}
New
. On Linux, UNIX, and Windows systems, the CONSOLE_MSG statement specifies whether to write certain messages to the domain log in addition to writing them to the PowerExchange log file on the Integration Service machine.
  • N.
    PowerExchange does not write the messages to the domain log.
  • Y
    .
    PowerExchange writes the messages to the domain log.
Default is Y.
LOWVALUES={
N
|Y}
Changed
. The LOWVALUES statement now applies to PowerExchange NRDB, DB2, and CDC sources and targets. In previous releases, the statement applies only to VSAM files on z/OS and to sequential files on Linux, UNIX, Windows, or z/OS.
The LOWVALUES statement specifies whether PowerExchange preserves hexadecimal '0' values, called
low values
, in source character fields when passing these values to a PowerCenter session. When the session runs, the PowerExchange Client for PowerCenter (PWXPC) can write these values to the target.
For more information, see the "DBMOVER Configuration File" chapter in the
PowerExchange Reference Manual
.

0 COMMENTS

We’d like to hear from you!