VARA UC_UTILITY_DB_UNLOAD never purged and cannot be cleared via AWI

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

On your QA system (250+ clients) the vara UC_UTILITY_DB_UNLOAD  contains more than 20000 lines and each unload report of the 250 clients has 15 lines just to display the content of this vara.

On the Production systems, this is even worse, you have 60000 lines on that vara UC_UTILITY_DB_UNLOAD .

Can you please provide a way in the future to empty this VARA or not printing its content (20000 unnecessary lines) in the reports or perform automatically a cleanup of it?

Environment

Automation Engine 24.x and inferior on any database.

Cause

DE178369: Automic uses this VARA  on all versions on which there are dates of the unloading(deleting) process of reorganized data records. The longer the dbunload has been running, the longer the VARA content will be, the slower the procedure will be and larger dbunload reports will be generated.

Resolution

Workaround:

First, please make sure your AE is on version 24.4.x beforehand.

Then you can launch the dbload tool with the attached _v24.4-Reset_UC_UTILITY_DB_UNLOAD.txt to empty the UC_UTILITY_DB_UNLOAD.

Solution:

Since version 26.0.0 there's a REST API endpoint to perform the same than the db unload tool for deleting data from a Client, see documentation , this endpoint wil no longer use the UC_UTILITY_DB_UNLOAD.

Please make sure to change your maintenance workflow to use the new REST API methods with REST Jobs instead of normal Unix / Windows Jobs invoking the tools.

Additional Information

If you are on a different than 24.4.x AE version and/or you would prefer to have the queries to perform the cleanup of this VARA, please open a Technical Support case referencing this article.