3293653 - Job SAP_COLLECTOR_PERFMON_RSDB_HRLY job reports exception CX_DBA_ADBC.

Symptom

Job SAP_COLLECTOR_PERFMON_RSDB_HRLY (program: RSDB2_RUN_HOURLY_REMOTE) completes successfully but consistently reports a CX_DBA_ADBC exception in the job log.

Job log overview for job: SAP_COLLECTOR_PERFMON_RSDB_HRLY
------------------------------------------------------------------------------------------------------------
Date |Time |Message text
------------------------------------------------------------------------------------------------------------
30.12.2022|04:41:19|Job started
30.12.2022|04:41:19|Step 001 started (program SWNC_TCOLL_STARTER, variant &0000000700414, user ID BTC_BASIS)
30.12.2022|04:41:21|:Exception CX_DBA_ADBC in program RSDB2_RUN_HOURLY_REMOTE line 0
30.12.2022|04:41:21|: Kernel Error ID:
30.12.2022|04:41:21|: WP ID: 37
30.12.2022|04:41:21|: WP PID: 11338238
30.12.2022|04:41:21|: Application Server: auggvcbns101
30.12.2022|04:41:21|: SYSID: NS1
30.12.2022|04:41:21|: SY-SUBRC: 0
30.12.2022|04:41:21|: SY-TABIX: 3
30.12.2022|04:41:21|: SY-BATCH: X
30.12.2022|04:41:21|: SQLstatement:
30.12.2022|04:41:21|: Database:
30.12.2022|04:41:21|:caused by
30.12.2022|04:41:21|: CX_DBA_ROOT = 253A292D64363A4E832541F44E16217D
30.12.2022|04:41:21|: CX_NAME =CX_DBA_ROOT
30.12.2022|04:41:21|: CX_ROOT = 16AA9A3937A9BB56E10000000A11447B
30.12.2022|04:41:21|: LOG_ADA = ADA
30.12.2022|04:41:21|: LOG_DB2 = DB2
30.12.2022|04:41:21|: LOG_DB4 = DB4
30.12.2022|04:41:21|: LOG_DB6 = DB6
30.12.2022|04:41:21|: LOG_DBA = DBA
30.12.2022|04:41:21|: LOG_MSS = MSS
30.12.2022|04:41:21|: LOG_ORA = ORA
30.12.2022|04:41:21|: MSG_TYPE_ERROR = E
30.12.2022|04:41:21|: MSG_TYPE_WARNING = W
30.12.2022|04:41:21|: PROGRAM_NAME = RSDB2_RUN_HOURLY_REMOTE
30.12.2022|04:41:21|: TEXTID = 253A292D64363A4E832541F44E16217D
30.12.2022|04:41:21|Exception CX_DBA_ADBC in program RSDB2_RUN_HOURLY_REMOTE include line 0
30.12.2022|04:41:22|Succesfull
30.12.2022|04:41:22|Job finished
------------------------------------------------------------------------------------------------------------

Additionally sm21 shows SQLCODE = 100 reading table DB2QALRTLOAD:
------------------------------------------------------------------------------------------------------------
30.12.2022|04:41:21|037|20221229 174121 DSNT404I SQLCODE = 100, NOT FOUND: ROW NOT FOUND FOR FETCH, UPDATE, OR DELETE, OR T
30.12.2022|04:41:21|037|HE RESULT OF A QUERY IS AN EMPTY TABLE DSNT418I SQLSTATE = 02000 SQLSTATE RETURN CODE DSNT415I SQLER
30.12.2022|04:41:21|037|RP = DSNXRFFL SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -110 0 0 -1 0 0 SQL DIAGNOSTIC INFORM
30.12.2022|04:41:21|037|ATION DSNT416I SQLERRD = X'FFFFFF92' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL
30.12.2022|04:41:21|037|DIAGNOSTIC INFORMATION 20221229 174121 SQL statement: 20221229 174121 SELECT DATA FROM DB2QALRT
30.12.2022|04:41:21|037|LOAD WHERE EXECNAME = 'sapcl'
30.12.2022|04:41:21|037|NS1: true (see SLG1 object DBACOCKPIT)
------------------------------------------------------------------------------------------------------------

Environment

SAP Netweaver any release
SAP DB2 z/OS any release

Product

SAP NetWeaver Application Server for ABAP all versions

Keywords

SAPCL , DB2QALRT , SAP_COLLECTOR_PERFMON_RSDB_HRLY , RSDB2_RUN_HOURLY_REMOTE , KBA , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.