Search results

Granted there isn't much of an argument to be had. Personally, I like to try to get it close to a useful value primarily because I have a utility that does random sampling of tables by randomly generating RECIDs and I can avoid a lot of wasted effort by having a RPB that is a better fit. But...

A table called "wrkfile" strikes me as something that might be worth discussing. Is this a table that contains temporary data? Do you write a bunch of things there, do something, and then eventually delete all of that data? If you do, then that would be something that could benefit quite a lot...

I wouldn't go so far as to say that mean size is "meaningless". Sure, it is not perfect and there are certainly cases where it doesn't work as well as something else. It is, however, readily available and it works reasonably well in many cases. That's worth quite a lot.

I haven’t tried this but… you could try restoring and then running proutil truncate area on the audit area. That’s not quite what you are asking for but it might get you the same result. As Rob says though - you should not be keeping large amounts of audit data in your production instance in...

At a very high level... You cannot migrate to PASOE *after* migrating the database. Classic appserver is NOT available on oe12, thus you must migrate your appservers before or during the migration. You DO NOT want to be doing that for the first time the same weekend that you migrate the...

The database upgrade procedure itself is simple and straightforward. All that you need to do is to run "proutil dbname -C conv1112". Of course, as you note, you need test everything and have backups and and a rollback plan. And a whole lot of that is very specific to your particular...

I'm thinking that there must be some error messages. Perhaps you could consider sharing them?

Thanks for updating the thread and closing the loop!

"Enjoys suffering" = "use PDSOE"? ;)

You are not obligated to use PDSOE to compile. That’s nonsense. Someone has misunderstood something. Progress sells compiler licenses for Linux. So, clearly, it is possible. There are certain things that you sort of, maybe, might, need PDSOE for in development, like generating PAAR files, but...

Did you translate that .lg file somehow or other? There are a LOT of messages whose text is strangely worded.

There is no "if you are using PASOE, change parameters X, Y, and Z like so" guidance. From a database perspective PASOE is just another client. You would make tuning changes to the db based on the planned client configuration and your expected workload - whatever that might be. If the PASOE...

Actually, I think it is good to keep it visible. You asked a question in good faith, showed code and data relevant to the problem, got an answer quickly, and confirmed that the reason was as Peter suggested. That is a very nice example of “doing it right”! We can all learn from that.

It is, of course, important to properly scope transactions but... dash ell, lower case, is not about LOCKS. That would be -L (upper case). Lower case -l is for the "local buffer". This is memory used by variables, workfiles (not temp-tables), and local copies of records...

To me it sounds like you have done “something” that you hope has resulted in replication being enabled. But whatever you did has not worked. Replication is obviously not functioning. Finding out why should be your focus. Start by explaining the steps that you took to enable it and please...

You cannot empty the extents while their status is LOCKED. You will need to fix that first. The information provided so far doesn’t help to identify why they are locked beyond the obvious “replication is not currently synchronized”. To get to the bottom of that some dsrutil status / monitor...

I would think that mostly you just want to review conmgr.properties and ensure that your script uses the same (or better) values for startup parameters and things like the number of APWs started etc. Then just stop using OEE... That is especially straight-forward if you are running on UNIX...

Seems like a bug… easy enough to fix it and test the impact.

It would be interesting to figure out how uniform the wait times are for all of the processes. From a "real world" perspective you probably don't want a situation where one or two ATM machines out of several hundred are fast but the remainder are ridiculously slow.

I'm glad that you figured it out but, just for completeness, if you had not figured it out we probably would have needed to ask you to share the content of load_vision.bat. We may have also needed to know what commands you used to create the .bd file in the first place.