DSXchange

Try restarting the JobMonApp . that may work. I checked with Admin team, and found that JobMonApp was not down at all and was working fine. However this problem does not occurs on daily basis, it works fine on weekdays but during saturday, it abends. Does the number of jobs running at a given insta...

I am trying to paramterize the arguments of where clause in Db2 connector stage like below:- Select col1,col2 from schema.tabname1 where col2 IN ('#var1#') Now the above query works well if i pass only 1 value e.g var1='N', but does not pull any data when i pass more than 1 e.g. var1='N','D' I am as...

There is no specific warning for this in the log.

We are facing an issue while running a datastage sequencer. When we open the job monitor from director, sometimes it shows "Stopped" and due to this incorrect counts are displayed.

Any ideas on this?

I have a scenario in which we will need to create history of a given record(based on some key) of the change of the status code:- Input:- key,status_cd,change_dt 1,C,2012-05-25 1,D,2012-05-29 Output:- Key,status_cd,change_dt,effect_dt 1,C,2012-05-28,2012-05-25 1,D,9999-12-31,2012-05-29 Problem is th...

Hi Ajay.. did you find any solution for your scenario. I am also facing a similar one.