Re: rootdbs size?

Ricky wrote: > > What would be a reasonable size for rootdbs on a machine > with about 4.5 gigs of data in a separate database. > > Our rootdbs is currently 75000kb > > I was shown a config file from another machine like ours(IBM F50) > > Their rootdbs was much larger 992000kb. > > These are supposed to be the same type of machines. Their database is > > much faster I have been told. Properly configured rootdb is ONLY used for the sysmaster and sysutils databases and for certain sorting and temp table operations depending on the contents of DBSPACETEMP and PSORT_DBTEMP. Its size should not affect performance at all. My rootdbs tend to be 500MB to 2GB simply because that was the size the sysadmin made the disk partition he designated for me to use and I don't want to have any other chunk sharing I/O with the rootdb so instead of wasting it I just allocate it all. -- Art S. Kagel & Family kagel@erols.com