Page 1 of 1
datastage installation, project directory
Posted: Wed Jul 11, 2007 12:02 pm
by mystuff
If datastage is installed in DirectoryA and projects are stored in DirectoryB.
And for some reason if we had to re-install in datastage on DirectoryA, then
Can we re-create projects with same name and point them to DirectoryB. Then start using Or the only way would be to import .dsx file?
Posted: Wed Jul 11, 2007 1:00 pm
by ray.wurlod
Have you tried? Any answer we could give would be at best a guess. Theoretically what you want to do is feasible, but not via the mechanism you are suggesting. You would need to reinstall the server then use VERIFY.SQL to update the system tables with the location of each project.
Posted: Wed Jul 11, 2007 1:49 pm
by mystuff
Have you tried? Any answer we could give would be at best a guess.
No I haven't tried. Wanted to go ahead with the suggestions I obtain over here.
You would need to reinstall the server then use VERIFY.SQL to update the system tables with the location of each project.
Did you mean reinstallation of DataStage on the server, Yes we did that.
What would be the next steps after I login to TCL Prompt and use VERIFY.SQL
Posted: Wed Jul 11, 2007 2:02 pm
by ray.wurlod
Begin work.
VERIFY.SQL used properly should re-synchronize all the system tables in the DataStage/SQL Catalog.
Posted: Wed Nov 14, 2007 10:55 am
by Nisusmage
Hello,
I'm having the same as your orginal problem. Ony difference is that we re-installed DB2 as well.. so it's a clean fresh install.
I've tried many different approaches to recreate the project with the OS project files I have. But nothing seems to work.
What am I doing wrong here ?