DSXchange

Hi khaja,

Check this link and let me know, if you get the result.

viewtopic.php?p=166832&highlight=#16683 ... ds Nagesh.

Hi Deep, As I remember, stage variables required not null values. Becuase, there is no concept of of Null/Not null for Stage variables. I am not sure whether stage variable can hold nulls or not ? Just try out u r setting of Null at the derivation level of Column. May be it will help you. Regards Na...

Hi Chuah, Presently, in your job config file is set for 4 nodes. But, your output database is set for single partition. Problem is your Dataset is created for 4 nodes and it is trying to load the data in a single node constraint partition database. To get out of this problem we can do one thing, jus...

pneumalin, Thanks for your response. I have tried by changing the default value of Environmental Variable APT_MONITOR_SIZE from blank to 100000. But, it's not completely solved my problem. Then I have set the environmental variable APT_NO_JOB_MON to true. Now, my sequence is succesfully completed wi...

Thanks Nitin for your response. Hi All, After Split up of my big sequence in to two sequences, still I am facing the same problem. It's working in Dev and aborting in SYS and OAT for somany times with Unix SIG kill and running after some runs .Can I split those sequences again in to two more sequenc...

Hi Kumar,

Thanx for your response.

I have splitted the sequence in to two parts and I have kept some jobs into the One sequence and other jobs in to the other sequence. Now, I am waiting for result.

Regards
Nagesh

Arnd, Thanks for your reply. I have tried to Identify the problem. IBut, the main thing is the same sequence is working finely in Dev. But, its failing in SYS and UAT. got the following abort message for all my aborting jobs. node_node1: Player 12 terminated unexpectedly. Fatal Error: waitForWriteSi...

Hi Folks, My sequence is getting aborted some times and succesfully completed some times. I have nearly 30 Jobs in my sequence. In that 10 jobs have big derivations. Some times Derivation 1 failing and some times Derivation 1 will run succesfully, but Deriavtion 2 failing. Some times sequence comple...

Hi lstsaur, I have tried to perform TrimLeadingTrailing to my inputcolumn in the key expression and I have tried to put hard code value in the key expression to perform lookup and I have tried to use substring function to my inputcolumn in key expression. In all above cases my job was aborted. More ...

Hi Folks,

If it is a problem with lookup stage GUI then we have to intimate to IBM support. I don't know, what exact way we can intimate this to IBM. Can anybody help out me to do this.

Regards
nagesh.

Hi Folks, I have this question from a long time. Now, I am able to ask about lookup stage in v 7.5.1. One thing I am observed is the Key Expression editor of lookup. When I tried to put some expression their in the key expression editor, It's simply aborting the job. I have tried by giving the param...

The problem with regards to $APT_STRING_PADCHAR is coming in specific project. In development project the sequence using this parameter works fine. However, in the sys test project the sequence is giving problem. Is there any other enviornment variable which is dependent on $APT_STRING_PADCHAR or is...

Arnd, Thanks for your reply. My problem is the APT_STRING_PADCHAR is affecting the jobs, which don't have DB2 EE Stages. My Job flow : first Job DB2 API STAGE .................. Dataset Second Job DATASET ( this one from First Job).............. FILTER .................. DATASET So, the above two jo...

Hi Folks, I am facing a strange problem with $APT_STRING_PADCHAR. I am using this varible for my DB2 EE Load job. It's working fine for my Load job. But, the problem is , when i Tried to set this variable in the sequence. This variable is affecting the other jobs(which don't have $APT_STRING_PADCHAR...

Hi All, I am facing the following warning in DB2 EE stage db2HEW_CHANL_USAGE_SUMMins: The environment variable DB2INSTANCE is currently set to `db2inst1' and is being changed to `ihewd01' as specified in the server option; if this instance is a different version of DB2, the program may not succeed. ...