|
Problem IT38209
|
Status: Closed |
AS FEDERAION LACK OF CODEPAGE CONVERSION FOR CLOB DATA TYPE IN REMOTE DATA SOURCE, IT WILL CAUSE -901 ERROR "REAL COLUMN LENGTH
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
when the remote data source is no-utf8 codeset, while federation
server data base is 1208 codepage,
there should have codepage conversion between federation server
and data source. But for CLOB data type, it lack of code page
conversion, the length has not been changed, so it causes -901
issue
such as:
remote data source db cfg:
Database code page = 923
Database code set =
ISO885915
federation server db cfg:
Database code page = 1208
Database code set = UTF-8
As federaion lack of codepage conversion for CLOB data type in
remote data source, it will cause -901 error
"real column length exceeds max length"
select clob_column from table_nk1
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "real column length exceeds max length".)
SQLSTATE=58004
db2diag.log
2021-08-30-22.35.57.458734-240 I155236E973 LEVEL:
Severe
PID : 13279 TID : 139783967860480 KTID :
13408
PROC : db2sysc
INSTANCE: haijun NODE : 000 DB :
TESTDBU
APPHDL : 0-7 APPID: *LOCAL.haijun.210831023542
UOWID : 1 ACTID: 1
AUTHID : HAIJUN HOSTNAME: hotellnx113
EDUID : 24 EDUNAME: db2agent (TESTDBU)
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 37
sqlerrmc: real column length exceeds max length
sqlerrp : SQLRI096
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFF97 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
FODC_AppErr
FODC_AppErr_2021-08-30-22.35.57.430856_13279_24_000
13279.24.000.stack.txt
0x00007F2237789837 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x2b1d
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F223A135CDD _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x004e
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F223A1332C2
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x059f
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F223797B28F sqlrrSqlCode + 0x045a
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F2238322A88 _Z13sqlri_djx_rtaP8sqlrr_cb + 0x1f75
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F221F30E315 _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm
+ 0x0c11
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F223838C2F7 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x1b46
(/home/hotellnx113/haijun/sqllib/lib64/libdb2e.so.1)
0x00007F22377A84C8
_Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x199d |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* NA *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.7 or request a special build *
**************************************************************** |
| Local Fix: |
Enlarge CLOB length in federation server, for example, the
former clob length is n, then using following commands to
enlarge it to 3n,
ALTER NICKNAME nk1 ALTER COLUMN clob_column LOCAL TYPE CLOB
(3n); |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* NA *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v11.5.7 or request a special build *
**************************************************************** |
| Comment |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.08.2021
06.10.2021
06.10.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
