Please help !
Posted in 1998
Topics: Storage & Space Management, Logging & Checkpoints
Friends, I'm in the midst of revamping an informix database which uses Informix Online Dynamic Server(v 7.12) and running on windowsNT.I've been an application developer all along and know very little about managing databases. I've completed the data modelling and the logical model is ready for conversion to the physical database.The database will have approximately 55 tables. I want to create the new database in a seperate dbspace, since we already have 3 databases sitting in the root dbspace on the server.I anticipate data in the range of 30-40k records for the database. The main questions i've are 1. How to create the dbspace and how to calculate the size of the dbspace? 2. Is it required to create database with logging option? If so, how do i calculate size of logical and physical log files ? 3. What is the relation between the size of the database and the dbspace? Any help in this matter would be greatly appreciated. Thanks in advance Reghu R.Nair mailto:reghu@comsysmgt.com