DSXchange

Thanks.. As suggested we have created a C++ utility that looks for the dialogue box and record the message to a log file and closes the warning message.

This is a test for what Ray has suggested. We have process which reads from XMETA the job name and then we generate set of dsexport command. For some reasons if dsexport throws some warning the entire batch gets stuck until manual intervention. We wanted to avoid this.

It still popped up window with warning the job doesn't exist.

"C:\IBM\InformationServer\Clients\Classic\dsexport" /D=Server:9080 /H=Host /U=user /P=XXX HLK_DEV /XML /JOB=CopyOfSQ25TgtChrgReg D:\CopyOfSQ25TgtChrgReg.xml < .\NUL

DScmdexport exports as dsx where as the requirement is to export as XML.

We have a requirement to export all the jobs as XML and we have created a bat script to export it. But in case of warnings It waits for user input to proceed further. Is there a way to ignore these warning messages or any other alternative approach? We get the jobs list from XMETA and use that to cr...

Sorry.. please ignore the previous design post..

Yes..
The job design:-
|-->Agg-->Agg-->TD API
Hash-->Transformer-->Sort>-->Transformer|-->Agg-->Agg-->TD API
|-->Agg-->Agg-->TD API

It logs the following message every 15 to 2o sec

Job1..AGG_AT_CATEGORY.Week_Cat_Agg: Run stopped after 11553336 rows

I restarted the datastage engine still the log seems filling up. Quite strange.. When I rerun the job it is is throwing Mutex() error because of this. But This goes off when the windows server is rebooted. Can any one suggest how to avoid this. And also why this is happening..

Based on the recommendation my new job design look like the following |-->Agg-->Agg-->TD API Hash-->Transformer-->Sort>-->Transformer|-->Agg-->Agg-->TD API |-->Agg-->Agg-->TD API I sorted the column in ASC order.

The job design is as follows -->Agg-->Agg-->TD API Hash-->Transformer-->Agg-->Agg-->TD API -->Agg-->Agg-->TD API The above job has 12 mil to process and final aggregated output is around 400 rows.The aborted with the following error. From previous run DataStage Job 229 Phantom 3104 Program "DSP...

A job with aggregator when stopped starts filling the job log. Can someone explain why this is happening and how to avoid it. I tired to kill the process by looking for the process. I found the job ID and looked for any process which uses RT_LOG#Process id#. But i couldn't find any such process. Ple...

Use Join stage instead of look up...

I couldn't understand why aggregator stage is generating such log messages when the job is being stopped. I couldn't find any process associated with this job in the clean up resources option. I'm able to compile the same job and rerun but the jobs is aborting with message User Generated Abort with ...

Hi,
Which process did you turn of. I'm still getting this error. This happens every time aggregator is stopped. We have Datastage 7.5.3 run on Windows.
Thanks