Description

Scripts used for the maintenance of the OO database: purging, index and size maintenance. Available for MSSQL, Oracle and PostgreSQL

Releases

Release
Size
Date
OO Database Maintenance 5.2
539.3 KB
  |  
Oct 13, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Release notes

Fixed MSSQL deep clean procedure to improve performance of delete.

Fixed on MSSQL a potential endless loop on next delete batch population.

Languages
English
Files
OO Database Maintenance 5.1
538.2 KB
  |  
Sep 14, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Release notes

Added support for OO 2020.08.

Added MySQL procedures starting with 10.60. MySQL procedures only compatible with 5.6 and 5.7

Reduced min batch size to 10,000 where previously was set for 1,000,000 in order to reduce resource contention on weaker databases.

Languages
English
Files
OO Database Maintenance 5.0
495.7 KB
  |  
Mar 19, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.02 · 2019.07 · 2019.11
Version 2020.02
Release notes

Added support for 2020.02, added purge remote debug procedure, fixed a possible collision issue on purging of running exec configs.

Languages
English
Files
OO Database Maintenance 4.9
376.0 KB
  |  
Nov 19, 2019
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Release notes

Added support for 2019.11.

Created new procedures for collecting and deleting historical data that utilize actual tables instead of in memory structures for faster and more reliable deletion.

Created a standalone procedure for deep clean in order to be able to run only the deep clean procedure instead of both regular purge and deep clean.

Added hard stops and error codes for both timeout and database error in order to avoid padded runtime.

Purge procedures now support the option to continue a timed out purge.

Before installing the new procedures make sure to run the included script for creating the supporting tables.

Created sample invocation scripts for postgresql procedures.

Languages
English
Files
OO Database Maintenance 4.8
223.6 KB
  |  
Sep 3, 2019
More info Less info
Product compatibility
Version 10.2 · 10.10 · 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07
Release notes

Added 2019.07 to support matrix.

Added OO_EXECUTED_FLOW_GRAPH table to purge historical data.

Added for 2019.07 OO_RUNNING_EXEC_CONFIGS to purge plans procedure.

Removed retention period for running execution plans.

Languages
English
Files
OO Database Maintenance 4.6
494.1 KB
  |  
Jan 18, 2019
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Release notes

Added support for 2018.12

Languages
English
OO Database Maintenance 4.5
494.5 KB
  |  
Sep 25, 2018
More info Less info
Product compatibility
Version 2018.12 · 2018.05 · 2018.08 · 2018.09
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80 · 10.85
Release notes

Added support for OO 2018.09

Languages
English
OO_Database_Maintenance 4.4
494.0 KB
  |  
Jul 16, 2018
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05
Release notes

Added support for 2018.05.

Added suport for purging running execution plans.

Languages
English
OO Database Maintenance Scripts 4.3.1
618.9 KB
  |  
Mar 7, 2018
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Release notes

Fixed MSSQL index  maintenance procedure.

Added MSSQL script to view current index fragmentation and page count

Languages
English
OO Database Maintenance Scripts 4.3
618.2 KB
  |  
Dec 4, 2017
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Release notes

Added support for Operations Orchestration 10.80

Languages
English

Similar items

Similar apps are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.

Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the Marketplace Terms of Service and Micro Focus Terms of Service
Since you are downloading an app from the Micro Focus unified Marketplace using an Access Manager account, you need to also accept the Micro Focus Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service and the Micro Focus Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2020-10-2-3328 | Wed Oct 14 04:20:43 PDT 2020