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

Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger

Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger

If you use the PowerExchange Logger for Linux, UNIX, and Windows to log change data from a local or remote data source, you can optionally specify a date and time value as the restart point for PowerCenter CDC sessions that extract the change data from the Logger log files. Time-based restart points are source-specific.
A problem with this feature was found shortly before the PowerExchange 10.2 HotFix 1 release. A time-based restart of a PowerCenter CDC session might fail. Contact Informatica Global Customer Support to request the emergency bug fix (EBF) for this issue, which should be available soon. Alternatively, as a workaround, remove all CAPI_CONNECTION statements from the DBMOVER configuration file on the Integration Service machine where the PowerCenter CDC session runs. Make sure that no other PowerCenter tasks require these statements.
To set a time-based restart point, define a pair of explicit override statements in the restart token file, each with the same extraction map name to identify the source object. In one statement, specify the RESTART_TIME option. In the other statement, specify a date and time value. Use the following syntax:
extractionMapName
=RESTART_TIME
extractionMapName
=
datetime
Parameters:
extractionMapName
The name of an extraction map for the data source. To determine the extraction map name, use one of the following methods:
  • For CDC data map sources, see the
    Schema Name Override
    and
    Map Name Override
    attributes in the session properties. These attributes override the schema name and map name in the source extraction map. Or, in Designer, see the
    Schema Name
    and
    Map Name
    values in the source Metadata Extensions.
  • For relational sources, see the
    Extraction Map Name
    attribute in the session properties.
After the extraction map has been used to extract change data, the table name is appended to this value in the format
extractionMapName
_
tableName
. Use the full name when defining an explicit override statement.
RESTART_TIME
This option allows you to use a date and time value as the restart point for extraction processing in the Logger log files.
datetime
The date and time to use as the restart point in PowerExchange Logger for Linux, UNIX, and Windows log files. This value must be in the format YYYYMMDDhhmmssuuuuuu, where YYYY is a four-digit year, MM is the month, DD is the day of the month, hh is hours, mm is minutes, ss is seconds, and uuuuuu is microseconds.
For more information, see the "Extracting Change Data" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
or the "Configuring the Restart Token File" chapter in the
PowerExchange Interfaces for PowerCenter
publication.

0 COMMENTS

We’d like to hear from you!