Search results

I ran this on two slightly different copies of sports2020 and got a lot of output. I can only imagine how much I/O it would do and output it would produce on DBs of a meaningful size. It is very interesting, but definitely not very user-friendly. I can see why this is undocumented. ;)

Interesting! Apparently it has some expectations for similarity between the databases. Compare 2 db has fewer user areas than the Compare 1 db. (17101) There are other cmpdb-related messages at 17102 and beyond.

That's what I get too. This must be an undocumented feature added for tech support? I can't find any reference to it in the docs or the KB. It also isn't listed in proutil -help.

This is a QAD-specific issue. Please do not cross-post to other forums.

I doubt if there is any public documentation of this. What is LogRead? A quick Google search didn't turn up much, apart from a command in some embedded Linux distros like OpenWrt.

When you make schema changes to a database, those changes are transactional; the are implemented via BI and AI notes. So when the database is a replication source, they propagate to the target databases. You don't have to intervene or make manual changes to the targets. If you plan to add new...

I don't know what you mean by this. Are you saying you think this disk usage isn't related to temp-tables and other AVM temporary files?

@Dan4gl Your inquiry is unrelated to the original post. In future, please start a new thread for a new issue. It seems that at some point Progress changed the way they handle session temporary files on Windows, in particular the DBI file. I don't know which version marked the change. It used...

Me neither. Just like they made an undocumented enhancement, sometime between 11.7.6 and 11.7.16 (a time after the life cycle change when updates were only supposed to contain bug fixes), to add per-object stats for Type 2 areas in prostrct statistics, making it actually useful. Thanks...

You mentioned doing cleanup (removing records); presumably from the largest table(s). "table-181" is 42.3% of the size of the data area. "table-234" is another 12.3%. I am guessing it involves one of these two? The rest are fairly small. If these tables will be purged occasionally it is...

That depends on what you are trying to improve. That part still isn't clear to me. Nor is the basis for the conclusion that a failure to improve (whatever it is that we endeavour to improve) is "highly likely". We've had a look at a handful of tables but none that are big (i.e. worth...

I assume the "RPB" column in your table is mean record size divided by 8192?

These tables are so tiny that it isn't worth worrying about doing any tuning for them. Presumably, in this 4 GB database there are some more interesting tables? If a table is very large/fast-growing, it should have its own area. And its indexes should have their own area. Of course, there is...

You're right James, the docs are not clear. The KB says that you need to use prorest ... -newinstance (create a new DB GUID) and then use proutil db -C epolicy manage keystore rebind. https://community.progress.com/s/article/000028091 https://community.progress.com/s/article/000028092 In my...

There are SaaS-bsaed OpenEdge applications. You can read about database multi-tenancy in the documentation. As for security and privacy, those can mean many things to different people, so some detail is needed. As always, your options will be better if you use the latest release and commit to...

I would hate to see that. Yes, the site could do with some more hands-on administration. But occasional spam aside, historically this site has had a very good signal-to-noise ratio. There is a lot of valuable content in all the posts of the regulars. It would be a shame to see that body of...

Good call Patrice! That helps a lot until the posts themselves are deleted.

I didn't check the 9.1D, as I already have them, but I was able to download individual 10.0A PDFs from the Wayback links. Thanks Stefan!

OECC monitors PASOE and databases, and we don't have a PASOE forum, so this thread may as well live here for now. ;) I haven't used OECC 2.0 yet. It is on my list to get to when I have a chance. Please keep us updated on what you learn with this issue!

Agreed. In the past, some have argued in favour of using fixed-length extents to avoid paying the (theoretical) computational cost of extending the files. OpenEdge now provides the ability to pre-extend variable-length extents, so that should prevent having to pay that cost, and thus this...