How can I tell if my DXgrid datastore is filling up, and what can I do when it gets full?

Products

CA Directory CA Security Command Center CA Data Protection (DataMinder) CA User Activity Reporting

Issue/Introduction

How can I tell if my DXgrid datastore is filling up, and what can I do
when it gets full?

Environment

Release:
Component: ETRDIR

Resolution

When a DXgrid datastore is created, it's size is fixed. It will not
automatically increase in size. Therefore, when a DXgrid datastore
increases in size past 60% full, there are a variety of alarms that
are generated by the DSA informing you to the fact that the data
hosted in the DXgrid file is increasing. These alarms will continue to
the generated as the datastore fills. The purpose of this techdoc is
to inform you of the alarms that you will see and how you can extend
the size the of the datastore once it grows to 100% full.

When a DXgrid datastore is created, the creation process will read the
DXgrid size parameter either from the:

DXmanager XML configuration

The "dxgrid-db-size" configuration parameter in the ASCII text
configuration files (when using DXnewdb)

Once the creation process has read the DXgrid size, it will commence
to create the datastore ".db" file on disk There are alarms that will
be triggered when a DXgrid datastore grows past 60% full. If the
datastore increases past 60% full, the DSA will trigger additional
alarms at 5% intervals. So in the DSAs alarm log you will see:

[232] 20190409.120709.996 DSA_I1220 DSA started: dxserver 12.0.18
(build 12105) Windows_NT 64-Bit

[232] 20190409.120709.996 DSA_I3200 License: dxserver 12.0.18
(build 12105) Windows_NT 64-Bit prefix ou=group01 entry total 19100

[232] 20190409.120709.996 DSA_I1150 DXgrid file usage: Filesize
6000000 Used bytes 3649816 (61%) Reclaimable bytes 0

[48] 20190409.120803.609 65% of datastore in use

[145] 20190409.120805.336 70% of datastore in use

[244] 20190409.120807.064 75% of datastore in use

[145] 20190409.120808.701 80% of datastore in use

[112] 20190409.120810.320 85% of datastore in use

[48] 20190409.120811.949 90% of datastore in use

[145] 20190409.120814.161 95% of datastore in use

[112] 20190409.120815.810 File space exhausted

[124] 20190409.120838.104 Assertion failed
(r:/branchsp18.new/dxgrid/src/dsa/dxgrid/grOC.c98)

[124] 20190409.120838.104 Assertion failed
(r:/branchsp18.new/dxgrid/src/dsa/dxgrid/caAdd.c1250)

[145] 20190409.120850.822 File space exhausted

If you are happen to logged into DSA console (aka DXconsole), you
would see:

DXconsole sample

The resolution to this issue is to extend the DXgrid data store. This
can be achieved using the DXtool called "dxextenddb". The process for
extending a datastore is as follows:

Shutdown the DSA

Edit the dxgrid-db-size parameter within the DSA's initialization file
(DXHOME/config/servers/{dsaName.dxi})

Run "dxextenddb {dsaName}"

Restart the DSA

Once the DXgrid datastore has been extended and restarted, you can
continue adding or modifying entries.

As an addendum, modifying the trace levels in the DSA's trace log will
provide you with additional information when the datastore is getting
full. Setting a trace level of "warn,error" will generate additional
information similar to that listed below:

> [232] set trace=warn,error;
* [48] 20190409.120803.609 65% of datastore in use

* [145] 20190409.120805.335 70% of datastore in use

* [244] 20190409.120807.064 75% of datastore in use

* [145] 20190409.120808.701 80% of datastore in use

* [112] 20190409.120810.320 85% of datastore in use

* [48] 20190409.120811.949 90% of datastore in use

* [145] 20190409.120814.160 95% of datastore in use

* [112] 20190409.120815.810 File space exhausted

? [112] 20190409.120815.811 WARN : Cannot add entry to cache -
rolling back

? [124] 20190409.120838.098 WARN : Adding new object class:
organizationalPerson

? [124] 20190409.120838.103 WARN : Adding new object class: person

? [124] 20190409.120838.103 WARN : No room in file for new
attributes

? [124] 20190409.120838.104 WARN : Cannot add object class to file

* [124] 20190409.120838.104 Assertion failed
(r:/branchsp18.new/dxgrid/src/dsa/dxgrid/grOC.c98)

* [124] 20190409.120838.104 Assertion failed
(r:/branchsp18.new/dxgrid/src/dsa/dxgrid/caAdd.c1250)

? [124] 20190409.120838.104 WARN : Cannot add entry to cache -
rolling back

* [145] 20190409.120850.822 File space exhausted

? [145] 20190409.120850.823 WARN : Cannot modify entry in cache -
rolling back

> [232] logout;