Universal Enterprise Controller Databases

Owned by Stonebranch (Deactivated)
Last updated: Jul 15, 2024
2 min read

Overview

Universal Enterprise Controller (UEC) uses databases to maintain agent, user, configuration, and event data.

Database Files

The UEC databases reside in three files:
 

Database Name

File Name

Contents

UEC database

uec.db

Definitions of agents, groups, users, SAP systems, and a record of updates to distributed components' configurations in a managed environment.

UEC transient database

uec.tmp.db

UES monitor events and component information that is temporary to support I-Activity Monitor. This file is deleted and created upon restart of UEC.

UES database

uec.evm.db

Universal Event Subsystem (UES) persistent events.

Database Management

Automated Database Cleanup

Two routines are run to clean up records that meet their expiration criteria from their UEC database.

  1. Routine for monitor events used for I-Activity Monitor.
  2. Routine for persistent events stored for the Universal Event Subsystem.

Both routines execute at UEC start-up. Thereafter, they are scheduled to execute one hour after the previous execution's completion. At the time of execution, all records that meet the expiration criteria are removed from their UEC database.

The following UEC configuration options control database record retention:

Memory Management

Berkeley DB uses a temporary cache in memory to manage its databases. If this cache becomes sufficiently large, it must be written to disk.

Berkeley DB has a default location for storing temporary cache files, but if UEC cannot access that location, or there is no space to write these files in the default location, the following error can occur in UEC, and UEC shuts down:

UNV5101D Database error: 'temporary: write failed for page XXXXX'

To work around this issue, the following steps will write the temporary cache files to the UEC database directory:


Step 1

For z/OS installations, mount the UECDB HFS or zFS dataset.

Step 2

Inside the UEC database directory (or, on z/OS, the mount point), create a text file named DB_CONFIG.

Step 3

Inside the DB_CONFIG file, add the following string:
set_tmp_dir *dbpath*
In this string, dbpath is the path to the location in which the database files reside.

Step 4

Start / restart UEC.