Automic Workload Automation

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?

There are a sequence of batch utilities that you should be running periodically to maintain these tables; UCYBDBar (decides what should be archived), UCYBDBre (decides what should be reorg'd), and UCYBDBun (unloads them from the database and into a flatfile archive), in that order.

They are well documented in the online help.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

Original Message:
Sent: 12-02-2020 04:43 PM
From: Kerem Ergun
Subject: AH table cleanup query

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?

I know of course but DB utility is not running (deletes only recycle bin) if ILM installed on a system.
Original Message:
Sent: 12-02-2020 07:41 PM
From: Pete Wirfs
Subject: AH table cleanup query

There are a sequence of batch utilities that you should be running periodically to maintain these tables; UCYBDBar (decides what should be archived), UCYBDBre (decides what should be reorg'd), and UCYBDBun (unloads them from the database and into a flatfile archive), in that order.

They are well documented in the online help.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA

Original Message:
Sent: 12-02-2020 04:43 PM
From: Kerem Ergun
Subject: AH table cleanup query

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?

You can Check and Drop/Switch out an ILM partition directly from the Partitions list in the Administration perspective

/Keld.
Original Message:
Sent: 12-03-2020 02:07 AM
From: Kerem Ergun
Subject: AH table cleanup query

I know of course but DB utility is not running (deletes only recycle bin) if ILM installed on a system.
Original Message:
Sent: 12-02-2020 07:41 PM
From: Pete Wirfs
Subject: AH table cleanup query

There are a sequence of batch utilities that you should be running periodically to maintain these tables; UCYBDBar (decides what should be archived), UCYBDBre (decides what should be reorg'd), and UCYBDBun (unloads them from the database and into a flatfile archive), in that order.

They are well documented in the online help.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA

Original Message:
Sent: 12-02-2020 04:43 PM
From: Kerem Ergun
Subject: AH table cleanup query

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?

Don't forget the client 0000 in your reorg process as it is often the reason why the DB increases.

Even with ILM you need to process the full maintenance cycle Archive-Reorg-Unload with a proper setting to remove all records not included in the ILM processing. This should not make the size of the DB growing very fast if you don't but can create some issues on a long term.

Alain
Original Message:
Sent: 12-08-2020 08:47 AM
From: Keld Mollnitz
Subject: AH table cleanup query

You can Check and Drop/Switch out an ILM partition directly from the Partitions list in the Administration perspective

/Keld.
Original Message:
Sent: 12-03-2020 02:07 AM
From: Kerem Ergun
Subject: AH table cleanup query

I know of course but DB utility is not running (deletes only recycle bin) if ILM installed on a system.
Original Message:
Sent: 12-02-2020 07:41 PM
From: Pete Wirfs
Subject: AH table cleanup query

There are a sequence of batch utilities that you should be running periodically to maintain these tables; UCYBDBar (decides what should be archived), UCYBDBre (decides what should be reorg'd), and UCYBDBun (unloads them from the database and into a flatfile archive), in that order.

They are well documented in the online help.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA

Original Message:
Sent: 12-02-2020 04:43 PM
From: Kerem Ergun
Subject: AH table cleanup query

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?

it can not be dropped because the partition is the last and the biggest partition. There is no any other partition after because the ILM is not running. So, Automic DB keeps the data and growing day by day on the last partition. Because of this, it needs to be deleted with DB script I think.

Kerem
Original Message:
Sent: 12-08-2020 08:47 AM
From: Keld Mollnitz
Subject: AH table cleanup query

You can Check and Drop/Switch out an ILM partition directly from the Partitions list in the Administration perspective

/Keld.
Original Message:
Sent: 12-03-2020 02:07 AM
From: Kerem Ergun
Subject: AH table cleanup query

I know of course but DB utility is not running (deletes only recycle bin) if ILM installed on a system.
Original Message:
Sent: 12-02-2020 07:41 PM
From: Pete Wirfs
Subject: AH table cleanup query

There are a sequence of batch utilities that you should be running periodically to maintain these tables; UCYBDBar (decides what should be archived), UCYBDBre (decides what should be reorg'd), and UCYBDBun (unloads them from the database and into a flatfile archive), in that order.

They are well documented in the online help.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA

Original Message:
Sent: 12-02-2020 04:43 PM
From: Kerem Ergun
Subject: AH table cleanup query

There is ILM problem in an Automic v10. DB size's increased so much because of ILM problem. It must be reduced to be able to upgrade the system because it takes to much time while upgrading. Is there a cleanup script for AH and RT tables?