Preface
Part 1: Introduction
- PowerExchange Interfaces for PowerCenter
Part 2: PowerExchange Client for PowerCenter (PWXPC)
Part 3: PowerExchange ODBC
Appendix A: PowerExchange Interfaces for PowerCenter Tips
Appendix B: Datatypes and Code Pages
Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting
- Troubleshooting for PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

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

Back Next

Creating the Recovery Tables Manually

Consider manually creating the recovery tables so you can control attributes such as the database, table space, and buffer pools. Informatica provides SQL scripts in the following directory:

<PowerCenter installation_directory>\server\bin\RecoverySQL

The following table lists the scripts that you can run to create the recovery tables in the target database:

Script	Database
create_schema_db2.sql	DB2
create_schema_ora.sql	Oracle
create_schema_sql.sql	SQL Server

The scripts are generic DDL. Make the appropriate changes for your environment.

Creating Recovery Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Creating the Recovery Tables Manually

Creating the Recovery Tables Manually