Space issue on the SQL server

book

Article ID: 198607

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to create more space on DB by running utility jobs from AWI

Cause

Cause Type: Guidance request

Environment

Release : 12.2

Component : AUTOMATION ENGINE

Resolution

Resolution:  Configure the below jobs as per the documentation given in here.

1) REVISION_REPORT

2) REORG

3) UNLOAD

Check below documentation for more details on parameter options while configuring jobs.

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.2/AWA%20Guides/help.htm#AWA/Admin/inifiles/admin_ini_utility_db_reorg.htm



Below is the Example on how to configure the  jobs.

1) JOBS.WIN.AE_REVISION_REPORT
Command used: UCYBDBRR -B -C&CLIENTNR# -F* -D -D  -A

2) JOBS.WIN.REORG
Command used: ucybdbre -B -S&CLIENTNR#

3) JOBS.WIN.UNLOAD
Command used: ucybdbun -BREORG