UtilityRunJob error with DataStage 8.1
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 28, 2006 9:54 am
- Location: BrasÃlia - Brazil
UtilityRunJob error with DataStage 8.1
Hi,
I am using the routine "UtilityRunJob" within a basic transformer in a parallel job in version 8.1.
I am referring to the routine this way:
UtilityRunJob ( 'JobOD0040B', 'PAR_DATA_MOV_ABERTO =': lnk_02.DATA_MOV_ABERTO_OD: '| SISTEMAS_DATA_EM =': lnk_02.SISTEMAS_DATA_EM, 0, 0)
The job where the basic bransformer is, run normally, however, the job JobOD0040B aborts always with these messages in the log:
"Job control process (pid 34664) has failed"
"Job aborted JobOD0040B"
Changing only the number of pid.
Thank you!
I am using the routine "UtilityRunJob" within a basic transformer in a parallel job in version 8.1.
I am referring to the routine this way:
UtilityRunJob ( 'JobOD0040B', 'PAR_DATA_MOV_ABERTO =': lnk_02.DATA_MOV_ABERTO_OD: '| SISTEMAS_DATA_EM =': lnk_02.SISTEMAS_DATA_EM, 0, 0)
The job where the basic bransformer is, run normally, however, the job JobOD0040B aborts always with these messages in the log:
"Job control process (pid 34664) has failed"
"Job aborted JobOD0040B"
Changing only the number of pid.
Thank you!
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Marcelo,
I would set the basic transfomer to execute sequentially or used a single node config file...or you will be executing the job multiple time as many as your $APT_CONFIG_FILE,
If you really need to execute the 'child' dependent job multiple times then make it multiple instance ...
Have fun ...
I would set the basic transfomer to execute sequentially or used a single node config file...or you will be executing the job multiple time as many as your $APT_CONFIG_FILE,
If you really need to execute the 'child' dependent job multiple times then make it multiple instance ...
Have fun ...
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 28, 2006 9:54 am
- Location: BrasÃlia - Brazil
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 28, 2006 9:54 am
- Location: BrasÃlia - Brazil
chulett ,
The value I need to pass as a parameter is the result of an SQL query.
To get this result through a sequence would need to write the output into a file and create a routine to read this file in sequence and pass the value as a parameter.
However, I can not write temporary files on the machine.
Thank you!
The value I need to pass as a parameter is the result of an SQL query.
To get this result through a sequence would need to write the output into a file and create a routine to read this file in sequence and pass the value as a parameter.
However, I can not write temporary files on the machine.
Thank you!
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Marcelo,
How about using a sequence and two jobs. The first one, a server job extracts the value using your SQL and place it in the job's user status area. The second job activity (obOD0040B) will have the previous job user status available to be pass as a parameter value
Search the forum for other poster on this. I rather prefer this method because is more clean
Thanks,
Julio
How about using a sequence and two jobs. The first one, a server job extracts the value using your SQL and place it in the job's user status area. The second job activity (obOD0040B) will have the previous job user status available to be pass as a parameter value
Search the forum for other poster on this. I rather prefer this method because is more clean
Thanks,
Julio
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 28, 2006 9:54 am
- Location: BrasÃlia - Brazil
There is no way you can read or write userstatus in a parallel job. That has beed clarified througly.marcelo_almeida wrote:I created a test and worked properly when I used the routine changing the $ UserStatus within a server job.
However, I need to do this in a basic transformer inserted in a parallel job. This way is not working, the value is not assigned to the variable $ UserStatus.
Thank you,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why?marcelo_almeida wrote:However, I need to do this in a basic transformer inserted in a parallel job.
If there's only one record then a server job will be far more efficient.
And then you can use UtilityRunJob properly.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.