DB2 FOR LUW / DB2FORLUW / A10 - DB2

This issue is caused by wrong truncated string (SQL0445W) 
handling on the converged DBCS string and this may also cause 
SQL0902C (-902) system error and shutting down the database. 
 
You will see following error in db2diag.log. 
 
2014-01-22-19.53.37.705000+540 I4034080F539         LEVEL: 
Severe 
PID     : 1704                 TID : 8460           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-843                APPID: *LOCAL.DB2.140122101616 
AUTHID  : DB2ADMIN             HOSTNAME: host0001 
EDUID   : 8460                 EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, global services, sqlzeMapZrc, probe:45 
MESSAGE : ZRC=0x870F00C0=-2029059904=SQLO_DBCSTRUNC 
          "last unconverted char is truncated" 
 
2014-01-22-19.53.38.660000+540 E4034621F825         LEVEL: Error 
PID     : 1704                 TID : 8460           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-843                APPID: *LOCAL.DB2.140122101616 
AUTHID  : DB2ADMIN             HOSTNAME: host0001 
EDUID   : 8460                 EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30 
MESSAGE : ADM14005E  The following error occurred: "AppErr". 
First Occurrence 
          Data Capture (FODC) has been invoked in the following 
mode: 
          "Automatic".  Diagnostic information has been recorded 
in the 
          directory named 
 
"C:\PROGRAMDATA\IBM\DB2\ISWCOPY01\DB2\DIAG0000\FODC_AppErr_2014- 
01-22-19.53.38.660000_1704_8460_000\". 
 
The stack trace includes sqlrrCodePageError after 
sqlriXMLCastXsStringToSQLShortString. 
 
sqloDumpEDU 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeMapZrc 
sqlrrMapZrc 
sqlrrCodePageError 
sqlriXMLCastXsStringToSQLShortString 
sqlriXmlToSql_main 
sqlriXmlToSql 
sqlriSectInvoke 
...............

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 FixPack 4                            * 
****************************************************************

Define the larger size for XML column in the View. 
Depending on the original string and codepage, over three times 
size may be needed to avoid SQL0445W flow.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.1 FixPack 4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

06.02.2014
27.06.2014
08.07.2015