Page 1 of 1
how to attach a project with a new installation
Posted: Fri Apr 20, 2007 7:01 am
by gbusson
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
Posted: Fri Apr 20, 2007 3:14 pm
by kduke
It should of found the old project and upgraded it. Does it show up? If not then you might try to create a project in the same location.
Posted: Fri Apr 20, 2007 3:58 pm
by ray.wurlod
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.