Hi
Has anyone had any luck using Debezium to stream CDC events in DB2 databases hosted on IBM AIX ?
Debezium cdc connectors
Compiled ok (whithout -bE:$1.exp option) :
db2inst1@XXX:/home/db2inst1/asncdctools/src$ export PATH=$PATH:/opt/IBM/xlC/16.1.0/bin
db2inst1@XXX:/home/db2inst1/asncdctools/src$ /db2/bin/V11.5.9.0/samples/c/bldrtn asncdc
.
I have this DB2 error when try to start new defined service :
db2inst1@XXX:/home/db2inst1$ db2 "VALUES ASNCDC.ASNCDCSERVICES('start','asncdc')"
SQL0430N User defined function "ASNCDC.ASNCDCSERVICES" (specific name
"ASNCDCSERVICE") has abnormally terminated. SQLSTATE=38503
DB2 logs :
2024-07-22-16.57.26.899043+120 E4574308A2669 LEVEL: Severe
PID : 13173070 TID : 19051 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : ASSPER
APPHDL : 0-66 APPID: *LOCAL.db2inst1.240722145713
UOWID : 1 ACTID: 1
AUTHID : DB2INST1 HOSTNAME: XXX
EDUID : 19051 EDUNAME: db2agent (ASSPER) 0
FUNCTION: DB2 UDB, oper system services, sqloAtForkPrepareHandler, probe:10
MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown"
DATA #1 : Codepath, 8 bytes
3:5
DATA #2 : String, 117 bytes
An attempt to fork() within unfenced stored procedure is detected, this is not allowed and an error will be returned.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x090000000AFAA6C8 sqloAtForkPrepareHandler + 0x278
[1] 0x09000000006B9190 _atfork_prepare + 0x1F0
[2] 0x09000000003293D4 __fork@AF7_2 + 0x34
[3] 0x09000000003E4CA8 system + 0x128
[4] 0x0900000000C6E314 asncdcservice + 0x114
[5] 0x090000000AC0CD28 sqloInvokeFnArgs + 0x5DB8
[6] 0x090000000ACB8D0C sqloInvokeUDF + 0x3FC
[7] 0x090000000EE6F560 IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x2CA0
[8] 0x090000000EE64B8C sqlriInvokeInvoker__FP10sqlri_ufobb + 0x21EC
[9] 0x090000000EE602D4 sqlriusf_common__FP8sqlrr_cbP10sqlri_ufob + 0x504
[10] 0x090000000EE5FC78 sqlriusf__FP8sqlrr_cb + 0x48
[11] 0x090000000DB40A28 sqlriComputeOnce__FP8sqlrr_cb + 0xA8
[12] 0x090000000B180708 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x698
[13] 0x090000000FD1E6A8 sqlrr_process_fetch_request__FP14db2UCinterface + 0x1478
[14] 0x090000000FD1AD6C sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x23DC
[15] 0x090000000C81F8D4 sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4A4
[16] 0x0900000012DF31A0 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x210
[17] 0x0900000012DF6354 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x2384
[18] 0x0900000012DBE438 IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xBF8
[19] 0x0900000012DC7578 sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB8
[20] 0x0900000012DBC5A4 IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x1474
[21] 0x0900000012DB979C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x33C
[22] 0x090000000B153A88 RunEDU__8sqeAgentFv + 0xCC8
[23] 0x090000000ADCD9D0 EDUDriver__9sqzEDUObjFv + 0x300
[24] 0x090000000ACBA694 sqloEDUEntry + 0x364
[25] 0x0000000000000000 ?unknown + 0x0
[26] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2024-07-22-16.57.26.899686+120 I4576978A752 LEVEL: Warning
PID : 13173070 TID : 19051 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : ASSPER
APPHDL : 0-66 APPID: *LOCAL.db2inst1.240722145713
UOWID : 1 ACTID: 1
AUTHID : DB2INST1 HOSTNAME: XXX
EDUID : 19051 EDUNAME: db2agent (ASSPER) 0
FUNCTION: DB2 UDB, oper system services, sqloInvokeInterruptible, probe:15
DATA #1 : String, 208 bytes
An unfenced User Defined Function (UDF) was abnormally terminated.
This may leave the DB2 engine in inconsistent state.
It is recommended that DB2 server instance is stopped and restarted as soon as possible.
Thanks for your help.
------------------------------
Abderahim ABBAS
------------------------------