Search results

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

Rob -- thank you! I didn't know about the F7 step. It works for me now. ( Egg on my face, though, I should have looked in the KB. :( )

Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise I have worked with Progress/OE from v7 and often displayed schema tables (like _File). But since moving to a new environment with 11.7.4 whenever I try to display the definition via the Data Dictionary it says "The entered name does...

Yes, Patrice, I appreciate what you're saying. I do need a very expansive range for collecting table and index statistics on the production system -- but it has quite enough memory to support that. The system where I am having a memory problem is the Development/Testing server and on that...

Yes, Rob, I agree with that. As I mentioned the Development server has many copies of the production DB, but only two of them get moderately robust configurations -- the ones you might refer to as "Test" and "UAT". They are the two involved with SLDC and do get (for example) full values for...