Hi Friends,
I have a problem as follows .Please help.
I have a job and in transformer stage i am calling a USER DEFINED routine , if a particular condition occurs then call DSLogWarn
i think i will abort the job and need a reset to run the job again.
so..How can i avoid the job abort and performs a normal exit and can i reset the job using any datastage mechanisams.
Thanks in advance...
Problem related to job abort and exit
Moderators: chulett, rschirm, roy
Call DSLogWarn() will not abort your job, a call to DSLogFatal() will. In your job settings you might be defaulting to make the job abort after 50 warnings; once you reach that number your job will also abort. You can change this value, but it is much better to ensure that you don't generate those warnings.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
It does not affect the performace directly, but yes, there are case where the warning will be generated for each row, which may be millions together, which makes the log file to grow very huge. Which may again lead to project directory to run out of space. Which inturn may affect all other project in that node.
So better to design a job without warning.
So better to design a job without warning.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Hi
I have 10 files of the same type.If any problem with the one of the file the whole job will get aborted..Actually i want to continue with other records which have no problems....so i used DSLogWarn and continue with other files..
If the execes of the warning message may create any probs ..what will be the solution...
Please reply.
Thanks...
I have 10 files of the same type.If any problem with the one of the file the whole job will get aborted..Actually i want to continue with other records which have no problems....so i used DSLogWarn and continue with other files..
If the execes of the warning message may create any probs ..what will be the solution...
Please reply.
Thanks...
Is it a Multiple instance job, reading all the files. What the problem you are expecting? If it is related to the layout mismatch and if you are sure that the number of records that turns out odd will be in manageble number, its better to give out as warning. Else there may be a case where it might be ignored when job finishes without any warn.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
Das,
Resetting depdends on the way you are calling the job for these 10 files.
How are you calling this job for 10 files? If you are calling through a job sequence, then for that job activity just set the run mode to Reset if required, and run.
There are many options available for resetting like using job activity in job sequence, unix script, DS basic script or routine.
Resetting depdends on the way you are calling the job for these 10 files.
How are you calling this job for 10 files? If you are calling through a job sequence, then for that job activity just set the run mode to Reset if required, and run.
There are many options available for resetting like using job activity in job sequence, unix script, DS basic script or routine.
Regards,
S. Kirtikumar.
S. Kirtikumar.