Recent content by ron

No, Tom, I am only testing using -thread 1. I wasn't aware that a range can be specified -- and I don't see why I would consider that. From (limited) testing using 4 threads it looks like Progress divides-up the table into reasonably equal numbers of records.

Thank you -- as always, some very interesting and helpful comments. I confess that I don't understand George's remarks about indexes. A multi-thread dump does't use any index (as far as I know) -- it just deals with a block of records within separate ranges of recid ... or have I missed...

Yes, I have done D/Ls previously like that with several parallel dumping streams (likewise for loading) -- but the ultimate result was that the end-to-end time for the full process is (more or less) the time to dump then reload the very largest table. And that's why I'm looking to be able to...

RHEL 9.2 Linux + OE 12.8.3 To recover a lot of "deleted" space after purging, I face having to reclaim the storage on a few large databases (1TB to 2TB), and of course the down-time needed is a major factor. I am looking at various ways to tackle this, one being a D/L. I have done many D/Ls...

No, Rob, neither. TDE is planned to be implemented a few weeks after the upgrades of OE and the change to PASOE. We don't have Replication; we have a 'cold' DR server and ship AI to it every 12 minutes. The business accepts the risk of losing up to 12 mins of transactions. Thanks for the...

Linux 9.2 -- OE 11.7.20 --> OE 12.8.3 We are getting close to the end of a major project upgrading from OE 11 to OE 12 and changing from Classic AppServers (on Windows) to PASOE on the DB server. Conversions/upgrades have been done and thoroughly tested on numerous non-production servers --...

Thank you very much for the replies. One thing that surprised me was that the table name "PUB.bpaytranscode" exists as a plain-text string in the AI file, but that name is not shown in the AI scan. I will study your replies during the next few days and see if I can extract further details. Ron.

Linux 9.2, OE 11.7.20 We switch AI files every 12 minutes. Last Friday a user deleted a record from a small reference table and I need to know who did it. I copied all the AI files from Friday into a temp directory and used strings/grep to find which AI file contained a reference to the table...

Thanks very much Tom! I will experiment with that and see how I go. Ron.

OE 11 allows a number of online schema changes but in my experience they nearly all require no user session connections to be active when the change is made. Getting human users off the system is quite easy, but stopping the various external connections to our other systems and especially to...

The actual schema change rarely takes more than a few minutes -- as you say. That's no problem. "The" problem is coordinating with the external systems and 3rd parties that we connect-to ... then then shutting-down everything -- more than one DB and separate AppServers. (We plan to put PASOE...

Thanks very much for you reply! I guess my post was a bit confusing -- we're all organised as far as the migration from 11.7 to 12.8 -- and PASOE -- and RHEL 7 to 9. It is a very big job and lots of testing is needed -- but I'm sure we can handle that. The actual problem I'm focusing on is...

OE 11.7.17 -- RHEL -- Development on 9.3, Production on 7.9. We are planning to move from OE 11.7.17 with "Classic AS" and RHEL 7.9 to OE 12.8 with PASOE and RHEL 9.3. Since our systems run 24/7, getting any down-time at all is really hard and getting a window of more than about 3 hours is...

Thank you, Stefan! I will investigate md5.

RHEL 9.3 -- OE 11.7.18 I have just discovered that Progress documentation mentions "SIGNATURE-VALUE attribute". It says "Use this attribute to determine if a procedure changed between different versions of your application." Can someone explain exactly what this means, please? I understand...