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: [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
