John, Thanks for the tips. We are running 4.2.5 redback on UniVerse 10.0.19 on HP-UX.
There's definitely an issue with GC getting stuck when it reschedules itself to run very close to midnight. I've got it running again and I'm monitoring it. If it does get stuck in the future, I guess we'll just have to run GC manually (via cron or another background task) & disable the built in scheduler. I have resized the file to make it a lot larger, and I did keep it as a type 18. I was considering changing it to dynamic (99.99% of all our application files are dynamic - we came from PI/Open), but I'm not sure of any other implications of doing that to any of the WWxxx files. AdrianW -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Friday, 24 March 2006 6:57 AM To: u2-users@listserver.u2ug.org Cc: 'Stevenson, Charles' Subject: RE: [U2] RE:[UV:Redback] Automatic Garbage Collection not running Charles >From 4.2.6 you have WWSESSION to consider as well - AFAIK there is nor eason to do this manually nowadays. Historically UNIVERSE on UNIX had a specific issue.... Regards JayJay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: 22 March 2006 03:35 To: u2-users@listserver.u2ug.org Cc: Womack, Adrian Subject: [U2] RE:[UV:Redback] Automatic Garbage Collection not running > We recently ran into a problem where the garbage collection > (GC) process would no longer run (our WWSTATE file contained over a > million records!, and the application response time was abysmal). RedBack 4.2.3, UV 10.0.16, HPUX 11i. When we upgraded from 3.x we expected some enhanced garbage collection but it didn't seem to work as advertised, so we went back to handling it explicitly. For our ap we know anything an hour old is not needed, so we schedule a paragraph every 1/2 hour that does: SELECT WWSTATE WITH HRS.OLD >= "1" IF @SELECTED > 0 THEN DELETE WWSTATE where DICT WWSTATE HRS.OLD 01: I 02: (@DATE-DATE) * 24 + INT( (@TIME - TIME)/3600 ) IIRC, IBM suggests WWSTATE should be dynamic-hashed, but I ended up with file corruption once upon a time shortly after changing it to dynamic. Go figure. So I changed it back to Type-18 with a much larger modulus than I should ever need. All access is direct reads. The only filescan is the purge selection shown above, so an extra large modulus is perfectly efficient & disk is cheap. It works & "if ain't broke don't fix it", so I don't fix it. cds P.S. Strategy-7 is our support vendor, and their RedBack guy, Martin Fritter, has been a real gem to work with. I don't know much about RedBack and he's always gone the extra mile whenever I've needed him. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
