Search results

Hi guys, Thanks for the responses. It is definitely a date format 99/99/9999. Maybe as TheMadDBA suggests, the dates are out of range. Maybe were inputting 20015 rather than 2015 every now and again.

Hi Osborne, I'm in the middle of running that exact query, its 200 million of 2 billion down so far! - I'm hoping it is data! Thanks.

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

As Cringer suggests we need more info. Although on the face of it; it doesn't seem like a tilde issue, more an issue with quotes. This seems to work: OS-COMMAND ('Start "C:\Documents and Settings\carlo\Desktop\Restart"'). But more info would be nice...

Thanks for the feedback guys! The backups are performed online and copied to another server, i guess it tried to take the copy before the probkup command had finished then? I'll look at the -red command too. This is part of our DR plan! :eek:

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

Thank you all, much obliged!

Thanks for the info; I'm well away to improving the systems! One stumbling block i'm having though is convincing my boss to move to 8K with the Windows standard being 4K. According to Progress; "In Windows, the operating system assumes that files and memory are handled in 4KB chunks. This means...

Ah ok. So basically i should call a script from inside ABL. I thought that might be the case.

No. Nothing. But when I reference DUMP_INC_DFFILE and it says cannot find.

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

Ah great. Thanks for the info. I'll take a look at ProTop too. Thanks again!

Hi TheMadDBA. Thanks for the response. I have imported the dbanalys and used that previously. But to monitor the extents I saw a post that suggested to use VST's hence why used this path. Although the block details are the same from the VST's as they are in the dbanalys. It does seem another...

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

Splendid. Many Thanks!

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

Thanks for the explanation, Rob. That should save me time in the short term. As for the long term, I will look at getting these removed. I'll use your response to back up my argument :)

Sorry Rob, I missed the 'B' off. 10.2B i think its SP05 and I was saying windows was 64-bit. Although OE is 64bit also.

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

Haha! Found it. Thank you! 08/28/15 Activity: Summary 16:49:11 08/28/15 16:34 to 08/28/15 16:49 (14 min 50 sec) Event Total Per Sec |Event Total Per Sec Commits 293370 329.6 |DB Reads 459812 516.6 Undos...