datastage installation, project directory

mystuff · Post by **mystuff** » Wed Jul 11, 2007 12:02 pm

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?

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 1:00 pm

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.

mystuff · Post by **mystuff** » Wed Jul 11, 2007 1:49 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 2:02 pm

Begin work.

VERIFY.SQL used properly should re-synchronize all the system tables in the DataStage/SQL Catalog.

Nisusmage · Post by **Nisusmage** » Wed Nov 14, 2007 10:55 am

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 ?