home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC66640 Status: Closed

THE MESSAGES LOGGED BY SQLNLSICUCONVERTTODEFAULTDATEFORMAT FUNCTION IN
DB2DIAG.LOG ARE LOGGED AS ERROR.

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
After the APAR fix, the error messages from function 
sqlnlsICUConvertToDefaultDateFormat will be logged as INFO 
message in db2diag.log. For example when DB2 return sqlcode 
SQL20448N for incorrect date format, the following message is 
logged on db2diag.log as error. 
 
 
2010-01-20-23.20.02.120096-300 I26148441A498      LEVEL: Error 
PID     : 643244               TID  : 7489        PROC : db2sysc 
INSTANCE: svtdbm4              NODE : 000         DB   : PROTEUS 
APPHDL  : 0-30481              APPID: 
*LOCAL.svtdbm4.100125162505 
AUTHID  : SVTDBM4 
EDUID   : 7489                 EDUNAME: db2agent (SAMPLE) 
FUNCTION: DB2 UDB, National Language Support, 
sqlnlsICUConvertToDefaultDateFormat_U500, probe:0 
MESSAGE : sqlnlsICUConvertToDefaultDateFormat: Unexpected Error. 
 
After the fix, the above message and similar messages will be 
logged as INFO in db2diag.log instead of error.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.8 FP3 or Subsequent Fix Pack                * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Solution
Problem First Fixed in DB2 Version 9.8 Fix Pack 3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.02.2010
12.11.2012
12.11.2012
Problem solved at the following versions (IBM BugInfos)
9.8.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.3 FixList