The DB Unload tool (ucybdbun) hangs when deleting records from RT Table.
The following can be seen in the log:
tail -n 4 ucybdbun_log_00.txt
20200402/010254.233 - U00037111 Starting reorganization for client: '3100'
20200402/010255.392 - U00011667 Count of records in 'MELD' = '2832'
20200402/010255.392 - U00037110 Delete records from table 'MELD' / progress '100'%
20200402/010255.392 - U00037172 Finished cleanup of Table Meld
<----- no further content in log --->
When setting the database=4 trace in ucybdbun.ini as follows:
[TRACE]
database = 4
We can find that the SQL statement that hangs is the delete from RT statement ( cleanup of the table RT) :
tail -n 1 ucybdbun_trace_00.txt
20200402/010255.458 - delete from RT where RT_AH_Idnr in (select DIVDB_PK from DIVDB)
<----- no further content in log --->
Release : 12.2 and superior
Component : AUTOMATION ENGINE
Database: Oracle