DSXchange

Since the job status is (Finished with warnings), it is considered as finished unless the warning is promoted to fatal Error. How do we promote the warnings as fatal. Even a single error I want to have the job to abort. Right now I have a) Execution Action :Reset if required, then run b) Triggers :...

Are you getting a list of server B's projects when you authenticate to server A? (If so, I would suggest that you check very carefully that you are indeed connecting to server A.) Yes this is what is happening. I have double checked the server name. ServerA , but i get the list from ServerB. And as...

When I try to login to Datastage Designer on one server (say ServerA). I am able to see/login to projects on ServerB and not ServerA

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...

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?

I personally would go for 'a'

They have agreed to create a table for ETL

Thats the third method, which I mentioned. Option (b) is out as well as it would result in pulling huge data.

Are there any other method anyone can think of. As of right now looks like I am stuck with just option (c)

Hi, If I need to have a query between two different source systems (Oracle & say informix). Like select SourceSystemA.TableA.* from SourceSystemA.TableA inner join SourceSystemB.TableB on SourceSystemA.TableA.FieldA = SourceSystemB.TableB.FieldB Note : We are not selecting any fields from Source...

Can you look at the index of an earlier backup

What do you mean by index of earlier backup?

I found these in the DSEngine directory
It also has bin directory with contents (dsapi_server, dsapi_slave, dsrpcd, uvsh)

what do you mean that when the DS working

The files went missing on 21st. And we were able to compile/run the jobs as usual. We took back up from 17th. The backup didnt work. I am guessing the restore of backup was not complete.

They do take backups. Strangely when the system admin restored the backup (from the date when DS was working). Even they didn't have the files. I am following sys admin as to why that could happen. ray.wurlod disk utility gone slightly haywire Can you explain me this, as I am concerned as to why the...

didn't result in any files

I made aDSEngine directory and got the following results

uvconfig.101005.152944.bak
uvconfig.20060308
uvodbc.config

a) How can I recover from backup file
b) Will it solve the problem of other pertaining files (such as uvconfig and bin/uvregen) as well?

I made aDSEngine directory and got the following results

uvconfig.101005.152944.bak
uvconfig.20060308
uvodbc.config

a) How can I recover from backup file
b) Will it solve the problem of other pertaining files as well?

I checked for uvconfig and bin/uvregen .

They don't exists in the directory. So what shall I do next?