This is in reference to C5223756 where you had asked for the documentation on how to stage the dump file on a test/clone machine.
 
Following is the link to the TPI  33081 https://www.ptc.com/appserver/cs/view/solution.jsp?n=33081 which explains  the same.
 
After importing the dump file you can also use the steps below to edit the fileserver host and the file vault information.
 
1. sqlplus /nolog (start sqlplus in the unix/dos prompt;)
1.a set linesize 1000 (in the SQL prompt)
 
2. connect sys/change_on_install as sysdba (type this in the svrmgrl prompt)
 
3. select * from pdm.pdm_pool;(type this in the sql prompt)
This should show you the fileserver host and vault location
eg:
SQL> select * from pdm.pdm_pool;
POOLID POOLNAME
POOLPATH
POOLSTATUS POOLHOST
CREATEDBY
CREATEDON MODIFIEDBY
MODIFIEDO DOMAINID
---------- ---------------------------------------------------------------------
----------- --------------------------------------------------------------------
------------ ---------- --------------------------------------------------------
------------------------ -------------------------------------------------------
------------------------- --------- --------------------------------------------
------------------------------------ --------- ----------
1 SYSPOOL
C:\ptc\Vault
1 dashrath
PDM
30-NOV-00 PDM
30-NOV-00
4. update pdm.pdm_pool set poolhost='<new_machine_name>', poolpath='<path_to_the_filevault>' where poolid=<no>;
'<new_machine_name>'= Name of the machine where the fileserver is installed
'<path_to_the_filevault>'= Path of the vault on the new machine where fileserver is installed
<no>=pool id no: got by running the step 3 
eg:update pdm.pdm_pool set poolhost='dashrath', poolpath='c:\moved_vault' where poolid=1;
This will update the hostname and poolpath to new location
Repeat this process by changing the poolpath and poolid.If you have more than one file vault. 
 
5.To view the fileserver host type in:
select * from pdm.pdm_fileserver;
eg:
SQL> select * from pdm.pdm_fileserver;
FSVID FSVHOST
FSVPORT
CREATEDON CREATEDBY
MODIFIEDO MODIFIEDBY
---------- ---------------------------------------------------------------------
----------- --------------------------------------------------------------------
------------ --------- ---------------------------------------------------------
----------------------- --------- ----------------------------------------------
----------------------------------
1 dashrath
7777
13-APR-99 PDM
SYSHOST
1 row selected.
To update the fileserver host, type in:
update pdm.pdm_fileserver set fsvhost = '<new_machine_name>' where fsvid=<no>;
Here <new_machine_name> is the new hostname of the machine
<no>=fsvid no: got by running the step 5 
Repeat this process by changing the fsvhost and fsvid.If you have more than fileserver.
 
6.commit;
gets saved in the oracle table
 
7.Exit
 
Let me know if you have any clarifications.
 
Thanks,
Raj
 Shivaraj Muniyappa 
Senior Technical Support Engineer
Data Management
PTC
Contact Technical Support
http://www.ptc.com/company/contacts/tech_support.htm

	
