Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2761

debezium-connector-db2: DB2 SQL Error: SQLCODE=-204 on DB2 for z/OS

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Backlog
    • None
    • db2-connector
    • 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.

      https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/cattab/src/tpc/db2z_sysibmsystablestable.html

       

       

      Attachments

        Activity

          People

            urbanetz Peter Urbanetz (Inactive)
            konstantin.krasnov Konstantin Krasnov (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: