2025-10-13T17:04:17,117 INFO   DB2_Server||snapshot  According to the connector configuration both schema and data will be snapshot.   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2025-10-13T17:04:17,127 INFO   DB2_Server||snapshot  Snapshot step 1 - Preparing   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2025-10-13T17:04:17,128 INFO   DB2_Server||snapshot  Snapshot - Final stage   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
2025-10-13T17:04:17,129 INFO   DB2_Server||snapshot  Snapshot completed   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
2025-10-13T17:04:17,138 ERROR  DB2_Server||snapshot  Producer failure   [io.debezium.pipeline.ErrorHandler]
java.lang.RuntimeException: Failed to set transaction isolation level.
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.close(Db2SnapshotChangeEventSource.java:193) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.completed(Db2SnapshotChangeEventSource.java:180) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:114) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:298) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:282) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:196) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:147) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
        at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10139][10309][3.69.24] Invalid parameter: 0 is an invalid transaction isolation level.  See Javadoc specification for a list of valid values. ERRORCODE=-4461, SQLSTATE=42815
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.Connection.setTransactionIsolation(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.close(Db2SnapshotChangeEventSource.java:190) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        ... 11 more
2025-10-13T17:04:17,165 INFO   DB2_Server||snapshot  Connected metrics set to 'false'   [io.debezium.pipeline.ChangeEventSourceCoordinator]
2025-10-13T17:04:17,546 DEBUG  DB2_Server||db2-server-connector-task  checking for more records...   [io.debezium.connector.base.ChangeEventQueue]
2025-10-13T17:04:17,553 DEBUG  DB2_Server||db2-server-connector-task  polling records...   [io.debezium.connector.base.ChangeEventQueue]
2025-10-13T17:04:17,555 ERROR  ||  WorkerSourceTask{id=db2-connector-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted   [org.apache.kafka.connect.runtime.WorkerTask]
org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
        at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:67) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:154) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
        at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
Caused by: java.lang.RuntimeException: Failed to set transaction isolation level.
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.close(Db2SnapshotChangeEventSource.java:193) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.completed(Db2SnapshotChangeEventSource.java:180) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:114) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:298) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:282) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:196) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:147) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        ... 5 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10139][10309][3.69.24] Invalid parameter: 0 is an invalid transaction isolation level.  See Javadoc specification for a list of valid values. ERRORCODE=-4461, SQLSTATE=42815
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.gd.a(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at com.ibm.db2.jcc.am.Connection.setTransactionIsolation(Unknown Source) ~[db2jcc-10.5.0.5.jar:?]
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.close(Db2SnapshotChangeEventSource.java:190) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.connector.db2.Db2SnapshotChangeEventSource.completed(Db2SnapshotChangeEventSource.java:180) ~[debezium-connector-db2-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:114) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:298) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:282) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:196) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:147) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
        ... 5 more
2025-10-13T17:04:17,561 INFO   ||  Stopping down connector   [io.debezium.connector.common.BaseSourceTask]
2025-10-13T17:04:17,572 INFO   ||  Creating thread debezium-db2connector-employee-SignalProcessor   [io.debezium.util.Threads]
2025-10-13T17:04:17,574 INFO   ||  SignalProcessor stopped   [io.debezium.pipeline.signal.SignalProcessor]
2025-10-13T17:04:17,578 INFO   ||  Debezium ServiceRegistry stopped.   [io.debezium.service.DefaultServiceRegistry]