Hi,
I intend to device a backup plan for our DS v8 installation. But I have noticed that DS has some information in the xmeta database (DB2 in our case) although I am not sure how it all connects.
If somebody can explain me how it all connects (DS, DB2, WAS etc.) and what components should be backed up (apart from the usual project exports), it will be of great help.
Cheers
Aakash
Backup of DataStage ver 8
Moderators: chulett, rschirm, roy
-
aakashahuja
- Premium Member
- Posts: 210
- Joined: Wed Feb 16, 2005 7:17 am
Backup of DataStage ver 8
L'arrêt essayant d'être parfait… évoluons.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Backup of DataStage ver 8
Hey Aakash
Aside from Ray's first suggestion of a dsx if you want to back up the various layers at the file level please contact IBM support - As you correctly noted there is information stored in each of the tiers (repository, ISF, Engine even the clients if your users have customized their palette's) there are also a couple of key additional things you'll need other than just the data in the repository e.g. WAS uses an encryption key etc..
This is all covered in a document called MigratingIBMInformationServer that support can provide you access to.
Cheers
Steve
p.s. please go through support so we can track who's asking for this information but any issues please cc me.
Aside from Ray's first suggestion of a dsx if you want to back up the various layers at the file level please contact IBM support - As you correctly noted there is information stored in each of the tiers (repository, ISF, Engine even the clients if your users have customized their palette's) there are also a couple of key additional things you'll need other than just the data in the repository e.g. WAS uses an encryption key etc..
This is all covered in a document called MigratingIBMInformationServer that support can provide you access to.
Cheers
Steve
p.s. please go through support so we can track who's asking for this information but any issues please cc me.
aakashahuja wrote:Hi,
I intend to device a backup plan for our DS v8 installation. But I have noticed that DS has some information in the xmeta database (DB2 in our case) although I am not sure how it all connects.
If somebody can explain me how it all connects (DS, DB2, WAS etc.) and what components should be backed up (apart from the usual project exports), it will be of great help.
Cheers
Aakash
Steven Totman
Team Lead Metadata
Product Management
Information Server
IBM
Team Lead Metadata
Product Management
Information Server
IBM
</a>-
aakashahuja
- Premium Member
- Posts: 210
- Joined: Wed Feb 16, 2005 7:17 am
I agree Arnd.... but I was just thinking it doing this way:
Backup metadata repository soon after the install (so that all the install config info is secured).
Then on regular frequencies, export projects and do filesystem backups of DS.
Backup WAS profile each time it changes.
If things go horribly wrong one fine day, then I would just:
First restore the initial backup of metadata rep so that we have a working initial-image.
Then do project imports.
Do you think this will work?
Backup metadata repository soon after the install (so that all the install config info is secured).
Then on regular frequencies, export projects and do filesystem backups of DS.
Backup WAS profile each time it changes.
If things go horribly wrong one fine day, then I would just:
First restore the initial backup of metadata rep so that we have a working initial-image.
Then do project imports.
Do you think this will work?
L'arrêt essayant d'être parfait… évoluons.