Recent content by MikeHorn

Thanks for the reply Tom. It looks like we've found the culprit now though. We've increased the MINPERM/MAXPERM kernel parameters to use up to 80% of real memory for file handling. We are mainly an Oracle shop and this apparently crucifies Oracle DBs so the default server build is 30%. In...

and to answer your other questions Ron Using fibre channel connection to a SAN for disk storage, RAID 1+0

Yes, I was a little light on details wasn't I? 64 bit 10.1A02 AIX 5.3 IBM p550, 4 processors, 16GB RAM, DB split over 4 filesystems, AI & BI also have their own filesystems. Type I & Type II storage areas in use. nmon reports system 75% idle, promon reports 99% buffer hits. No major paging to...

Hello gurus. I have a 94+ GB database that I am dump and loading onto a new server. I can d&l the vast majority of tables within an 18 hour time frame and am proposing to d&l the two or three largest history tables off-line, using some 4GL to load the last week or so just prior to go-live. One...

I've just been reading PSC's Platform & Product Availability Guide. I see that the EDITING statement is deprecated as of 10.1A with a replacement feature of a WAIT-FOR, then PROMPT-FOR is being deprecated as of 10.1B with a replacement feature of SET or UPDATE. I thought I'd post this as a...

Hi I've got some old (originally developed under v8) code that I'm converting to 10.1. When I open a number of .w files I get the internal error warning message "A stack overflow error has occurred", and it recommends shutting down the workbench. Now, I know I don't really have enough memory...

Hi AIX 5.3 Progress 91.E02 Before I start I'd just like to state that I know I'm probably not doing this as efficiently as possible, but I'm loading the database for an evaluation and doing other things whilst I wait... After a binary dump & load of data I am running a full IDXBuild on our...

Progress 9.1D06 Win2K Using SQL Explorer the following SQL92 statement keeps returning a syntax error. Why? IF EXISTS (SELECT tbl FROM sysprogress.systables WHERE "tbl" = 'DESPHIST2') DROP TABLE pub.DESPHIST2; Any and all advice gratefully received! TIA Mike