IBM Support

SQL5199N error when working with an External Table

Troubleshooting


Problem

SQL5199N Error reported when working with an External Table:
SQL5199N The statement failed because a connection to a Hadoop/External Table I/O component could not be established or maintained. Hadoop/External Table I/O component name: "SQL External Table DFSIO". Reason code: "1". Database partition number: "0". SQLSTATE=57067

Symptom

SQL5199N error reported when working with an External Table:
SQL5199N The statement failed because a connection to a Hadoop/External Table I/O component could not be established or maintained. Hadoop/External Table I/O component name: "SQL External Table DFSIO". Reason code: "1". Database partition number: "0". SQLSTATE=57067
The db2diag.log contains messages like:
2023-02-21-10.24.57.491947-300 I3832056E3517     LEVEL: Warning
PID   : 108511        TID : 140322323556096 PROC : db2sysc 0
INSTANCE: db2inst1       NODE : 000      DB  : SAMPLE
APPHDL : 0-799        APPID: *LOCAL.db2inst1.230221152455
UOWID  : 1          ACTID: 1
AUTHID : DB2INST1       HOSTNAME: ***.****.*****.***
EDUID  : 180         EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx, probe:1000
MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size"
     DIA8563C An invalid memory size was requested.
DATA #1 : String, 43 bytes
Memory management block allocation failure.
DATA #2 : Codepath, 8 bytes
2
DATA #3 : Memory pool handle pointer, PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
0x0000000240003418
DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
0
DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8 bytes
0
DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS, 4 bytes
0x00000000
DATA #7 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 58 bytes
/home/regress1/db2/engn/include/sqlz_low_contention_impl.h
DATA #8 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
100
DATA #9 : Resource binding pointer, PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
0x0000000000000000
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
 [0] 0x00007FA4068ACF24 sqloGetMemoryBlockExtended + 0x5B4
 [1] 0x00007FA40473E330 _ZN19sqerCommBufferQueue21createCommBufferQueueEP13SQLO_MEM_POOLmPPS_ + 0x140
 [2] 0x00007FA4047717E0 _Z17sqlerAddFmpToPoolP17sqlerFmpParmsBaseP14sqlerFmpHandlePiP16SQLO_EDUWAITPOSTP8sqeAgentbbbib22sqlerRemoteComponentId + 0xEB0
 [3] 0x00007FA404773E02 _Z19sqlerGetFmpFromPoolP14sqlerFmpHandleP17sqlerFmpParmsBase + 0x862
 [4] 0x00007FA40478A6DD _Z29sqlerGetFmpThreadForFmpClientP8sqeAgentP19sqlerFmpClientParms + 0x4D
 [5] 0x00007FA40478AAC3 _Z38sqlerGetFmpThreadForFmpClientWithRetryP8sqeAgentP23SQLER_FMP_CONNECT_PARMSPP13sqerFmpClient + 0x133
 [6] 0x00007FA40478AEF2 _Z17sqlerConnectToFmpP8sqeAgentP23SQLER_FMP_CONNECT_PARMSPP13sqerFmpClient + 0x42
 [7] 0x00007FA40478B339 /db2/db2icert/sqllib/lib64/libdb2e.so.1 + 0x8A34339
 [8] 0x00007FA40479BEE3 _Z21sqlerExtTableOpenScanP8sqeAgentP21SQLER_EXT_TABLE_PARMSP37SQLER_EXT_TABLE_DESERIALIZATION_PARMSP18sqerExtTableHandleP17sqer + 0x343
 [9] 0x00007FA4078051E4 _Z20sqlriHadoopTableOpenP8sqlrr_cbP16sqlriHadoopTable + 0x864
 [10] 0x00007FA407808E8B _Z20sqlriHadoopTableScanP8sqlrr_cb + 0x19B
 [11] 0x00007FA4075E5F07 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x5E7
 [12] 0x00007FA407077293 _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x763
 [13] 0x00007FA40707A4DC _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x151C
 [14] 0x00007FA404A8C648 _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x518
 [15] 0x00007FA404A6C9B3 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x343
 [16] 0x00007FA404A6E53A _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x83A
 [17] 0x00007FA404A65931 /db2/db2icert/sqllib/lib64/libdb2e.so.1 + 0x8D0E931
 [18] 0x00007FA404A698A5 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xCF5
 [19] 0x00007FA4043B4E99 _ZN8sqeAgent6RunEDUEv + 0x639
 [20] 0x00007FA408676984 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4
 [21] 0x00007FA406901BD9 sqloEDUEntry + 0x2A9
 [22] 0x00007FA40D546EA5 /lib64/libpthread.so.0 + 0x7EA5
 [23] 0x00007FA3FAC88B0D clone + 0x6D

2023-02-21-10.24.57.523914-300 I3835574E655     LEVEL: Severe
PID   : 108511        TID : 140322323556096 PROC : db2sysc 0
INSTANCE: db2inst1       NODE : 000      DB  : SAMPLE
APPHDL : 0-799        APPID: *LOCAL.db2inst1.230221152455
UOWID  : 1          ACTID: 1
AUTHID : DB2INST1       HOSTNAME: ***.****.*****.***
EDUID  : 180         EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, global services, sqzLowContentionVectorElem::new, probe:10
RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size"
     DIA8563C An invalid memory size was requested.

2023-02-21-10.24.57.524208-300 I3836230E843     LEVEL: Error
PID   : 108511        TID : 140322323556096 PROC : db2sysc 0
INSTANCE: db2inst1       NODE : 000      DB  : SAMPLE
APPHDL : 0-799        APPID: *LOCAL.db2inst1.230221152455
UOWID  : 1          ACTID: 1
AUTHID : DB2INST1       HOSTNAME: ***.****.*****.***
EDUID  : 180         EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqerCommBufferAllocator::mTermCommBufferAllocator, probe:385
MESSAGE : ZRC=0x822401F0=-2111569424=SQLER_EXT_TABLE_FMP_FAILED
     "A DB2 Fenced Mode Process abnormally terminated."
DATA #1 : String, 43 bytes
Error allocating communication buffer queue
DATA #2 : String, 26 bytes
Maximum number of buffers:
DATA #3 : signed integer, 8 bytes
875708820

Note the Maximum number of buffers - 875708820 in this case - can be different, but it will still be a large number

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmhAAE","label":"Routines - Stored Procedures and UDF-\u003Edb2fmp"}],"ARM Case Number":"TS012192749","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

ibm17006105

Page Feedback