|
Problem IC99204
|
Status: Closed |
DB2 might dump FODC_AppErr due to CodePage error when selecting XML column via VIEW when truncation is happening. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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
............... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 FixPack 4 *
**************************************************************** |
| Local Fix: |
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. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.02.2014
27.06.2014
08.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
