Hi Joe, At 03:39 PM 2/28/2002 -0500, you wrote: >Environment: >Server: 4.1.3.0 >Platform: S390 > >1. Logmode: We're going to change the Logmode from Normal to Roll Forward. What >determines the amount of disk I'll require?
You need enough log space to hold all the db changes between scheduled db backups. So it depends on how much activity you have and when you want db backups to occur. You should also set the dbbackuptrigger as a safety valve; it will kick off a dbb when the log gets nn% full. I am on s/390 also; I set the trigger up to direct incremental dbb's to sms managed disk. My log is 7,146 megs; if you upgrade the server code 4.2.(1.9) you can make the log more than 5.3GB, up to 13GB. You can do a 'q log f=d' and monitor the cumulative consumption value to see how much you need for a day or between scheduled db backups. >2. Bufpoolsize: We're going to increase from 24576K to ?. What's the determining >factor? Monitor the cache hit % in 'q db f=d'. The rule of thumb is to get it up to 98%. My bufpoolsize is 262144k. You can dynamically changes this with the setopt command. >3. Mpthreading: We're going to turn it on. Are there any considerations I should >concern myself with? Can't say much about mpthreading; my processor has only 1 engine, but tivoli recommended it anyway, so I turned it on. >None of this info is in the manual that I'm aware of. I get a log of "try this" form >Tivoli support. Unfortunately, I don't work in an environment where I can "try this" >without first knowing what >the repercussions are. > > >Regards, >Joe Wholey >TGA Distributed Data Services >Merrill Lynch >Phone: 212-647-3018 >Page: 888-637-7450 >E-mail: [EMAIL PROTECTED] ---------- Bill Colwell C. S. Draper Lab Cambridge Ma.
