Search results

  1. D

    Help!! Moved from 1K to 8K blocksize, now database pauses for minutes at a time

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

    Help!! Moved from 1K to 8K blocksize, now database pauses for minutes at a time

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

    Help!! Moved from 1K to 8K blocksize, now database pauses for minutes at a time

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

    Help!! Moved from 1K to 8K blocksize, now database pauses for minutes at a time

    (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...
  5. D

    Help! Data load from menu not working

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

    Help! Data load from menu not working

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

    Help! Data load from menu not working

    tamhas -- No .e, nothing in the log. Seems like it just fails to start the process at all, and doesn't tell anyone why.
  8. D

    Help! Data load from menu not working

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

    Help! Data load from menu not working

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

    bkset: Extent /u48/PRODATA/mfgprotst.d122 is below size -2147483648. (647)

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

    bkset: Extent /u48/PRODATA/mfgprotst.d122 is below size -2147483648. (647)

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

    "Unable to find web object file" even though files in propath

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

    "Unable to find web object file" even though files in propath

    Aha, I can run stuff from the File Tools menu. Good enough, I think!
  14. D

    "Unable to find web object file" even though files in propath

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

    Client claims database is "hidden"

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

    Experienced MfgPro consultant in Milwaukee

    I can also be reached via email at dprice8@wi.rr.com
  17. D

    Experienced MfgPro consultant in Milwaukee

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