Missing "delete" message in DB unload log

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

When running the DB Unload utility from the Automation Engine (AE) version 11.2.3 the log states 0 deletes were performed.

For 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.


However, this behavior may be seen on other AE versions as well.

Cause:
Cause type:
By design
Root Cause: Deletes are done in bulk.
Resolution:
The deletes are done in bulk => 20160727/154249.297 - U00003549 UCUDB: ' 44281' 'EXECUTE ' calls took '494:970.737.831' sec.
Therefore, this behavior is as designed.

Fix Status: No Fix

Additional Information:
Workaround :
N/A