Keeping Your Informix rootdbs Lean and Clean By Joe Lumbley, Informix Pro
When Informix is installed with default options, all of the elements of the database are placed in the initial dbspace, which is called the rootdbs. The Informix installation process generates the minimum configuration that works and does not attempt to optimize any database elements.
One problem with this default installation is that Informix places its logical log files and physical log files in the rootdbs. And one of the most common mistakes that rookie Informix DBAs make is to leave the logical and physical log files in the rootdbs—or even create entire databases there. For performance and maintainability reasons, those log files should really occupy their own dbspaces. This 10-Minute Solution shows you how to avoid this problem.
Informix's default installation places the logical and physical log files in the rootdbs. This can cause severe performance and maintenance issues for DBAs if not dealt with early on.
There are several things you need to do in order to keep your rootdbs lean and clean:
Confirm the contents of rootdbs.
Choose the right disk spaces for the log files.
Place the logical and physical logs in their own dbspaces.
Whose responsibility is it to make sure that configuration errors do not happen? Should the designer handle these issues or should it be left to the onside DBA? Discuss it in the informix.general discussion group!
