PowerExchange Interfaces for PowerCenter

10.4.0
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

Recovery Tables

For relational targets, the PowerCenter Integration Service creates the following recovery tables in the target database:

PM_RECOVERY.
This table contains target load information for the session run. The PowerCenter Integration Service removes the information from this table after each successful session and initializes the information at the beginning of subsequent sessions.

PM_TGT_RUN_ID.
This table contains information the Integration Service uses to identify each target on the database. The information remains in the table between session runs. If you manually create this table, you must create a row and enter a value other than zero for LAST_TGT_RUN_ID to ensure that the session recovers successfully.

PM_REC_STATE.
This table contains restart information for CDC sessions. The restart information recorded in the table contains the application name and restart tokens for the session. The restart information remains in the table permanently. The PowerCenter Integration Service updates it with each commit to the target tables.

If you edit or drop the recovery tables before you recover a session, the PowerCenter Integration Service cannot recover the session. If you disable recovery, the PowerCenter Integration Service does not remove the recovery tables from the target database. You must manually remove the recovery tables.

If you want the PowerCenter Integration Service to create the recovery tables, grant table creation privilege to the database user name for the target database connection.

If you do not want the PowerCenter Integration Service to create the recovery tables, create the recovery tables manually.