In this section:
PMF 5.1.2 and higher includes a snapshot and restore feature. Taking a snapshot serializes the entire content of the PMF data mart to a set of files in a folder located on your server’s file system. These files can then be restored to another data mart on any platform or RDBMS that PMF supports.
Snapshot and restore can be used to:
PMF includes an administration console that allows you to perform the following system administration tasks from outside the PMF application:
To start the PMF Administration Console, you must log onto the WebFOCUS MR environment using your administration password. Once you are in MR, select the PMF Administration Console from the PMF domain and click Run. You can now perform these system administration tasks.
Before taking a snapshot, make sure that the PMF adapter, named pmf_system, is pointing to the data mart that is being used for the snapshot. You can find this adapter under adapters and then SQL Server, adapters and then Oracle, or adapters and then DB2 on your WebFOCUS Server Console.
Before beginning, make sure your source server is running the same version of PMF and pointing to the data mart you want to take a snapshot of from the SQL Server. PMF must use that data mart in order for snapshot and restore to work correctly. Also, the snapshot has to be taken from the same version of PMF that you intend to restore.
A status message opens informing you that the process is complete. The files are located in a folder containing both flat files and master files, and is named [your snapshot name]_[pmf_version].
The Restore a Data Mart Snapshot panel opens, as shown in the following image.
Select if you want to restore a snapshot from a template, or from a private snapshot.
From the drop-down list, choose the snapshot you transferred to the customer server. Click Restore snapshot.
A status message will open informing you that the process is complete.
The restore function will populate the PMF data mart with the sample data from the snapshot you took. Note that the database will not be renamed, but its contents will be those from the data mart that you took the snapshot from.
Take the following into consideration before moving a PMF snapshot to another server: