Re: DB Sapces....

Hi you, - onbar can backup and restore dbspaces - several scan threads should support your parallelism on your SAN disks (PDQ and fragmentation) - different dbspaces might have different page-sizes ( cache buffer pools ). You might create an 8kb pagesize dbspace for index data and an 2kb pagesize dbspace for your data fragments. regards, Weidi Tam OShanter schrieb: > Hello Friends, > > I'm looking for the reasoning in deciding on how many DB Spaces to use on a > given system. > > Specifically, if using a SAN where disk IO and LUN size isn't an issue, what > would be the reason for using multiple DBSpaces as opposed to 1 large one? > > > Also, is a 60/40 ration of data space to log space a valid one when sizing? > > I'm sure this is a pedestrian question for most of you, but I am currious. > > Tam.