Search results

Relying on logged startup parameters and their values is very hit-and-miss, especially with secondary brokers. The older the release, the worse it is (i.e. they just don't log much at all). Any database running under 11.5 - 11.7 should have an _DbParams VST, and the __SrvParam-* arrays in the...

I had never heard of DBConfigTool.sh before. What does it do?

Did you find an article that said this process is unsupported? If so can you share that? Database dump and load (whether by ASCII or binary dump) is in fact the only supported method of migrating a database from one OS to another.

Those are the basics, and if your database is very small, you can get away with a simple proutil -C idxbuild all. If you have a meaningful amount of data (a production-like DB), e.g. several GB or more, you likely want to specify options on that command to tune its resource utilization and...

There are undoubtedly lots of threads here about database platform migration. I'd suggest a site-specific Google search for related terms: dump & load, migration, etc. At a high level, you need to dump the data from your source database and load it into a target database. Dump and load can be...

More info on the conv1112 issue: https://blog.wss.com/upgrading-to-openedge-12

I asked about replication because not everyone is aware that, as of OE 12.3, it is possible to upgrade replicated databases to OE 12.x without having to reseed. And I asked about TDE because there is a data-loss bug in proutil -C conv1112 when TDE is in use with certain conditions.

Just curious, are OE Replication or TDE in use?

I'd suggest a follow-up conversation with the auditor about the perceived business risk. If they want the option to invoke a post-migration fallback, after a go/no-go decision has been made for "go" and new writes are happening in OE 12, then that suggests to me that they don't have confidence...

For what it's worth, the text "state", the name of the table from which I deleted the record, was not present in my ai scan verbose output. I wouldn't focus on the table name.

Welcome George! :)

"DELETE FROM" looked odd to me too. But it does compile in 10.1B, and it behaves like "DELETE".

The ai scan verbose output won't contain the table name. It contains a summary of the change notes. Let's look at a simple example (from 11.7.16). I created a copy of the sports database. I created four AI areas and two new Type 2 areas: $ cat add.st d "state":20,128;8 . d...

Your English is fine. :) (or my Spanglish is improving?) There is a lot to unpack here. If we're seeing all of the purge code here, and not just the bit that does the record deletion, then you are not archiving the data and you are not causing a long-running transaction that would cause BI...

Seconded. Do not use -i, ever. I wouldn't even mess around with -r if I were you. You need to know what you're doing and understand the consequences of your actions to be using such things in production. I have seen this many times in the past. Someone decides to delete a large number of...

Welcome! If you have an issue, I suggest you create a new thread, and do so in the appropriate forum (Development).

Look at https://www.progress.com/oedk .

Some more detail is required about the problems you are trying to solve. What does "segment it" mean to you? It sounds like a solution that you envision to some problem. If so, what is that problem? The same goes for "more easy to use"? Easier than what? What usability problems are you...

In your second post it seems like you just ignored what I said. Why would you insist on not specifying -Mpb for a secondary broker when I just told you that you should always specify it, and that the fact that you didn't specify it is contributing to your problem? I already outlined detailed...

You haven't specified your OpenEdge release. This is important to know when discussing broker parameters. Three major points: Some broker parameters interact with each other. All of their values need to make sense together. Currently, they don't. These include -n, -Mn, and all values of...