Re: Q: Space allocation

a) Temp space is used for things like sorting. So it depends on your queries. b) logical and physical logs should be sized to allow for a peak interval of transaction activity. The logical logs as a whole must be able to handle all transaction activity on the system. If you have transactions that modify a large amount of rows in your database you need logical logs that can accomadate them. And don't forget to set aside space for index changes which are also logged (i.e. deleting 50000 rows from a table will require space not only for the data rows nut also the index entries. There are some minimal guidelines for the physical log (check the manual) - but in my opinion the logical logs are more important. Use the onlog utility to view logical log entries. You can search the logs based on session id. c) see b. d) see b. Bill > > > 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 ? > b) the size of the logical and physical logs ? > c) the ratio to maintain between the number of logical and physical > logs ? > d) the ratio to maintain between the total size of the database and > the total size of all logs > > Thanks in advance > > Vasudev > > rvasudev@inf.com > >