User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Manually Tuning the Informatica Managed File Transfer Database

Tuning the database compresses the indexes, which keeps queries running at maximum speed. To tune the

Managed File Transfer

database manually:

From the main menu, select

System

, and then click the Database Configuration link.

In the toolbar, click

Tuning

and then click the

Tune Database Now

button.

In the confirmation box, click the

Continue

button.

When the system completes the tuning process, a message displays how long the tuning process took.

Tuning the database will acquire a lock on all database tables. This means that connections to the database may fail while tuning is taking place. You should only tune the database when the system is not in use. The time it takes to tune the database is solely based on the number of records stored in the database and may take several minutes to complete.

Rename Saved Search

Table of Contents

User Guide

User Guide

Manually Tuning the Informatica Managed File Transfer Database

Manually Tuning the Informatica Managed File Transfer Database