Re: Q: Space allocation

In article <6p3g9d$28l$1@news.xmission.com>, RVASUDEV@Inf.COM says... > > > > Hi, > > Our platform : HP 9000 / HP-UX 10.20 / Informix Online Ver. 7.x > (x = 23, 24, 30). > > Query: > > (We searched the online CD-Docs). > > 1. Is there any guideline for calculating : > > a) space to allocate for TEMP DB space : > is there any default as a percantage of the total database size, > OR > is it application-specific and dependent on things like number and > complexity ofqueries and sizes of result sets ? The latter. It's a function of the number and size of temporary tables and sorts that your application is going to do. > b) the size of the logical and physical logs ? Again, a function of the level of update activity and the frequency of checkpoints. Try starting with logical logs at 20% of your application dbspace size, and physical log at 5%. > c) the ratio to maintain between the number of logical and physical > logs ? See b) > d) the ratio to maintain between the total size of the database and > the total size of all logs See b) Try setting tempdbs to 10% of the application dbspace size, then monitor all the above settings as your application beds in. Neil Truby Chase Manhattan Bank Bournemouth, UK neil.truby@chase.com