Abort after 999.999 warning

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
eoyylo
Participant
Posts: 57
Joined: Mon Jun 30, 2003 6:56 am

Abort after 999.999 warning

Post by eoyylo »

Hi,
I must run a job with dsrun command in a unix shell.
To run the job I use the next command:

bin/dsjob -run -warn 999999 <project> <job>

and it aborts after 999.999 warning messages.

Is it possible to set the warning limit to "UNLIMITED"?
Which is the unix command to do this?

Thanks in advance

Regards
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Set the limit to zero for unlimited.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

eoyylo,

You could set the warnings to 0

but....

For each warning an entry is written to the log file. For that large a number of warnings you are going to get a job performance that is probably about as fast typing the data into the database by hand (well, maybe not quite that bad, but close enough).

So the better answer to your question is that you absolutely need to get rid of your warnings. Have you approached the issue from tahat angle yet?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Wasn't gonna open that can of worms, Arnd. :wink:

More than a million warnings? And that's ok? :shock: Yikes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Craig - I had to say that about the warnings (if I hadn't I'm sure Ray would have put it in somewhat stronger words when he logs in later). The overhead to write the warnings in that job is going to be far higher than that of the job itself. I've had warning that I was sure I couldn't get rid of - until I was forced to do so, then a solution was found.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Kinda makes you think ...
Are you after Rays position as top poster by far ??? :shock:
gotta give him some scraps for more posts LMAO ;)

Just Kidding :)

Guessing a month tops till you pass my posts Arnd WTG (Way To Go !!!)
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Roy - I'm going for the fast-food high volume posting approach; I'll leave the real quality to Roy's and Ray's (play on words to one of my favorite international food chains, and my favorite bartender [but another Ray] :lol: ).
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Warning!! Warning!!

Post by ray.wurlod »

In a production environment, one warning is too many imho.
One should always seek to design server jobs so that they do not generate any warnings. Then, if one ever does occur, it means that something truly unusual has occurred.

In parallel jobs it's more difficult to eliminate certain specific warnings, but it remains an admirable goal to seek to achieve this result.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply