DSXchange

select count(tableb.name) from tablea,tableb where tablea.name=tableb.name

use XML input satge after folder stage,then use transformer stage if u need to do any reference lookups.

Folder stage ----->XML INPUT satge----->Transformer------>Oracle.

read XML Pack pdf file to configure forder stage and xml input stage...

this one solved when last weekend both database and datastage servers are downed for maintaince.

thanks for ur suggestions.

this one solved when last weekend both database and datastage servers are downed for maintaince.

thanks for ur suggestions.

one of my jobs(this job calls from shell script through crontab ) in the director the job status is showing as FINISHED but where as when i did ps -ef | grep dsclient the same job has process id, if i kill this id then "Missing StringID[2045] Killed "message is appering on the crontab log....

the job is able to write the data into seq file...

thanks for your responses friends.
finally we came to know there are multiple locks on the target table.once after killing those locks the job runs fine.

once again thanks for ur responses.

friends , when i start one of my jobs it's showing 600rows/sec and dropping that number rapidly to somewhere around 20rows/sec. when i check with my DBA there are 16 locks on that perticular table from uvsh@dsservermechine .if we release those locks and restarts the job the same is happening. this a...

thanks sainath , my DBA says database is clean. i got this kind of problem with two jobs .one jobs target table is clean and sql qurries are fast. but DBA is creating indexes on the second jobs target table.this table has 200ml records and DBA says creating indexes is ongoing process which may takes...

Hello Arnd,
i am running this job through shell script.and actually this job is not writing data bcoz usually it takes 3 hr and today it is running for more than 3 hrs and it's in the same status.
i can save it with new name and run.i will let u know the result.

thanks

Thanks Roy, I do clear the RT_STATUS files ,but no luck the job is showing the same behavior. any suggestion. and yes i came to know this morning that some maintaince work on the server faild and the server crashed during the weekend.our server is some where else and some guy at that site told me on...

source is flat file ,target is Oracle 9.2 these jobs have hash file and these hash file loading normally(these are fine),but after the hash files are loaded ,the links from source to next transformer and the rest of the links are showing rows/sec as zero in the monitor window.couple of our jobs are ...

if i select cleanup resources for a perticular job from director, will it effect any other jobs that are currently running(which are using hash files). to day i did the same and some other job is stopped with the following error. Program "JOB.180808767.DT.1358363097.TRANS1": Line 172, Inte...

in 32bit env the max hash file size is 2.2 Gig

In the Director tool under Job tab u can find Cleaanup Resources and Clear Status file try these options to unclock ur job.pl note DS Admin has to enable these commands for u.