Missing 'delete' message in DB Unload log

Document ID : KB000088080
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.

The DB Unload log reports 0 deletes after deleting the AH  and RH rows.

Investigation

The DB Unload log indicates that there are 584 records in the RH table and that the records were deleted.  However, after the delete is 100% finished a message is printed that states  there were '  0' deletes.

After a successful unload the following is written to the log file:

 
20161230/105234.512 - U00011667 Count of records in 'RH' = '584'
20161230/105234.512 - U00037110 Delete records from table 'RH' / progress '100'%
20161230/105234.512 - U00037154 Finished cleanup of Table RH.
20161230/105241.179 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '4:597.681.060'


After the RH is cleared the log ends with the message 0 deletes
 
U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
Environment:
OS Version: N/A
Cause:
Cause type:
By design
Root Cause: The deletion takes place at the end of the DB Unload in bulk with 'EXECUTE', so the message will appear there.
Resolution:
The deletion takes place in bulk with 'EXECUTE'.

Example:

 
20160727/154249.282 - U00003523 UCUDB: Maximum time required for a DB call: '12:005.491.382'.
20160727/154249.297 - U00003522 UCUDB: Database closed. Total time for DB calls: '504:361.053.316' seconds.
20160727/154249.297 - U00003549 UCUDB: ' 953' 'OTHERS ' calls took '2:804.688.416' sec.
20160727/154249.297 - U00003549 UCUDB: ' 12' 'SELECT ' calls took '0:022.982.780' sec.
20160727/154249.297 - U00003549 UCUDB: ' 44281' 'EXECUTE ' calls took '494:970.737.831' sec.
20160727/154249.297 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec.
20160727/154249.297 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
20160727/154249.297 - U00003549 UCUDB: ' 1' 'INSERT ' calls took '0:000.705.930' sec.
20160727/154249.297 - U00003549 UCUDB: ' 10607' 'READ ' calls took '0:677.299.834' sec.
20160727/154249.297 - U00003549 UCUDB: ' 45452' 'CLOSESTMT ' calls took '0:002.372.105' sec.
20160727/154249.297 - U00003549 UCUDB: ' 711' 'TRANSACT ' calls took '5:882.266.418' sec.


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A