Search results

I know that in the past there have been comments from Progress devs on the internal differences between _progres.exe and prowin.exe/prowin32.exe. The gist was that for batch mode, a character client is more efficient as it doesn't deal with window messages in its event loop. I am having...

It looks like prosoapview was discontinued after 11.7. https://community.progress.com/s/article/P120871 The article suggests to try Fiddler.

I wonder what happens if it can't acquire this lock, e.g. someone holds the exclusive schema lock to perform an online schema change. Is there any evidence of this in the logs, in the vicinity of the "limited logins" events?

Just when you think you've heard every crazy thing that can happen to replication, there's one more. Thanks for the info George. Do you have any sense of the cause of the "limited logins" message/state? What is the update level of 11.7?

I am not going to try to tackle all of this at once. This is not the existing structure file; it is an excerpt from the existing structure file. This area has a size of 112 GB, plus whatever may be in the variable extent, if anything. You say the database size is approximately 2 TB. Is...

The writer processes (AIW, BIW, APW) are performance enhancers, as @jdpjamesp said. However they are exclusive to the Enterprise RDBMS license so you cannot use them. The only helper process available to you is the watchdog (prowdog command), which you should use. "Too many" and "past-dated"...

There is also a -l3 parameter (in 12.8). The output is almost the same. With l3, it reports on mb_lstmod difference. There is no -l4. Also: Database area 60 has 15 blocks. (7001) block 1536 bk_updctr differ 1 0 (17151) block 1536 Object List number of objects mismatch for entry 2...

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...