DSXchange

Hi All,

I have to run a job from command line, and pass an environment variable, called in my job every time through dsjob and -param option.

Can anyone suggest what is the correct syntax for it.

I want to add to the previous note that, /data/ds/Projects/dpr_aos_dev is existing and dpr_aos_dev folder has following privilages:- cbidev01 /data/ds/Projects $>ls -ltr total 39392 drwxrwsr-x 51 dsadm dstage 4096 Mar 04 23:20 dpr_aos_dev drwxrwsr-x 2972 dsadm dstage 192512 Mar 05 13:22 dpr_iccm_de...

I want to add to the previous note that, /data/ds/Projects/dpr_aos_dev is existing and dpr_aos_dev folder has following privilages:- cbidev01 /data/ds/Projects $>ls -ltr total 39392 drwxrwsr-x 51 dsadm dstage 4096 Mar 04 23:20 dpr_aos_dev drwxrwsr-x 2972 dsadm dstage 192512 Mar 05 13:22 dpr_iccm_de...

The second log entry in the director show which file is actually being used at runtime, please do check there after a run to make 100% certain that this is the actual configuration file being used. Furthermore, does that directory exist on both nodes? Actual config file used is:- main_program: APT ...

Are you certain that the config file you posted is what is actually being used (check the 2nd entry in the director log for the run to confirm), since the dpr_aos_dev directory is not contained in the config file EBI_TwoNode.apt. What stage is node_db2node3 that is triggering the warning? Thanks fo...

Are you certain that the config file you posted is what is actually being used (check the 2nd entry in the director log for the run to confirm), since the dpr_aos_dev directory is not contained in the config file EBI_TwoNode.apt. What stage is node_db2node3 that is triggering the warning? Thanks fo...

I want to add to the previous note that, /data/ds/Projects/dpr_aos_dev is existing and dpr_aos_dev folder has following privilages:- cbidev01 /data/ds/Projects $>ls -ltr total 39392 drwxrwsr-x 51 dsadm dstage 4096 Mar 04 23:20 dpr_aos_dev drwxrwsr-x 2972 dsadm dstage 192512 Mar 05 13:22 dpr_iccm_dev...

Hi All, I have created one new project on the same ds,and able to successfully connect to DB2 database which is on other server,and here i m using same config file which is used in other running project. Now when i run the job,i m getting one warning message which seems not create any problem now bu...

Why would a row be rejected if the value of a column in NULL. Please elaborate

Thnaks Ray......

Hi All, I am having one confusion in job.......like in some of the jobs prior to aggrigator stage data is hash partitioned on lets say A,B & C columns and in aggrigator, grouping is done on A,B,C,D(where D is not constent). Will the result correct and what will be the impact on performance ?? th...

What Ragavendra means is there has to be some condition for which you may not want to run that job.

Else why to keep that job in the sequencer

Hi Ray, With due respect i Need your urgent suggestion.We are not able connect to the DataStage. Getting the below error Ist Time got this error: "Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctly in project NiharTest (Subroutine failed to complete ...

What are the entries that you have made in your dsenv file.
Also remember what I have found in general, you need to restart your engine
whenever you make any entry in your dsenv file and you don't need to do so if you made the entries in the administrator

The join stage will first sort the input streams according to your join key(s), unless that has been already done or explicitly turned off. That way the join mechanism can process the data without having to store large amounts of interim data in memory or on disk. Each Node is completely distinct a...