Search results

Hi, The aim of this post is to determine whether -directio is the answer. Are there any downsides to using it? My research indicates an almost 90% improvement. All from Sync Time, which correlates to Progress KB - What value should -B be set to?, although this suggests it will only improve...

Hi All, We are planning an upgrade to OpenEdge 11.6.3 shortly and have a lot of ODBC connections currently in use. In order for a smoother upgrade and an easier back out does anyone know of any limitations that the 10.2B ODBC driver has when connecting to OE11? We have done some initial...

Hi, OE10.2B SP07 64bit, Windows Server 2008 64 bit. I wondered if you could help, i'm racking my brain trying to figure this out. We have 3 brokers setup on our database, 1 for ABL and 2 for SQL. We have one user (currently) connected via SQL. How can i tell which broker/server the user is...

Hi all, Our supplier is upgrading our storage to VMAX LUN's and asked if we would consider formatting the disks to 64k. We currently have 10.2BSp07 running a 4k database block size on 4k disks on windows server 2008. I've just read the below: Optimal NTFS block size for Progress 10.1C...

Hi All, OE 10.2BSp07 32-Bit on Wndows Server 2008 64-bit. We seem to be having some issues with Checkpointing. The issue is much much worse during online backups but during the day we are experiencing the issues too. I've been looking into this and the issues seem to tie in with checkpoints...

OE10.2BSP07 Windows 64bit. OK, so by what magic is the CLOB-Type set within the .df file? Here's my .df file ADD FIELD "cField" OF "CTable" AS clob FORMAT "x(8)" INITIAL ? POSITION 3 LOB-AREA "Data Area" LOB-BYTES 104857600 LOB-SIZE 100M CLOB-CODEPAGE "1252" CLOB-COLLATION...

Hi All, On OE10.2BSP07, Windows 64bit. I'm trying to determine if/when APW's are being stretched. Currently we have one running - I know this should be probably be more, I just need to justify it. Currently within promon the 'Writes by APW' sits at a nice 98%, a sample of an hour is the same...

OE10.2BSp07 64-bit Windows 64-bit. Hi all, I have a question regarding after-image file sizes; basically i'd essentially like to reduce the size of the AI files that we transport to DR. Is this at all possible? Our process runs every 15 minutes and over a course of a 24hour period the total...

Hi All, We're looking at doing some spring cleaning on our database and want to look at removing some indexes. We plan to monitor the _IndexStat over the next month or so and see what Indexes are being used and which aren't. Currently i've run a few tests and wanted to check what the fields...

Hi All, OpenEdge 10.2BSP07 64bit Windows 64bit. An SQL user is having an issue and it getting "Column value exceeding its max length or precision". Now i'm aware of dbtool and although it takes an age it doesn't report on the column that is providing the grief. The column in question is a...

Hi all, OE10.2BSP05 64 bit, Windows 64bit. Hopefully just a quick one. Just got the below error message. there's quite a few entries around with error 1147, mainly surrounding disk space but nothing i can find with error 1103. Has anyone ever experienced this? Our process takes a backup on one...

OE 10.2BSP05 Windows 7 64bit Hi All, I'm looking at creating an incremental .df file programatically. I Started to use a .bat file, but my knowledge isnt great but the benefit is that you can use dump_inc.p easily; which i have done. But for better understanding and manageability i've...

Hi All, Me again! :) OE10.2BSp05 Windows 64-bit. I'm racking my brain trying to work out why this doesn't make sense... My aim is to monitor database extents and report on anything heading towards the variable extent or anything already in there. I have the following code: DEFINE VARIABLE...

OE10.2BSp05 64-bit. Windows 64-bit. Hi, I've just finished a dump and load on a database and structured all tables and indexes appropriately. Following the changes I have re-run a dbanalys and some of the output is here: Area Name Area Num Table Index BlkSz Idx Flds Lvls Blks...

Hi all, OE10.2 Windows 7 64bit. Just a quick question; Is there a way to deactivate indexes quickly (by command) or in bulk? I'm moving tables and some wont move due to the inactive index, so i've activated them through the proutil command and i'd like them deactivated again. I know they...

Hi all, We have a report that runs on a Live system every 15 minutes and usually takes between 1-2 minutes to run. From Thursday morning it started to take 40+ minutes to complete. Nothing I'm aware of has changed. Apparently this has happened before. The user that has run this report has...

Hello all, Were using OE10.2B on Windows server 2008 64bit. Firstly, i'm probably going about this the wrong way so a nudge in the right direction would be nice. I'm trying to determine whether a table is sat in the wrong storage area and would benefit by being moved to something a little more...

Hello, I was wondering whether someone could possibly help. We are wanting to add an index to our database so it would be nice to have after-imaging switched off whilst this goes ahead. When we use aioff then probkup enableai, the AI sequence starts again at 1. Is there a way to stop AI...

Hi, I am currently in the process of creating reports to determine tables that are (wrongly) stored in the schema area of a database. The data i want is available from the tabanalys command but its difficult to interpret into reports and takes forever. I have managed to go through the VST's to...