DSXchange

ray.wurlod wrote:DSNs need to be configured on the server AND recorded in the uvodbc.config file for the project. ...

Thanks Ray..

I found the file in
/opt/Ascential/Ascential/DataStage/Projects/ProjName/ directory

Hi,
How do we add a DSN name to the metadata(displayed in te IMPORT METADATA) stage.I can see only one DSN name in my designer.

Hey guys,
Thanks a lot for your help.
The delay was being induced by ever increasing job logs.
We had logs over 2 years old. The huge size of the logs was causing the performance drop.
Once the older logs have been purged, The performance is good again.

Thanks again for your support.

Perhaps it's obvious to everyone else, but I'm curious what "disturbing the link properties" means here. :? I mean,if I have a job flow like this. seq.File---->transformer------->oracle when I am trying to keep a peek stage in the middle of transformer and oracle stages but by doing that ...

Hi , I have a doubt regarding the usage of peek stage. I have a DS job that was productionzed and I need to analyse it for some business requirements. I thought of putting a peek stage in between the stages of the job but I am unable to do it without disturbing the link properties. I finally ended u...

Hi Chulett, We have a script (being kicked off every 5 mins from CRON) which keeps monitoring a set of ftp directories for files(with each file having one record in it). If files are found in any of the monitored directories, the files from are picked up and all the corresponding records are clubbed...

Hi, It seems, I have caused some confusion. Let me put forward my problem in detail: We have a Datastage project having about 22 jobs. We have created multiple copies of the above project and incoming files(Each file contains a maximum of 5 records) are routed into one these projects. These differen...

No, the load is constant. Its just the processing time which has been increasing over time.

Hi Ray and chulett,
Thank you for your help. I have tried deleting the older files in the &PH& folder, but am still not able to observe any positive outcome

Hi, We have a Data stage project, running 24X7, whose performance has been steadily degrading. The mean time taken for processing a record has been increasing over time. On analysis, we found that the actual running time of the job has not changed , rather the time between the Unix script calling th...

It's -jobinfo that you need to run before -run, not -jobstatus. The -jobstatus option is a sub-option of -run. Search DSXchange for error code -14, and then reduce the total load on your server. ... Thanks Ray, I found that job is giving a timed out error because my job was not checked to run in mu...

Hi all, while trying to run the following command dsjob -file /opt/Ascential/Data/ds_passwords.txt host1 -run -jobstatus project1 job1.servidejob1 I am facing the following error Status code = -14 DSJE_TIMEOUT Return code 65280 I created this job recently in a development project and imported it to ...

ray.wurlod wrote:There is no such option (as the one you asked for) in Manager client's Export dialog. ...

thanks ray..
and Saad..ur dependency concept helped me
thanks guys

Hi,
Can We import all the jobs accessed by a sequence to a single .dsx file.
please enlighten me..I m using DS7.5.1 version

You can issue user defined query ' delete from tablename with nologging" that will do couple of things 1. It will not make log 2. It is very fast compared to normal delete. Rgds, Chakradhar. Hi when I try executing this stmt(with nologging) in oracle..it is giving me an error that "statem...