OO Database Maintenance

220457

Micro Focus Micro Focus Supported

App Support Tiers

MICRO FOCUS SUPPORTED

Support via Micro Focus Software Support, with a ticket filed against the associated product.

PARTNER

Micro Focus offers a content partnership program for select partners. Support for Partner Content offerings is provided by the partner and not by Micro Focus of the Micro Focus community.

MICRO FOCUS COMMUNITY

Micro Focus Community Content is provided by Micro Focus for the benefit of customers, support for it is not available via Micro Focus Software Support but through specific community content forums.

COMMUNITY

Community Contributed Content is provided by Micro Focus customers and supported by them.

Micro Focus | Micro Focus Supported

Scripts used for the maintenance of the OO database: purging, index and size maintenance. Available for MSSQL, Oracle and PostgreSQL.
These scripts support only the non-containerized releases of the Operations Orchestration product.
1,706 downloads

See previous releases
Share
 

Product compatibility

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.0
484.2 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
364.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

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-5-1-2592 | Thu May 14 08:24:00 PDT 2020