3605907 - DB2 upgrade causes issues in real-time replication using DB2 Log Reader adapter - SAP HANA Smart Data Integration

After upgrading the source IBM DB2 database and trying to resume the previously paused remote sources, log reader related errors are occurring. The presented errors are related to log access, or log parsing.

• Errors from DB2 Perspective:
  • E. <Date_time> ERROR com.sybase.ra.lr.udb.RAULogScanner DB2 log read error - sqlcode <-1263>, errp <SQLPRLOG>, msg <...> 
  • E. <Date_time> ERROR com.sybase.ra.lr.udb.RAULogScanner LogReader encountered exception with unknown error: <Log read returned invalid sql code value: <-1263>.>. Don't know how to handle. Stopping Replication.
  • E. <Date_time> ERROR com.sybase.ra.lr.udb.RAULogScanner java.lang.Exception: LogReader encountered exception with unknown error: <Log read returned invalid sql code value: <-1263>. Don't know how to handle. Stopping Replication. 
• Errors from framework trace:
  • <Date_time> [ERROR] <Session_ID> DB2RepAgentWrapper | DB2RepAgentWrapper$2.run [] - LogReader is not in REPLICATE state. State: REPLICATION DOWN.
  • <Date_time> [ERROR] <Session_ID> DPFramework | ReceiverImpl.sendError [] - com.sap.hana.dp.adapter.sdk.AdapterException: LogReader is in ERROR state [Log read returned invalid sql code value: <-1263>.]. Check LogReader instance log <remote_source_name>.log for details. Context: LogReader is in ERROR state [Log read returned invalid sql code value: <-1263>.]. Check LogReader instance log <remote_source_name>.log for details.

• SAP HANA Smart Data Integration
• DB2LogReaderAdapter

DB2 upgrade, SAP HANA Cloud, replication inconsistencies, remote source suspension, log file format, internal logging mechanism, real-time replication, scheduled downtime, unprocessed logs. , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem