hi,
we had to reinstall Datastage on a server, and i'd like to know if i could attch the "old" projects to the new instance (this is the same version as the old instance)
tks
how to attach a project with a new installation
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I would guess that you installed DataStage in a different location than the old installation.
Therefore to "reattach" the old projects a number of steps must be taken.
1. In the new engine insert entries into the UV.ACCOUNT table that match the entries in UV.ACCOUNT in the old installation.
2. Use VERIFY.SQL to update the system table UV_SCHEMA for each of the old projects.
3. In each of the old projects execute the command UPDATE.ACCOUNT to force pointers to "system" entries to point to the new engine.
You will, of course, need administrator access to perform these tasks. For VERIFY.SQL you will need to be logged in as the DataStage/SQL DBA.
Therefore to "reattach" the old projects a number of steps must be taken.
1. In the new engine insert entries into the UV.ACCOUNT table that match the entries in UV.ACCOUNT in the old installation.
2. Use VERIFY.SQL to update the system table UV_SCHEMA for each of the old projects.
3. In each of the old projects execute the command UPDATE.ACCOUNT to force pointers to "system" entries to point to the new engine.
You will, of course, need administrator access to perform these tasks. For VERIFY.SQL you will need to be logged in as the DataStage/SQL DBA.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.