The PowerCenter Integration Service creates the recovery tables if they do not exist. The PowerCenter Integration Service uses the database user name specified in the connection to create the tables. The database user name PowerExchange uses to create the recovery tables varies based on the PWXPC connection.
The PowerCenter Integration Service does not create recovery queues. You must create the recovery queue manually.