Prorest With Different Extent Paths

[texasprd]

Hello;

We don't have a Progress DBA here, so I need a bit of help with the following:

I'm writing a purge routine for our data warehouse, and we need to copy the db to another host (Progress 9.1E, AIX 5.2) for testing. The production db occupies multiple file systems due to space constraints, and consists of multiple storage areas & many extents. There is plenty of room on the prospective test system to put the entire db in one filesystem/path. Our AIX admin does a "probkup" every week, then copies the backup extents to tape, so we will copy the backup from tape to the test box, then do a "prorest".

According to the Progress knowledgebase, it looks like I can restore the db into a different path/filesystem by doing one of the following:

1) Initiate the "prorest" in the desired path and use no .st file (looks like the easiest)
2) Modify the original .st file to reflect the new, desired paths and do a "prorest"
3) Modify the .st file, create void database using "prostrct create" and new .st file, then "prorest" into the new db

Can anyone confirm which options above will work, or suggest the correct way if none of the above are valid?

Thanks for all help!

Andrew Belew
International Bank of Commerce

 

[vinod_home]

Use method 2.

You basically know how your db needs to be created on your test box, so its easy for you to create/update the st file there and then just do a prorest. That would create the extents and restore for you.

hope that helps,

 

[methyl]

Not tried this with Progress 9. With Progress 8.3 the only option is method 3. Tried method 2 once and it ignored the structure file and created a single volume database!