Anonymous_User Absent Member.
Absent Member.
1014 views

DW database growing, Purge job not working?


Ok, so we have two instances of MO4.7 as production, both Data
Warehouses are ~150Gb in size.
The BSW Historical Data Purge seems to be doing it's job just fine here,
the size of the databases are more or less constant.

Then we also have our dev installation, but here the Purge job doesn't
seem to be doing anything - the size of our database is forever growing,
currently it's somewhere around 330Gb in size. End of last year when I
started logging the size it was around 280Gb.
We have had problems with the Purge job not running for several months
here, but now it's fixed and the job seems to be running just fine every
night.
Although the formula.trc reports that alarms and series are being
purged, the size of the database and tables are still growing.

In the Data Warehouse Profile we have "retain this data" set to 90 days
in production, and only 10 days in development, but this doesn't seem to
have any impact.

Any idea what could be the problem? Why is the database still growing?


--
HakanBerg
------------------------------------------------------------------------
HakanBerg's Profile: https://forums.netiq.com/member.php?userid=702
View this thread: https://forums.netiq.com/showthread.php?t=46862

Labels (1)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: DW database growing, Purge job not working?


Your best bet is to work with support. Potentially there is a setting
or a patch difference between production and development.


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: https://forums.netiq.com/member.php?userid=1851
View this thread: https://forums.netiq.com/showthread.php?t=46862

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: DW database growing, Purge job not working?


Thanks, I suppose that might be a good idea 🙂


--
HakanBerg
------------------------------------------------------------------------
HakanBerg's Profile: https://forums.netiq.com/member.php?userid=702
View this thread: https://forums.netiq.com/showthread.php?t=46862

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.