DSXchange

Hi,

I am running 100+ instances of a Multi-Instance Sequence job. When I need to reset the aborted jobs , one way to reset them manually one by one via Director. But its a very slow process.

Is there any command line option available to reset the jobs via command line?

Thanks,
Sjordery.

Thanks Chullet, Below one worked. ------------------------------------------------ dshome=`cat /.dshome`;export dshome PATH=$PATH:$dshome/lib; export PATH . $dshome/dsenv PROJECT=P_Dev JOB=test_job RunInfo=`/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -run -jobstatus $PROJECT $JOB 2>&1` ...

Hi Vamsi,

Sorry, it didn't work. I am getting the same error.

I tried with this:

cd $DSHome/bin

PROJECT=P_Dev
JOB=test_job

RunInfo=`dsjob -run -jobstatus $PROJECT $JOB 2>&1`
echo $RunInfo


Thanks,
Sjordery.

Hi All, I have a Unix script which calls a data stage job. While executing the script from Datastage 7.5 server it runs fine. But the same script while executing from V8 server it's giving error " bash: dsjob: command not found " . Any help would be appreciated. Below is the script -------...

I've had this with multiple lookups with multiple ODBC connectors. The downstream DB connections seem to time out waiting for data to flow from the earlier lookups. The only way I found to get around it is either: A) If you are using lookups - examine your strategy, ie. whether you are using normal ...

Thanks again.

I double-checked and there is no RCP in the previous job (the one that creates the dataset. :(

Thanks for your reply. I have just tried rebuilding the job from scratch and all was looking good until I set the lookup type to sparse, at which point it goes to RCP checked on. Setting it to normal puts it back to RCP unchecked! So.. is it not possible to have sparse lookup and RCP 'off'? Thanks a...

Hello All, I have a job that is designed like this: ODBC_connector || || || \/ dataset ==> Lookup_232 ====> transformer ===> dataset I am getting numerous warning messages along the lines of: Lookup_232: Schema field FieldA in input data set 0 not present in design time information. Extended field p...

Thanks Ray. Actually the job has a copy stage in between source sequential file stage and target ODBC stage. When I check the director it shows : Sequential_File_0,0: Progress: 10 percent. Sequential_File_0,0: Progress: 20 percent. ....... ....... Sequential_File_0,0: Progress: 100 percent To comple...

Hi All, I have a job which reads data from a sequential file and loads to sql server data base. The job used to run faster with < 1lakh records. After the the source file size has increased ( around 3+ lakhs of records)the job is running very slow. When I checked director for this job I learned that...

Thanks Ray. This is working if one string is there before the numbers from back word. for e.g if the string is 5656D09 then MatchField("5656D09", "0N1A0N", 2)is returning the correct vale D. But ,if the string is 5656ID09 then MatchField("5656ID09", "0N1A0N", ...

I have a requirement like this: The input file has one column called code whose value is 7878D0990. In that I need to search from backward and get the alphabet found i.e D. The value changes in every run. I am thinking to use stage variables but not sure how to perform looping using stage variables....

For anyone else that gets this message and finds this thread via a search, the cause of this error message for me was running a job that was writing to datasetA whilst concurrently trying to read datasetA in another job!

Hi All, I have a conceptual doubt. When data flows from one stage (process) to another stage where it stores the intermediate data i.e after the 1st stage finishes reading and before 2nd stage starts reading. Does it use any temporary data sets? Also when buffering comes in to picture. Thanks in Adv...

[quote="ArndW"]I would guess that the DataStage user has only "R" and not "RW" rights to "tmp//meas.ds" because of the error message [quote] "Unable to open descriptor file to update: Permission denied "[/quote][/quote] Oops - my bad, sorry. The Grou...