Re: Help on SPACE REQUIRED BY ONLINE

Fernando.Collalti@orbit.net ("Collalti, Fernando") wrote: >Hello and Thanks in advance, >I need to configure and test Informix OnLine 7.12 UC3 >on a HP9000 E35 server with 64MB RAM(HP-UX 9.04) and 1CPU. >Actually I'm using Informix-SE 5.04, and the database is 450MB. >The server has 3 HD of 2GB each, for a total of 6GB of disk space. >Question: >Considering that I need 1.5GB for the system(HP-UX, users account, swap, >software and future growth) >a)With the remaining 4.5GB, how big should be my "critical" rootdbs > (included physical logs and logical logs) excluding the 450MB database > that will be located on a separate chunk? >b)Could I use the 3 disks(2GB each) like this: > -disk1: 1.5 system and the rest for a future chunk > -disk2: a unique chunk of 2GB for the rootdbs > -disk3: "split" the 2GB in two chunks for two separate dbspaces(to locate > the actual 450MB database) >Details: >Usersthreads: 50-70 >HP-UX page size: 2k >Database: 450-600MB >Disks: 3 of 2GB each(totally mirrored with Raid) >HP-UX: 9.04 >Please give me a "starting point" in order configure the engine. It is my >first time with OnLine and it is very difficult to evaluate spaces and >disk layout!!!! >Regards. >Fernando >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >Fernando Collalti >System/Database Administrator >Orbit Communications Company >Via Raffaele Costi, 60 >00155 ROME >ITALY >Phone: +39 6 2254 3474 >Fax: +39 6 2254 3810 >e-mail: fernando.collalti@orbit.net >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ I would not create my rootdbs near 2 gig. In 7.1 the tempspace can be allocated outside of root and if you use the no log feature in the application will not be logged. If you do not create tempdbspaces as temp then it will default to rootdbs and will log these tables. This can use a lot of log space. Informix recommends that logical logs and physical logs set on seperate disk from root. In your case that will not buy you a lot since you only have really 2 disk for informix but if you go ahead and set them up in their on dbspaces you can move them to a different disk later if your application grows without wasting alot of space in rootdbs. When you initialize use the minimum number of logical logs (3) and a small physical log and then use the onparams command to move the physical log and to create the other logical logs in the physical log dbspace and the logical log dbsapce. Be sure to create you one or more tempdbspaces and be sure to turn the temp flag on when you create them. You really do not want to use the disk with unix on it for informix if you do not have to, but this might be a good place for some temp space. Most of our applications we make root 60-100m, llog 200m, and plog 20-30m. Hope this gives you a starting point. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com