At 10:19 AM 3/8/96 +0100, Dutch BGC on-site support wrote:
>On Thu, 7 Mar 1996, Tom Hogarty wrote:
>
>> I would be interested in seeing some of your
>> tbconfig, in particular I'd like to know how long your checkpoints are
taking.
>
> We recently changed our checkpoints from 1800 (30 m) to 500 (8 1/3 m).
I think Tom's looking for the time a checkpoint takes to complete, not how
long between checkpoints. The info will be in your online.log.
> Unfortunately, the original DBA (DataBase 'Acker) chose to use the rootdbs
> for everything.
Aaaaaghghghghgh!!!!! (Unanimous chorus, I suspect! :)
You need to move data into different DBSPACEs, logs into yet other DBPACES
and take control of the disk layout. Try to ensure that each DBSPACE is on a
separate physical disk. Try moving heavily hit tables into their own
DBSPACEs. If you're on v7, try to set up TEMP DBSPACEs and investigate table
fragmentation.
So, apart from anything else, you should re-layout your disks under the LVM.
Ouch.
With my sincerest sympathy.