Search results

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

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

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

Linux 7.4 -- OE 11.7.18 The system I work on has Linux servers with Progress DBs and (classic) AppServers on Windows that connect to the Linux servers. The exact-same program code set resides on both Linux and Windows, so when compiles occur on Linus the new compiled code-set is copied to the...

Linux RHEL -- OE 11.7.17 Hi, I have a set-up that is pretty common -- TEST, UAT and PROD servers. We have an application that has both a character UI and via AppServers also a GUI UI. When a change is implemented, it often involves a rather large number of menu changes in the character...

11.7.17 on Red Hat Linux At present our Production system has xcoded source on it. I'm planning changing to have no source at all on Prod, but it will take a few months to get that done. In the meantime I'm learning about xcode. I have encountered it many times before but this is the first...

OE 11.7.4 on Linux Our prod DB is on a Linux server. It has four Windows hosts that connect to it that each support a classic AppServer (set to have 5 agents) -- with load-balancers. Our UAT and TEST e (This post got truncated! I'll have to re-type it!

Hi. This is not a Progress question, but I am sure Progress DBAs would be able to throw light on this problem. It's a question about how crontab works in RH Linux. I have a job that archives and purges audit data. It is very process-intensive and it was set to run several small slices of...

11.7.4 on Linux Hi DBAs, I'm testing an addition to the system that uses write and delete triggers on a selection of tables. The triggers exist on a Linux server and four AppServers. I was hoping to be able to "switch-on" the triggers at an exact moment. I thought of a few different ways...

11.7.4 on Linux Hello DBAs, Over a long period working with Progress, systems I have worked on have used a very straight-forward "rule" -- local users connect via "direct connect" (ie via shared memory) -- and remote users use client/server connections. However, in the system I work with now...

OE 11.7.4 on Linux. As per best advice -- I have always set-up Storage Areas as Type 2 -- and appreciate the various reasons why Type 1 Areas should never be used (except of course for Area 6). However .... the system I look after is a package and like nearly all cases of using packaged...

OE 11.7.4 on Linux. Although I've worked with Progress for a long time, I confess that my understanding of transactions and record scoping has many gaps. :confused: I have read (and re-read) presentations from Tom and Dan -- and I still have gaps. Here is a small test program: > cat...

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

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

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

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

Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise I have a Development server with 82 GB RAM and 21 GB swap. There are two copies of Production - each with 7.5 GB of buffers -- and another 23 copies that are also copies but have very small buffer allocations (2 MB each). Most of...

Linux 3.10.0-1160.2.2.el7.x86_64 x86_64 OE 11.7.4 Enterprise Hi, We have: -tablerangesize 350 -indexrangesize 550 ... and those settings comfortably accommodate the tables and indexes in our "user" system. By default, of course, the -baseindex and -basetable are both zero. As things are...

10.2B. Enterprise on Linux. Hi ... I have done many dumps/reloads in the past -- always using a fully-scripted binary dump/load method. All went very well. I am in a new environment where the DB is big (800 GB) and hasn't been "straightened-out" for a very long time. I am experimenting with...

Our PROD server is Linux with OE 11.7.4 - all CHUI. We use Windows servers for AppServers (Win Serv 2016 = 64 bit) OpenEdge offers a range of statistics about what happens on the DBMS -- via VSTs -- which we collect and analyse. Our AppServers handle a wide range of requests from many users...