Re: Why put logs away from rootdbs?

andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404060419.369f1be6@posting.google.com>... > What are the reasons why Informix keeps on about moving your logical > and physical logs away from rootdbs? Surely if the whole instance is > going into a single RAID 1+0 array it doesn't make any difference? OK, > a bit more to glean from onstat -D perhaps, but is there any other > benefit? A lot of it is historical. There are some things that must be in the first chunk of the root dbspace (rootchunk) such as the reserved pages. (There was a bit of relaxing of the rootchunk requirement in 9.4.) So by encouraging things not to be in the rootdbspace, there is a bit of protection of those objects. But realistically, much of this is historical... M.P. > > In a rare break with tradition for me, this is a REAL, IN-USE email > address. > > Andy Kent

"mpruet" <mpruet@comcast.net> wrote in message news:40676184.0404070847.d2752de@posting.google.com... > andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404060419.369f1be6@posting.google.com>... > > What are the reasons why Informix keeps on about moving your logical > > and physical logs away from rootdbs? Surely if the whole instance is > > going into a single RAID 1+0 array it doesn't make any difference? OK, > > a bit more to glean from onstat -D perhaps, but is there any other > > benefit? > > A lot of it is historical. There are some things that must be in the > first chunk of the root dbspace (rootchunk) such as the reserved > pages. (There was a bit of relaxing of the rootchunk requirement in > 9.4.) So by encouraging things not to be in the rootdbspace, there is > a bit of protection of those objects. > > But realistically, much of this is historical... I guess sysmaster/sysutils must also be there too? Can any of this be moved? What else cannot be moved? > > M.P. > > > > > In a rare break with tradition for me, this is a REAL, IN-USE email > > address. > > > > Andy Kent

"David Williams" <djw@smooth1.fsnet.co.uk> wrote in message news:<c51r7v$f6b$1@news7.svr.pol.co.uk>... > "mpruet" <mpruet@comcast.net> wrote in message > news:40676184.0404070847.d2752de@posting.google.com... > > andykent.bristol1095@virgin.net (Andy Kent) wrote in message > news:<ac5fb36.0404060419.369f1be6@posting.google.com>... > > > What are the reasons why Informix keeps on about moving your logical > > > and physical logs away from rootdbs? Surely if the whole instance is > > > going into a single RAID 1+0 array it doesn't make any difference? OK, > > > a bit more to glean from onstat -D perhaps, but is there any other > > > benefit? > > > > A lot of it is historical. There are some things that must be in the > > first chunk of the root dbspace (rootchunk) such as the reserved > > pages. (There was a bit of relaxing of the rootchunk requirement in > > 9.4.) So by encouraging things not to be in the rootdbspace, there is > > a bit of protection of those objects. > > > > But realistically, much of this is historical... > > I guess sysmaster/sysutils must also be there too? Can any of this be > moved? > What else cannot be moved? Yes, of course, sysmaster tables are pseudo tables. By default syscdr is in the root dbspace, but there is an addition parameter that can be put into the onconfig to shift it to another dbspace. > > > > > M.P. > > > > > > > > In a rare break with tradition for me, this is a REAL, IN-USE email > > > address. > > > > > > Andy Kent