DSXchange

Hi, We have completed the development in Windows server and we are in the process of setting up production server in UNIX. And the project has been migrated into production server and the job is running very slow compare to development server while running a job to do the quality check of the server...

These functions are available only in Server jobs not in Parallel.

HTWH.

Regards
Saravanan

This option is same as it is available in DataStage Manager. You can add/drop datasets from this option.

HTWH.

Regards
Saravanan

My memory works correctly, the inter process option should be set in order to get rid of the error occurred.

HTWH.

Regards
Elavenil

Make sure that the same customer id does not exist in both streams otherwise primary key violation would occur while loading this data into a table.

Regards
Elavenil

Hi Ray, The used switches are /c /w. /c - the issued command will be invoked in the command window and /w - the command window will not be closed till the execution of the issued command is completed. Hope this would help you to understand how we resolved the problem and this was implemented as our ...

Hi Arnd,

Thanks for your response.

Managed to do this by enabling few flags available in load command itself.

Regards
Saravanan

Hi, Calling a batch file using DSExecute and the btach file is running fine. But batch file execution takes few minutes and the job completed before the batch file execution completes. We used to execute batch file/shell script in our previous projects and remembered that we got to do something with...

Hi Roy,

Check this RT_SCnn file in the folder for that job and if this file exists in the folder then this could be a bug in DS and we had the same issue in my earlier project and we had to apply the patch and it worked.

HTWH.

Regards
Saravanan

I am very curious to know uvconfig file parameters are related to this problem.

Your inputs are much appreciated.

Thanks & Regards
Saravanan

Thanks Ray for your repsonse. In this case, i would seek IBM support to investigate and resolve the problem.

Regards
Saravanan

Changed the existing job design as mentioned below. Merge ---> Seq File. This temp job got aborted with warning message as 'Fault type is 4. Layer type is BASIC run machine. Fault occurred in BASIC program DSD.StageRun at address 150'. Is there anyway to look at the source code of DSD.StageRun to fi...

Hi Craig,

Thanks for your response.

Am still trying something to figure out what is causing this problem. I would contact support if nothing can be found.

Regards
Saravanan

Hi, Let me explain the design of the job, which is Merge ----> Transformer ----> Few Sequential files (Output) This job processes nearly 5mn records and this job was running fine in the development server (Development server is in Windows) and the same job is giving the weird problem, which is "...

In addition to Kim Duke's SQL statement, add jobno filter in the WHERE clause to give you the file name for that job, which you are looking for.

HTWH.

Regards
Saravanan