Search results

How naive of me to imagine that working out how much memory various processes were consuming might be "easy". :) Ha! I have read and tried-out all sorts of forum posts on the subject and I've come to the conclusion that there is a kind of "Uncertainty Principle" at play here. When I use ps...

The errors are kernel messages "out of memeory". I have a monitor process that records many metrics including RAM and virtual memory every minute. Available virtual memory is always quite small and in the minute before an OOM event it gets really small and the next minute it jumps up by about...

Thank you Patrice, but two different servers are involved. VST statistics collection is on a Production system where there is no current issue with RAM or swap. It is a development server where I have the problem and VST statistics are only collected in rare cases where I'm investigating a...

Yes, Rob, I honestly have encountered that sort of logic! --------------- To be clear -- the question I'm asking is like this. We sometimes run out of swap. I am confident that if we added an extra swap partition of (say) 10 GB that would have zero impact on real memory and stop us running...

Thank you Tom -- that's an very interesting and useful article. :)

Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise I have a Development server with 82 GB RAM and 21 GB swap. There are two copies of Production - each with 7.5 GB of buffers -- and another 23 copies that are also copies but have very small buffer allocations (2 MB each). Most of...

Rob -- thank you very much for your really helpful replies! Yes, I had noticed that many system indexes are positive ... which was "odd". I was not aware of the _category field ... that will be quite helpful. In the past I have found the table/index activity information very useful for...

Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise Hi, We have: -tablerangesize 350 -indexrangesize 550 ... and those settings comfortably accommodate the tables and indexes in our "user" system. By default, of course, the -baseindex and -basetable are both zero. As things are...

Tom -- thank you very much for sharing that code .... I will give it a try. Ron.

Hi Rob - apologies for the delay in replying -- I got diverted onto other issues. Below are the responses to your questions. My earlier question was part of a "collecting ideas" thing -- because although I have dumped/reloaded more DBs than I can count -- this one is in poor shape -- and...

10.2B. Enterprise on Linux. Hi ... I have done many dumps/reloads in the past -- always using a fully-scripted binary dump/load method. All went very well. I am in a new environment where the DB is big (800 GB) and hasn't been "straightened-out" for a very long time. I am experimenting with...

Yes, indeed, classic AppServers.

Our PROD server is Linux with OE 11.7.4 - all CHUI. We use Windows servers for AppServers (Win Serv 2016 = 64 bit) OpenEdge offers a range of statistics about what happens on the DBMS -- via VSTs -- which we collect and analyse. Our AppServers handle a wide range of requests from many users...

Thanks very much for the reply, Rob. I was reasonably sure that it would work as you described. The issue you mention about the security of the data in the DEV environment is a very real concern to us and we are working on that. We don't yet have a solution -- but we are considering...

Enterprise 11.7.3 on Linux. Say I deploy TDE into production. At various times after that I need to copy a backup from PROD into various DEV environments that have not had TDE implemented on them. Will the backups restore properly if an appropriate key-store file is present? Or would I have...

Thank you Tom and Rob -- I'll take your remarks on-board as we develop our plans and policies for adopting TDE. Ron.

Hi .... I did get a temporary licence for TDE and set-up a test environment with it. I found that there is an abundance of information "out there" about TDE. It is all interesting and useful but it is very oriented towards the complexities of the product -- and a bit light-on with the simple...

Hi -- We use OE 11.7.4 on Linux (all chui). My company is considering employing encryption - so I'm boning-up on it and about to do a few performance tests. I'm told that if a self-serve client connects to an encrypted DB it is necessary to supply a passphrase. I can understand why -- but it...

I am adding to this post rather than create a new one because I will be facing a similar situation. I have a few hundred remote sites, all with "smallish" DBs (say 7 GB up to 20 GB) - all fairly fast and with quite a lot of disc space. We have a fully automated system that about once a year...

This problem has been solved. The detail I was after - and finally found - was that the Progress "usr" is stored in mon__qadi01 in table "mon_mstr". That allowed me to get the "real" user (known to QAD).