Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
False
-
Undefined
Description
I use db2-connector for DB2 for z/OS.
I get an error when starting work:
2020-11-13 18:39:14,156 INFO || Exporting data from table 'DB2ADM1.TABLE2' [io.debezium.relational.RelationalSnapshotChangeEventSource] 2020-11-13 18:39:14,156 INFO || For table 'DB2ADM1.TABLE2' using select statement: 'SELECT * FROM DB2ADM1.TABLE2' [io.debezium.relational.RelationalSnapshotChangeEventSource] 2020-11-13 18:39:14,187 INFO || Finished exporting 2 records for table 'DB2ADM1.TABLE2'; total duration '00:00:00.03' [io.debezium.relational.RelationalSnapshotChangeEventSource] 2020-11-13 18:39:14,198 INFO || Snapshot - Final stage [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource] 2020-11-13 18:39:14,198 INFO || Snapshot ended with SnapshotResult [status=COMPLETED, offset=Db2OffsetContext [sourceInfoSchema=Schema\{io.debezium.connector.db2.Source:STRUCT}, sourceInfo =SourceInfo [serverName=db2server2, changeLsn=NULL, commitLsn=00000000:001f592a:894e000000000000, snapshot=FALSE, sourceTime=2020-11-13T18:39:14.186Z], partition=\{server=db2server2}, snapsho tCompleted=true, eventSerialNo=1]] [io.debezium.pipeline.ChangeEventSourceCoordinator] 2020-11-13 18:39:14,201 INFO || Connected metrics set to 'true' [io.debezium.pipeline.metrics.StreamingChangeEventSourceMetrics] 2020-11-13 18:39:14,202 INFO || Starting streaming [io.debezium.pipeline.ChangeEventSourceCoordinator] 2020-11-13 18:39:14,234 ERROR || Producer failure [io.debezium.pipeline.ErrorHandler] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.TABLES, DRIVER=4.26.14 at com.ibm.db2.jcc.am.b7.a(b7.java:810) at com.ibm.db2.jcc.am.b7.a(b7.java:66) at com.ibm.db2.jcc.am.b7.a(b7.java:140) at com.ibm.db2.jcc.am.k4.c(k4.java:2824) at com.ibm.db2.jcc.am.k4.d(k4.java:2808) at com.ibm.db2.jcc.am.k4.a(k4.java:2234) at com.ibm.db2.jcc.am.k4.a(k4.java:2210) at com.ibm.db2.jcc.t4.ab.i(ab.java:201) at com.ibm.db2.jcc.t4.ab.b(ab.java:96) at com.ibm.db2.jcc.t4.p.a(p.java:32) at com.ibm.db2.jcc.t4.av.i(av.java:150) at com.ibm.db2.jcc.am.k4.al(k4.java:2203) at com.ibm.db2.jcc.am.k4.a(k4.java:3330) at com.ibm.db2.jcc.am.k4.a(k4.java:737) at com.ibm.db2.jcc.am.k4.executeQuery(k4.java:716) at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:642) at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:511) at io.debezium.connector.db2.Db2Connection.listOfChangeTables(Db2Connection.java:264) at io.debezium.connector.db2.Db2StreamingChangeEventSource.getCdcTablesToQuery(Db2StreamingChangeEventSource.java:283) at io.debezium.connector.db2.Db2StreamingChangeEventSource.execute(Db2StreamingChangeEventSource.java:106) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) 2020-11-13 18:39:14,235 INFO || Finished streaming [io.debezium.pipeline.ChangeEventSourceCoordinator]
There is no table or view SYSCAT.TABLES in the DB2 for z/OS. For this purpose, the table SYSIBM.SYSTABLES is used.