Hi,
This is the first time I am working on a DR project. We are doing the sync up ourselves as there is no SA help. The disk space is 8 GB currently and the sync up is only for unix part. I am doing SCP from our production box and it takes 6 hours to complete it. I cannot move files based on delta as our design restricts us from doing that, it will mess up the functionality of the code. I have few questions where I need some help
1. Should I copy DSEngine directory to DR server, reason for asking this is, we use SDK sequence files and I assume they are in DSEngine at run time.
2. Whats the fastest way to copy the whole 8 GB of disk to DR server ?
Appreciate your comments and suggestions on this issue. Thanks
Disaster Recovery
Moderators: chulett, rschirm, roy
Unless your server name is the same name as the one you are replacing then you may have issues. The server name is buried down in these files. You need to reinstall DataStage. You should design your DR recovery around full export and imports. SDK sequences should have a job which can rebuild them. It is always poor practice to use hashed files as permanent storage. SDK sequences are stored in hashed files. We had a simple job which would run before each load to always rebuild these from the target.
Select max(#TargetColumn#) From #TargetSchema#.#TargetTable#
Is how you can parameterize this job. Look in the routine code to get the hashed file name for SDK sequences. I think this job can be downloaded from my web site tips and tricks page. If not then I can add it. Simple job. You should be able to build it yourself.
Select max(#TargetColumn#) From #TargetSchema#.#TargetTable#
Is how you can parameterize this job. Look in the routine code to get the hashed file name for SDK sequences. I think this job can be downloaded from my web site tips and tricks page. If not then I can add it. Simple job. You should be able to build it yourself.
Mamu Kim
-
devilsmentor
- Participant
- Posts: 30
- Joined: Wed Apr 12, 2006 11:23 am