Search results

In summary, Tom, I believe you are saying that getting the current transaction# and later testing for its existence in _Trans will not work when the update is caused by a remote connection. I don't really understand why that is so -- but I do appreciate that being able to re-access the record...

CDC was considered at length but it caused problems for us that I won't expand on here. If a process local to the server updates the DB a repl trigger executes. Details of the update go into a table A that only holds "in abeyance" data. A separate record is created in table B holding the...

Thank you Tom -- but I'm still not clear about this. On the Linux server where the DB resides the replication trigger captures details about the update and uses DBTASKID to get the current transaction#. Another process checks these "in abeyance" details and tests _Trans to see if the...

Thank you Tom -- but are you saying that the client cannot discover the current transaction ID? If a replication trigger executes on the client -- how can one know that the current transaction is completed and therefore operation is committed? Ron.

Hello again DBA experts .... I am progressing with the new system using replication triggers. So far -- it's all working very well. However -- we have "classic" AppServers connected and I see that it's necessary for the trigger code to also exist locally on the AppServer systems. If the...

Thank you very much for your very helpful and prompt responses! The code in the KB Article is what I'd worked out as probably the right approach, but I was concerned that there might have been something missing. For sure -- between the two ideas of using an incremental df and using a program...

OE 11.7.4 on GNU/Linux. Hi DBA people! I have a test DB set-up and working that has a set of write and delete replication triggers. In all cases the path names to the trigger files are "relative" and will, therefore get resolved via the PROPATH to be in a directory that is associated with...

We believe the transaction problem will be handled by having the equivalent of the replqueue in the source database ("A") and all the rest in the second database. That's how we are proceeding. I want to include statistical accounting ... count a replication initiation by a trigger -- and then...

Hi Larry. Can FreeTDS work directly with an ABL program? Or is it necessary to call it from (for example) Perl? Can it work in a continuous stream mode -- or only to deal with a "batch" -- or a full table? Ron.

Hi Larry -- the application I am dealing with will be written in Progress ABL. It will need to send records to an SQL database and insert them. This will be a continuous process. Can FreeTDS handle that?

Thank you Larrry! I will research FreeTDS and see how I go. Ron.

Hello, ( OE 11.7.4 on Linux ) This is very much a newbie situation. I'm very familiar with Progress -- but very unfamiliar with SQL. I need to send records from an OE database to an SQL Server database over a LAN. We already have a number of external applications that access our OE...

Unfortunately, Tom, the changes are required in "near real time". We did look at the audit feature in Pro2 -- but it was much too "batchy". We currently do use Auditing -- but prefer to avoid it. :(

I edited the reply to say why Pro2 and CDC were not used -- but maybe you missed the edit.

I should have mentioned that we spent a lot of time with Progress discussing both Pro2 and CDC to satisfy this requirement but both presented problems. It had nothing at all to do with licencing -- we would have preferred to use either Pro2 or CDC. Our requirement is to capture every...

OE 11.7.4 on Linux Hello .... We're developing a system to extract details from database "A" using replication triggers. When the trigger executes we want to copy the details we're after to table "X" -- and write a controlling record to table "Y". So ... an "X" record will contain the data...

Back to B2 after a few years! Now on: Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise I have re-read Rob's very informative post (above) -- and a number of Progress Articles -- but a few issues are still not clear to me. We do online backups twice each day specifying...

Thanks Rob and Tom! I will keep researching, although it's hard to spare the time researching problems on a Dev system when I have many Production issue to keep me busy. :( The OOM-killer always targets two brokers when it hits -- the broker for the TEST and UAT environments and affects...

Thanks Rob. I'd already seen that one (and several others, by the way). Allocating swap doesn't mean that anything actually "gets" swapped -- it's just that the space in swap maps the whole virtual memory space so every process has to "own" a section of swap. But actual swapping would only...

I appreciate that this is really a Sys Admin question -- but in my experience Progress DBAs are experts on nearly everything that opens-and-shuts ... so here goes. Following on from the above discussion, my Sys Admin and I appear to have a different understanding of virtual memory. I would...