Search results

Ran into a pickle - added - SQLWidthUpdate ON in on a 11.6 database and having some performance issues. Reading that it should be possible to update the parameter with the database online: Progress Documentation using either promon or _DbParams VST. I'm not seeing option 16 - adjust startup...

This is a continuation of Answered - Can (SQL) UPDATE STATISTICS hamper performance of ABL AFTER the fact - NO! that took a new direction. Current omsize is 1024, database objects are 2623. Below are samples from protop and promon for approximately the same 60s interval. Protop...

OE 11.6 / RHEL 5.11 - A little bit nervous to try it. I'm worried about any potential negative side effects on ABL AFTER you run UPDATE STATISTICS. I'm aware it'll use lots of resources while you run it. But we are not 24/7 shop so I can find some down time.

I would like to access, (guess I should say expose), our OE 11.6 database residing on RHEL 5.11 using, (should probably say through), a rest web service. We don't have Open Edge studio licensed. And before I embark on reading the 390 pg docs It'd be nice to know. The section mentions "tools...

On OE 11.6, RHEL 5.11 in the procedure editor: Don't remember if/when I used index hins before. But I can't get it to work. SELECT Order.orderNum, Order.entDate, Order.entCode, Order.whsLoc, Order.totMerch FROM Order WITH (INDEX(updatedAtIdx)) WHERE...

Been trying to figure this one out for a a while w.o. success. What am I missing here? OE 11.X They say SELECT DISTINCT = BREAK BY & FIRST OF: Progress KB - What is an ABL equivalent for a SQL SELECT DISTINCT? BUT FOR EACH icsec NO-LOCK WHERE cono = 1 AND icsec.altprod = '33-835' BREAK...

I'm querying an OE 10.2B database running on RHEL 5.11 over as a linked server odbc. Specifically a on a date range being part of a composite index. If I run this SQL query from the OE development on the server it finishes in a couple of seconds. However, if I run it from SQL management studio...

I started a query against a sql data server which I later cancelled. It looked like the cancellation was stuck, so I closed the session. Bad move it seems. Even though the session is gone, it looks like the query is still chugging on. And yes, it was a bad query as well. Is there a way to...

Progress 10.2B03 / RHEL 5.11 - yep I know both are antient. Webe upgrading to OE 11.3 in Dec but I can't wait that long. We have a situation where a SELF service user got disconnected and left a transaction with subsequent locks. Proshut disconnect doesn't let us finish him off. 1. His...

We're in the process of migrating a Progress installation, 10.1B, from AIX 5.3 to RHEL 5.10 on VMware Vsphere 5.1. Any suggestions and experieences to share on how to configure the vm especially when it comes to disks. I'm debating on whether to use LVM or just straight virtual disks. And if...

We are planing on migrating OE 10.1B03/AIX 5.3 to OE 11.X/(RHEL /CentOS 6.5). I was under the impression that a text dump and load was required for this operation. But I seem to remember having seen here or elsewhere that's not the case. Does anyone know? Also, if both are possible, which one...

Hello, We are looking into accuiring backup software for vmware that's able to backup our RHEL Progress 10.2B server . We want to be able to snapshot a vm with a running database in a consistent state. We are looking at Veeam and Netvault. Anyone else have any experience of this? On another...

Hello, We are running OE replication between a production server and a backup server. Currently the AI files are of fixed size and fairly large 500 MB ~ 4-6 hours of business. On a regular basis a script archives full extents to a backup SAN. We'd like to change the script and force extent...

We are in the process of establishing Fathom site replication between two remote sites. The way this has been done in the past is to create one full offline Progress backup and one incremental backup of the source database. And while the source database is down transport the backups to the...

We are purging a large number of records in several tables. The purges all fit this pattern DEF VAR min-id AS INT NO-UNDO. DEF VAR max-id AS INT NO-UNDO. DEF VAR num-records AS INT INITIAL 0 NO-UNDO. DEF VAR trans-active AS INT INITIAL no NO-UNDO. DISABLE TRIGGERS FOR LOAD OF big-table...

We are running 10.2B and are prepping for a migrations. As a part of that we are purging a large number of records. The way the purge currently goes is: DEF VAR min-id AS INT NO-UNDO. DEF VAR max-id AS INT NO-UNDO. DEF VAR num-records AS INT INITIAL 0 NO-UNDO. DEF VAR trans-active AS INT...

We are planning on migrating an OE 10.2B database from AIX to RH Linux. But have very little time at our disposal. All the tables is still in the schema area. I'm looking for ideas on how to speed things up and split it up if possible. Does it make sense to grab the data files from the source...

Hello, I'm curious to know if there is any significant performance cost to running proutil -C dbanalys against a database that's otherwise busy running mostly reports off hours. TIA for any input.

Hello, Trying to create linked OE 10.2B databases in SQL server 2005 64 bit running on Windows 2003. We are using the Open Edge 10.2B 64 bit 5.30.00.98 ODBC driver by DataDirect? I'm able to successfully create and test the connection for the ODBC data source against the Open Edge database...

I have heard rumors but not yet seen anything. Does anyone have any info?