PowerExchange Interfaces for PowerCenter

10.5.2
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 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_inf.sql	Informix
create_schema_neoview.sql	Neoview
create_schema_netz.sql	Netezza
create_schema_ora.sql	Oracle
create_schema_sql.sql	SQL Server
create_schema_syb.sql	Sybase
create_schema_ter.sql	Teradata
create_schema_tpt.sql	Teradata PT