DSXchange

I have an existing project. There was some problem on the server due to which the project was corrupted. I get the error "CANNOT OPEN FILE DS_JOBOBJECTS". I can create and save a new job, but cannot open it for re-editing and cannot delete any jobs. I have tried re-indexing the entire proj...

I get the following error when trying to view data in my Oracle 9i OCI stage:

ds_loadlibrary: error in dlopen - Dynamic Error

What could be the problem?

You have to use the dsjob command. The path for the command is $DSHOME/bin. dsjob -run -mode NORMAL runs the job and dsjob -run -mode RESET resets an aborted job.
See the options which dsjob gives for more options.

There was an error in hash file mapping - the input and output field columns order was different, hence the problem. BTW, is a hash file not like a dataset wherein even if you interchange the column names it picks up the correct data? If a hash file is stored as a table internally, then column name ...

There are actually 2 queries: 1. We have a set of server jobs which we need to have UTF8 enabled for Japanese / Korean characters. These jobs do a lot of lookups using Xformers. Now, the same lookup does not work for Japanese characters even though the job default character set is UTF8 and lookup fi...

Well, I find ppl working with me doing it, so I asked. Thanks for the info.

This might sound silly, but I got the idea whether we can use the UniVerse of DataStage to replace hash files with UV tables that are stored in the UniVerse repository of DataStage. If yes, would there be any advantage of doing so?

Well, I tried it on purpose. I always used to see the following statement after running uv command: "User <proj-name> logged on"
So I got curious and the rest followed.
Thanks guys.

Hi, I am again tinkering around with DataStage (oops.. IBM Websphere DataStage) commands on Unix and also am reading the Universe reference manuals. Figured I might be able to use some BASIC commands for fun. Anyways, when I type the uv command from a directory not in $DSHOME/../Projects/<proj-name>...

Another query actually... why do we have to restart the DataStage server after re-indexing or cleaning up projects? Will there be any serious impact if we do not restart the server?

Hi,
I was browsing through the $DSHOME/bin directory and found a few DataStage executables. I am wary to try them out before knowing actually what they do. Can someone please explain the significance of the following commands:
dspipe, dsapi_server, dsapi_slave, dsdlockd, dslictool, dsrpcd, dstskup

All that is OK and the job is working fine. Just that the client does not want to see any warnings in the job log. This entry consistently appears in all logs. I want to know the reason behind this warning.

I have a set of jobs which access a TeraData database using ODBC stages. For all the jobs, the following warning comes up: DataStage Job 148 Phantom 5364 Program "DSD.GetDBMSDetails": Line 279, Retrieve: syntax error. Unexpected . Token was "". Scanned command was Program "D...

How can I get the ID of a job using dsjob or Administrator? I'm using the foll query in administrator SELECT * FROM DS_JOBS WHERE ??=MyJob Firstly, what will ?? be? And is the syntax correct, do I need to enclose the Job Name in double-quotes. Also, what is the difference between SELECT * FROM DS_JO...

Sorry got it. One of those instances when I did not read the documentation properly