Automic DB UnLoad Utility is hanging without any error.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Problem with the Automic DB UnLoad Utility in the daily archive-workflow.

The DB UnLoad Utility hangs after processing the table "MELD" and appears to be blocked.

Environment

Automic Workload Automation Release : 12.3.9

AE DB Unload (UCYBDBUN.EXE) : 12.3.9

Cause

This is caused due to a continuous JOB loop which produced lot of data in MELD Table.

Resolution

In Automic Utility DB Unload Install Folder:

Open ucybdbun.ini and change the default REORG_CHUNK_SIZE=1000 to REORG_CHUNK_SIZE=10  

Reducing default chunk size to the specified enables a small amount is deleted within one transaction.

Now save and exit and then run the DB Unload again and wait till it completes the process,

Please note: During this unload process please engage Oracle DB Admin to find the back ground process of deleting data to find the background process in database.