Thanks Rob. We actually bumped up the buffers from ~500 in hopes it would resolve the issue with hanging (flailing).
Thanks for the cluster advice, I think you guys have nailed it. I found some more supporting evidence, this locking up during checkpointing they describe sounds exactly like...
Thanks, we do have -spin though it doesn't show up here (that one was a recommendation from you or Rob that saved us a while back -- I'm really in your debt here!). It's in the startup script, I should really get that in the .pf for consistency.
Disks are very new and fast (including...
Thanks Tom -- we have 20G of RAM, we actually can't even use all of it because of the issue with quadrants in HP-UX 11.11 that limits us to using 1.75G for shared. GLANCE says total mem usage never over 50%.
I will check the BI cluster size, thanks.
It's been okay since we upped the...
(The 8.3A nightmare continues...)
So we finally get this 8K database (matching our 8k OS blocksize) loaded, everything seems great (i.e. much faster than 1K)... but now and then we're getting a very nasty pause. Database just hangs, not responding, acts just like an AI/BI stall except there's...
That was my thought too... but it does work in single-user, and for individual tables in server mode -- the same tables that fail when I run them together (any more than one, it fails in server mode).
I am baffled.
I am getting a .e for every file now, because I didn't start the single user session with -yy 1930 (default is 1950, servers parms are 1930) but we don't have any 1930-1950 data so I think that's okay -- at least, all the dates look right.
http://www.xencraft.com/resources/i18n-startup.html
Thanks Rob, that sounds like good advice. I'd like to do that but unfortunately they're not empty, to minimize the outage time we preloaded about 90% of the historical data (which could not be done through the tool anyway due to 2G limit). The pre-loads of historical data into the big tables...
Hello, suddenly having a strange problem -- I cannot load multiple .d files into our two production databases using the Data Dictionary tool. Single files are okay, but on both databases if I try more than one file the screen just flashes and it doesn't load.
This process worked fine with both...
Re: Filled extent, getting: bkset: Extent [name].d122 is below size -2147483648. (647
Thanks, I've been explaining that to our DBAs as well. Fortunately, now I have benchmarks to prove it, so the move to 8K blocksize is now scheduled. Unfortunately, it requires about 12 hours of downtime even...
Filled extent, getting: bkset: Extent [name].d122 is below size -2147483648. (647)
This is a Test database, version 8.3A (please don't throw things at me! it's not my fault, honest!) on HP-UX 11.11, it filled up a variable extent to the 2GB limit and now it's complaining the extent is...
I mean it really is in the propath -- the propath tool itself finds the file!
It actually compiles just fine from the File Tools menu. I'm not sure why the Editor has issues, but since I can compile with File Tools I think I'm okay.
The Editor just seems to be generally screwy. The Save...
Hello, newbie question: I'm using Webtools from home over VPN, connecting via a link, and getting
"Unable to find web object file"
for anything I try to run, even though the files are clearly in the propath. I think it worked the other day when I was physically at the location and using...
I have a group of clients, not very technical, who want me to create a bunch of trigger-based export programs for their Progress app. Easy enough... but they claim the manufacturer of the product (NewStar or something) has somehow "hidden" the database structure.
I'm assuming what they mean...
I have several years Progress experience, mostly with MfgPro but a few months of Syteline as well. I’ve also done a little Unix scripting, and some work in VB and .NET. I have experience in designing and developing systems around the specific needs of the users. I develop a good rapport with...
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.