Apologies if this has been asked before, but is there a method of diconnecting idle connections to an OE database? We are trying to maximise the available licenses under our concurrent user allowance and all attempts to fix the humans (i.e. get them to log off the sytem at end of shift) have...
Is there a way to reduce the checkpoint duration? There is plenty of advice on checkpoint frequency and I have followed that intently to get our checkpints to no more that every 5 minutes with 0 buffers flushed at peak load during the day, but as the footprint of the database increases so it...
There is probably a really simple answer to this, but it eludes me. I want to script the restore of a backup into a pre-existing database. Doing this manually is straight forward as I just type Y when prompted to overwrite the existing database, but I cannot get it scripted as the prompt gets...
Hi All
I have batch job written in ABL running against a Progress Enterprise RDBMS and was wondering if ABL was capable of parallel computation?
The database is running under 10.2B06 X64 on Windows 2008 R2 X64 Server. The batch jobs runs as a self service client on the server. The database...
Hi All
Thought I would share this one as its almost caused the failure of a very high value system upgrade project (Windows 2003/9.1D to Windows 2008/10.2B) at a client site. Luckily we found the solution a few days before go-live and all is on track now.
Apologies to those that already knew...
I am dumping and loading a database from 9.1D09 32-bit to 10.2B05 64-bit on Windows 2008 R2 64-bit. On brand new hardware under 10.2B05 I am getting a binary dump rate of over 300k (which I am very pleased with) records a second using a multi threaded dump file against a brokered database...
Hi
I am trying to get the character client _progres (10.2B05) on Windows (2008R2) to load up with a specific PROPATH so I can compile some .p's. However, nothing I seem to set as per documentation seems to work and _progress just opens with the default PROPATH. I have tried an ini file...
We are upgrading a site from 9.1D09 x86 to 10.2B05 x64. Both client and server OS is Windows, currently XP for clients and 2003 for database server. Does anyone have any deployment advice for how to get the database running on Windows 2008R2 SP1 x64 and the clients to remain on XP? We are...
Hi,
I am facing an issue with backward compatibility of Activex Controls which seem to be working fine in V9 but when I run the same window in OE one of the control(selecting the control) throws up the window.
Are there any known issues with backward compatibilty of Activex Controls.
Thanks...
Hi Everyone, hope you all had a good Christmas and New Year.
I dumped and loaded a very large (1.71 billion rows) 9.1D08 database over the holidays and all seemed to go well. No issues encountered at any point in the .lg file or otherwise. Tabanalys checked out between the old and new...
Hi all.
I am trying to run dbrpr against a 9.1D database with large files enabled and one or more extents over 2GB. Before the menu even presents itself I get and error stating 'Invalid file size for Extent X¿¼ of Area IDXDT'. The rest of DBRPR then fails to run. I can run it successfully...
Hi All
I am setting up a Progress MS SQL DataServer (10.1C04) against a SQL database (2008 R2 X64) that already exists i.e. I am getting the DataServer to pull the Schema into the Schema holder. My question is that are the PROGRESS_RECID and PROGRESS_RECID_IDENT_ Columns really necessary in...
Hi All
I was wondering if anyone has experience of dumping and loading a single table with over 500Million records. I am working on a 9.1D08 database running on W2003 Standard R2 which has severe database corruption. A Proutil tabanlays throws up repeated 5433 errors due to a table being...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.