Restore files with out triggers/constraints on them

[DeadManWalks]

Hello, i have a 2 step process. One restores files from tape to a copylib. Then copy the files to a destination lib. The destination lib can be different depending on what environment is being restored.

The bottle next is the restore from tape to copylib. The copylib does not have any of the tables in there. So when files are copied with journals, triggers , constraints they get created in the lib on the file since they are part of it.

The final destination has all the files but has all triggers turned off.

is there a way to restore the files with out journal and such?

I have looked at the commands but don't see an option. Anyone come across this?

I guess i could clear all the files in the copylib that way the things don't get created.

[Scott Klement]

Why would someone want to do this? If the file is backed up with triggers, journals, etc, why would you want to restore it without them?

Are you using this as some sort of data transfer function? If so, why are you using a save/restore method?

[EmmanuelW1]

You may find this of interest, at least for the journaling issue: http://archive.midrange.com/midrange.../msg00100.html.

For triggers, we use RMVPFTRG after the restore when refreshing our test environment.

Cheers,

Emmanuel

[DeadManWalks]

Good stuff EmmanuelW1.

[DeadManWalks]

just to finish this out, the destination lib already has the journals and triggers on them. So i dont care if the ones from production have them or not. Just wanted to make the initial restore faster.