DB2: Data change capture in tables with XML, Boolean columns

[Anuradha Bhat]

Hello,

I am using Debezium connector for DB2 (LINUX). I have a table which has XML and BOOLEAN column types. I have set this table in capture mode and use Debezium connector to poll data changes.

However, whenever data insert, update or delete operations are performed on this table, the connector fails to poll the changes. The capture program in DB2, stops with the following error:

===============================================

2023-10-17-00.41.20.195915 ASN0552E "Capture" : "ASNCDC" : "WorkerThread" : The program encountered an SQL error. The server name is "". The SQL request is "INSERT". The table name is ""ASNCDC"."CDC_BANK_TABLE1"". The SQLCODE is "-804". The SQLSTATE is "07002". The SQLERRMC is "10252431INPUT". The SQLERRP is "SQLAKCKD". SQL0804N The application program parameters for the current request are not valid. Reason code "102". If a host variable or SQLVAR in the SQLDA is invalid then: host variable/SQLVAR number = "5", SQLTYPE = "243", SQLLEN = "1", host variable/SQLVAR type = "INPUT". SQLSTATE=07002

==============================================

Has anyone encountered this issue ? Are there any known issues with capturing data changes in DB2 when the table has columns with XML and Boolean data types. Could you please suggest a way to resolve this issue.

Thank you !

Anu

[Chris Cranford]

Hi,

I'm not aware that the Db2 connector presently supports XML, which may likely be the issue.  Does it work if you only have a BOOLEAN column without XML?

Thanks,
Chris

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/0fc9d47a-9154-416d-9713-21ef294afbecn%40googlegroups.com.

[Anuradha Bhat]

Thanks, Chris-

You received this message because you are subscribed to a topic in the Google Groups "debezium" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/debezium/zLSjp0JP7qY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/9d9e49b4-2ad5-01da-360c-eac24a8e4263%40gmail.com.