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...
This seems to have been resolved in our test environment by upgrading from SP05 to SP07. PSC also did some testing on their side between the Service Packs and found a direct correlation between checkpoint duration and the size of -B/-B2. They have put it down to poor memory management on...
R&D 2 5
♀07/19/13 Activity: BI Log
13:16:48 07/18/13 22:40 to 07/19/13 13:13 (14 hrs 34 min)
Total Per Min Per Sec Per Tx
Total BI writes 3466430 3968 66.13 0.45...
R&D 3 1, is Latch timeouts good or bad?
♀07/19/13 Activity: Performance Indicators
13:13:53 07/18/13 22:40 to 07/19/13 13:13 (14 hrs 34 min)
Total Per Min Per Sec Per Tx
Commits 7704011...
Hi Tom
BI is on physical RAID 1+0 disk, fast array with 16 spindles. Nothing else on array other than .r code i.e. no other database technologies or services.
Would prefer to avoid regression testing for an SP upgrade (see my earlier posting), but if SP06 or 07 is the answer then I will...
Thanks Rob. Where in promon can I monitor LRU latch contention?
The mother of all change control processes is keeping us on SP05. I had to work extremely hard to push through an upgrade from 9.1D last March to 10.2B05. I would rather explore all options with SP05 before starting the...
The checkpoint duration is exactly the same with a small cluster size as I tried this last week which means UI performance is even worse as the pauses are more frequent. I raised the same issue with PSC and they suggested turning off the Alternate Buffer Pool altogether by setting -B2 to zero...
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
R&D. Advanced options
T. 2PC Transactions Control
L. Resolve 2PC Limbo Transactions
C. 2PC Coordinator Information
J. Resolve JTA Transactions
M. Modify Defaults
Q...
A BIW and AIW are running.
BI Clustersize is 262128kb, block size is 4kb.
The disk hosting the BI is < 10% active during the checkpoint.
Only thing that seems odd is that 'Writes by BIW' rarely gets over 50%.
R&D -> 3 -> 4 below
15:36:42
Ckpt ------...
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...
Thanks Stefan, that worked. I tried [winchar] and [startup], but not [winchar startup]. Typical, it was the one thing I had not tried.
Never used the character client before, only ever worked with prowin32.exe and this issue had me stumped. Your help is much appreciated.
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...
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.