Progress 8.3B and 8.3D. HPUX 11.00 and 11.11 . Multiple databases, multiple computers. Largest database 26 Gb with 8k block size; -B=80000 blocks; 3*APW; 1*BIW; 1*AIW.
Checkpoint interval is down to < 10 seconds at peak times on largest database.
I believe I need to increase BI cluster size from 512 kb to say 4096 kb.
Have a Disaster Recovery database which we are feeding AI files.
1) Expected syntax
proutil mydb -C truncate bi -bi 4096
2) If I change the BI cluster size on the Live database, do I need to stop AI on Live and re-create the Disaster Recovery database?
3) Is the change to the BI cluster size permanent, or does it have to be in the command line every time we truncate BI?
Checkpoint interval is down to < 10 seconds at peak times on largest database.
I believe I need to increase BI cluster size from 512 kb to say 4096 kb.
Have a Disaster Recovery database which we are feeding AI files.
1) Expected syntax
proutil mydb -C truncate bi -bi 4096
2) If I change the BI cluster size on the Live database, do I need to stop AI on Live and re-create the Disaster Recovery database?
3) Is the change to the BI cluster size permanent, or does it have to be in the command line every time we truncate BI?