3485843 - Job SAP_COLLECTOR_PERFMON_RSDB_TDB hangs

The job SAP_COLLECTOR_PERFMON_RSDB_TDB appears hung, and upon inspecting the active work processes in SM50, you may observe that the work process is in an 'On Hold' state, with no further actions being executed.

SM50 ->
16    BTC    3.258     On Hold    High Load                00:04:40    46            RSDB_TDB    000    DDIC        
23    BTC    30.633    On Hold    High Load                00:00:04    46            RSDB_TDB    000    DDIC
25    BTC    5.163     On Hold    High Load                00:00:33    46            RSDB_TDB    000    DDIC
26    BTC    19.104    On Hold    High Load                00:06:10    46            RSDB_TDB    000    DDIC
29    BTC    30.400    On Hold    High Load                00:37:55    46            RSDB_TDB    000    DDIC

SM37 ->
Job Log Overview for Job:    SAP_COLLECTOR_PERFMON_RSDB_TDB / 07291000
Date       Time     Message text                                                                               Message class Message no. Message type
21.06.2024 07:31:09 Job SAP_COLLECTOR_PERFMON_RSDB_TDB 07291000 started                                             00           516          S
21.06.2024 07:31:09 Step 001 started (program SWNC_TCOLL_STARTER, variant &0000000080206, user ID DDIC)             00           550          S
21.06.2024 07:31:09 being executed "RSDB_TDB"                                                                       00           001          S 

SAP_BASIS    755
SAP_BASIS    756
SAP_BASIS    757
SAP_BASIS    758

RSDB_TDB , KBA , BC-CCM-MON-TUN , Workload Monitoring Tool , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-CCM-MON-ORA , Database Monitors for Oracle , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , BC-DB-DB2-CCM , DB2 for z/OS - CCM/Database monitors , HAN-DB-MON , SAP HANA Monitoring , BC-DB-SDB-CCM , CCMS/Database Monitors , BC-DB-DB4 , DB2 for AS/400 , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem