DB2 - Problem description
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) |