Hi Joanna
Modifying DIAGLEVEL only affects the db2diag.log - I assume you are seeing
these warnings in the LOAD or IMPORT messages files, not the DIAGPATH logs?
In that case you have a few options, the smartest is A.:
A. apply the modified by timestampformat file type modifier to your load or
import statement (del or asc files only)
B. Edit the load file first
C. Home in on SQL3185W warnings in the message file - these always
immediately follow 'real' errors.
Regards
Alex Levy
Sustainable Software Ltd
-----Original Message-----
From: Sushanta
[mailto:db2udbdba-ezmlmshield-x91113606.[Email address protected]
Sent: 20 February 2008 13:50
To: LazyDBA Discussion
Subject: RE: supress error messages
DBM configuration parameter DIAGLEVEL.
Default [Range]
3 [ 0 -- 4 ]
This parameter specifies the type of diagnostic errors that will be recorded
in the db2diag.log file. Valid values are:
0 - No diagnostic data captured
1 - Severe errors only
2 - All errors
3 - All errors and warnings
4 - All errors, warnings and informational messages
.... Sushanta
-----Original Message-----
From: Saha, Sushanta
Sent: Tuesday, February 19, 2008 4:30 PM
To: 'Joanna Grossman '; LazyDBA Discussion
Subject: RE: supress error messages
Look into setting diag level in your parameter file. It controls the logging
detail.
Thanks
.... Sushanta
-----Original Message-----
From: Joanna Grossman
[mailto:db2udbdba-ezmlmshield-x82565688.[Email address protected]
Sent: Tuesday, February 19, 2008 4:13 PM
To: LazyDBA Discussion
Subject: supress error messages
Is there a way to suppress particular error messages? I'm so sick of the
SQL3129W The date, time, or timestamp field containing
"2007-10-22-00.15.00.00" in row "378819" and column "1" was padded with
blanks.
warning that I could puke. It's just clutter when you're actually looking
for messages that matter. Is there a way to do that?
JG
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************************
**************
The information contained in this message, including attachments, may
contain privileged or confidential information that is intended to be
delivered only to the person identified above. If you are not the intended
recipient, or the person responsible for delivering this message to the
intended recipient, Alltel requests that you immediately notify the sender
and asks that you do not read the message or its attachments, and that you
delete them without copying or sending them to anyone else.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page